pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feednull = null
2+ messages / 2 participants
[nested] [flat]
* null = null
@ 2002-01-19 16:39 chester c young <chestercyoung@yahoo.com>
2002-01-19 17:45 ` Re: null = null Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: chester c young @ 2002-01-19 16:39 UTC (permalink / raw)
To: pgsql-sql
the following took me by suprise:
egg=# select null=null;
?column?
----------
t
if this were true, for example, then only one null key could be in a
unique index, which is certainly not true.
i thought the philosphical idea behind null in SQL was you didn't know,
which can't have equivalence (as versus the pragmatic idea in C where
null is a dead end pointer, which can have equivalence). or have I
been too involved with my Oracle databases?
__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: null = null
2002-01-19 16:39 null = null chester c young <chestercyoung@yahoo.com>
@ 2002-01-19 17:45 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2002-01-19 17:45 UTC (permalink / raw)
To: chester c young <chestercyoung@yahoo.com>; +Cc: pgsql-sql
chester c young <chestercyoung@yahoo.com> writes:
> the following took me by suprise:
> egg=# select null=null;
> ?column?
> ----------
> t
This is a Microsoft-compatibility kluge that is going away in the next
release, or at least not being enabled by default.
regression=# select version();
version
---------------------------------------------------------------
PostgreSQL 7.2b5 on hppa-hp-hpux10.20, compiled by GCC 2.95.3
(1 row)
regression=# select null = null;
?column?
----------
(1 row)
regression=# select null IS null;
?column?
----------
t
(1 row)
regression=# set transform_null_equals to 1;
SET VARIABLE
regression=# select null = null;
?column?
----------
t
(1 row)
See the 7.2 docs at
http://developer.postgresql.org/docs/postgres/functions-comparison.html
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-01-19 17:45 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-01-19 16:39 null = null chester c young <chestercyoung@yahoo.com>
2002-01-19 17:45 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox