Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group