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