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