Re[2]: Re: very big problem with NULL - Mailing list pgsql-general

From Alexey Borzov
Subject Re[2]: Re: very big problem with NULL
Date
Msg-id 2219746813.20010613163340@rdw.ru
Whole thread Raw
In response to Re: Re: very big problem with NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: very big problem with NULL  (Bruno Wolff III <bruno@wolff.to>)
Re: Re: very big problem with NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Greetings, Tom!

At 13.06.2001, 00:20, you wrote:
TL> Grant <grant@xactcommerce.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



pgsql-general by date:

Previous
From: "Erick Papadakis"
Date:
Subject: RE: Re: Does PostgreSQL support EXISTS?
Next
From: Bruno Wolff III
Date:
Subject: Re: [SQL] ORDER BY what?