Re: problem selecting rows with null value

--On Wednesday, March 12, 2003 19:55:00 -0600 Taral <taral@taral.net> wrote:

> 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...
There is a GUC (read postgresql.conf) parameter for that.  I don't know
what it is
off hand, however.


--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749