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

Re: Bug #638: Buggy select statment with numeric

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
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 14:29:11
Message-ID: 20020422072554.K81937-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Mon, 22 Apr 2002 pgsql-bugs(at)postgresql(dot)org wrote:

> Florian Steffen (mailing-list(at)urbanet(dot)ch) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> Buggy select statment with numeric
>
> Long Description
> A select statement with a where clause on a numeric column tested
> for equality against null always return empty result. With ISNULL
> everything is fine, but not with the = operator.

This is correct behavior.  NULL=NULL is unknown not true.  Older versions
had a hack to make an explicit =NULL the same as IS NULL for certain
clients that emitted such statements when they meant IS NULL.  This is now
off by default but can be turned on using the set variable
TRANSFORM_NULL_EQUALS.


In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-04-22 14:56:05
Subject: Re: 7.2.1: pg_dump of UNIONed VIEWs broken
Previous:From: Thomas LockhartDate: 2002-04-22 14:19:25
Subject: Re: Bug #638: Buggy select statment with numeric

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