Re: problem selecting rows with null value

From: Taral <taral(at)taral(dot)net>
To: Jord Tanner <jord(at)indygecko(dot)com>
Cc: Matthew Phillips <mphillips(at)timing(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: problem selecting rows with null value
Date: 2003-03-13 01:55:00
Message-ID: 20030313015500.GA3608@taral.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)taral(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rosenman 2003-03-13 02:35:44 Re: problem selecting rows with null value
Previous Message Jord Tanner 2003-03-13 00:55:31 Re: problem selecting rows with null value