Re: [INTERFACES] selectecting not null varchars.

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: Joseph Shraibman <jks(at)p1(dot)selectacast(dot)net>
Cc: "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [INTERFACES] selectecting not null varchars.
Date: 2000-02-24 20:04:40
Message-ID: 38B58ED8.FDE3E3C7@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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;

Cheers,
Ed Loehr

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Ross J. Reedstrom 2000-02-24 20:40:06 Re: [INTERFACES] selectecting not null varchars.
Previous Message Joseph Shraibman 2000-02-24 19:46:54 selectecting not null varchars.