Re: [INTERFACES] selectecting not null varchars. - Mailing list 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