On Jun 30, 2009, at 11:25 AM, David Fetter wrote:
On Tue, Jun 30, 2009 at 10:22:23AM -0700, Erik Jones wrote:
postgres=# select null = null;
?column?
----------
(1 row)
Actually, it's NULL.
shackle@postgres:5432=# SELECT (NULL = NULL) IS NULL;
?column?
----------
t
(1 row)
Er, yeah, I mispoke, my point was that it doesn't evaluate to TRUE so
the join doesn't hit a match, though...
Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
