| 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: | Whole Thread | Raw Message | 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
| 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? |