Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] selectecting not null varchars.

From: Joseph Shraibman <jks(at)p1(dot)selectacast(dot)net>
To: "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] selectecting not null varchars.
Date: 2000-02-24 21:46:47
Message-ID: 38B5A6C7.9F79A138@selectacast.net (view raw or flat)
Thread:
Lists: 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.



In response to

pgsql-interfaces by date

Next:From: Tom LaneDate: 2000-02-24 22:23:46
Subject: Re: [INTERFACES] selectecting not null varchars.
Previous:From: Ross J. ReedstromDate: 2000-02-24 20:40:06
Subject: Re: [INTERFACES] selectecting not null varchars.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group