pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
null = null
2+ messages / 2 participants
[nested] [flat]

* null = null
@ 2002-01-19 16:39  chester c young <chestercyoung@yahoo.com>
  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 17:45  Tom Lane <tgl@sss.pgh.pa.us>
  parent: chester c young <chestercyoung@yahoo.com>
  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