| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Taral <taral(at)taral(dot)net>, 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 02:35:44 |
| Message-ID: | 6180000.1047522944@lerlaptop.lerctr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
--On Wednesday, March 12, 2003 19:55:00 -0600 Taral <taral(at)taral(dot)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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua Moore-Oliva | 2003-03-13 03:37:29 | Re: Audit trail |
| Previous Message | Taral | 2003-03-13 01:55:00 | Re: problem selecting rows with null value |