Re[2]: Re: very big problem with NULL

From: Alexey Borzov <borz_off(at)rdw(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Grant <grant(at)xactcommerce(dot)com>, missive(at)hotmail(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re[2]: Re: very big problem with NULL
Date: 2001-06-13 12:33:40
Message-ID: 2219746813.20010613163340@rdw.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings, Tom!

At 13.06.2001, 00:20, you wrote:
TL> Grant <grant(at)xactcommerce(dot)com> writes:
>> However, the last time i checked, NULL does not equal to 1, 2, 3, or
>> anything else besides NULL.

TL> NULL does not equal NULL, either. Read the SQL spec, or any of the
TL> many prior coverings of this territory in our list archives ...

Er, how about this stuff?

newweb=# select version();
version
---------------------------------------------------------------------
PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)

newweb=# select null=null;
?column?
----------
t
(1 row)

--
Yours, Alexey V. Borzov, Webmaster of RDW.ru

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fabrizio Mazzoni 2001-06-13 13:07:32 sum of row values..
Previous Message Erick Papadakis 2001-06-13 12:22:11 RE: Re: Does PostgreSQL support EXISTS?