Re: Bug #638: Buggy select statment with numeric - Mailing list pgsql-bugs

From Thomas Lockhart
Subject Re: Bug #638: Buggy select statment with numeric
Date
Msg-id 3CC41BED.B76232E@fourpalms.org
Whole thread Raw
In response to Bug #638: Buggy select statment with numeric  (pgsql-bugs@postgresql.org)
List pgsql-bugs
> A select statement with a where clause on a numeric column tested
> for equality against null always return empty result.

This is correct behavior per SQL9x standards. NULL is *not* a value, but
represents the absense of information so tests FALSE in comparisons of
any kind.

hth

                    - Thomas

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #640: ECPG: inserting float numbers
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #641: LIBPQ Linking with the static library on the WIN32 platform fails connections with "unknown host name".