Re: problem selecting rows with null value - Mailing list pgsql-general

From Taral
Subject Re: problem selecting rows with null value
Date
Msg-id 20030313015500.GA3608@taral.net
Whole thread Raw
In response to Re: problem selecting rows with null value  (Jord Tanner <jord@indygecko.com>)
Responses Re: problem selecting rows with null value  (Larry Rosenman <ler@lerctr.org>)
List pgsql-general
On Wed, Mar 12, 2003 at 04:55:31PM -0800, Jord Tanner wrote:
> Use 'IS NULL' or 'IS NOT NULL' like this:
>
>     select * from pleah where bar IS NULL;
>
> '=' does not work for null values.

I was pretty sure there was supposed to be an automatic rewrite for that
since "= NULL" is so common...

--
Taral <taral@taral.net>
This message is digitally signed. Please PGP encrypt mail to me.
"Most parents have better things to do with their time than take care of
their children." -- Me

Attachment

pgsql-general by date:

Previous
From: Jord Tanner
Date:
Subject: Re: problem selecting rows with null value
Next
From: Larry Rosenman
Date:
Subject: Re: problem selecting rows with null value