Skip site navigation (1) Skip section navigation (2)

Re:

From: Erik Jones <ejones(at)engineyard(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: Waldemar Bergstreiser <littlesuspense(at)web(dot)de>, Greg Stark <gsstark(at)mit(dot)edu>, pgsql-general(at)postgresql(dot)org, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Subject: Re:
Date: 2009-06-30 20:28:43
Message-ID: 22EC2FD9-C3E0-4242-A4F8-58E096FA973B@engineyard.com (view raw or flat)
Thread:
Lists: pgsql-general
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(at)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






In response to

  • Re: at 2009-06-30 18:25:47 from David Fetter

pgsql-general by date

Next:From: Sam MasonDate: 2009-06-30 20:37:11
Subject: Re:
Previous:From: APseudoUtopiaDate: 2009-06-30 20:25:19
Subject: Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group