Sender: jks@p1.selectacast.net
Message-ID: <38B5A6C7.9F79A138@selectacast.net>
Date: Thu, 24 Feb 2000 16:46:47 -0500
From: Joseph Shraibman <jks@p1.selectacast.net>
Organization: Xtenit
MIME-Version: 1.0
To: "pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] selectecting not null varchars.
References: <38B58AAE.B28DD6CB@selectacast.net>
	<38B58ED8.FDE3E3C7@austin.rr.com> <20000224144006.B11186@rice.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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