"Ross J. Reedstrom" wrote:
> On Thu, Feb 24, 2000 at 02:04:40PM -0600, Ed Loehr wrote:
> > Joseph Shraibman wrote:
> > >
> > > select * from directory where h != null ;
> > > ... gets you this:
> > > ERROR: parser: parse error at or near ";"
> > Postgresql's SQL "not equal" operator is "<>"...Try this:
> > select * from directory where h <> null;
That didn't work.
> Which is still throw an error. and the SQL standard way to test for
> NOT NULL is:
> SELECT * FROM directory WHERE h IS NOT NULL;
That did. Thanks all.
In response to
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 2000-02-24 22:23:46|
|Subject: Re: [INTERFACES] selectecting not null varchars. |
|Previous:||From: Ross J. Reedstrom||Date: 2000-02-24 20:40:06|
|Subject: Re: [INTERFACES] selectecting not null varchars.|