Re: Bug #638: Buggy select statment with numeric

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mailing-list(at)urbanet(dot)ch, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #638: Buggy select statment with numeric
Date: 2002-04-22 15:00:49
Message-ID: 14990.1019487649@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
>> select * from t where n ISNULL;
> n | s
> ---+--------------
> | asdasdasd
> | qqqqqqqqqqqq
> (2 rows)

>> select * from t where n=NULL;
> n | s
> ---+---
> (0 rows)

This is not a bug.

However, you can make 7.2 work in that braindead Microsoft-compatible
style if you wish to. See the transform_null_equals parameter.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ian Morgan 2002-04-22 15:55:50 Re: 7.2.1: pg_dump of UNIONed VIEWs broken
Previous Message Tom Lane 2002-04-22 14:56:05 Re: 7.2.1: pg_dump of UNIONed VIEWs broken