Re: [INTERFACES] selectecting not null varchars. - Mailing list pgsql-interfaces

"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.