Received: from mail.austin.rr.com (sm1.texas.rr.com [24.93.35.54])
	by hub.org (8.9.3/8.9.3) with ESMTP id PAA03085
	for <pgsql-interfaces@postgresql.org>;
	Thu, 24 Feb 2000 15:01:52 -0500 (EST)
	(envelope-from eloehr@austin.rr.com)
Received: from austin.rr.com ([24.27.40.102]) by mail.austin.rr.com with
	Microsoft SMTPSVC(5.5.1877.197.19); Thu, 24 Feb 2000 14:02:34 -0600
Sender: ed
Message-ID: <38B58ED8.FDE3E3C7@austin.rr.com>
Date: Thu, 24 Feb 2000 14:04:40 -0600
From: Ed Loehr <eloehr@austin.rr.com>
X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Joseph Shraibman <jks@p1.selectacast.net>
CC: "pgsql-interfaces@postgreSQL.org" <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] selectecting not null varchars.
References: <38B58AAE.B28DD6CB@selectacast.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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