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