Date: Thu, 1 Feb 2007 13:53:16 -0500
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: BillR <iambill@williamrosmus.com>
Cc: Peter Eisentraut <peter_e@gmx.net>, pgsql-sql@postgresql.org,
	"D'Arcy J.M. Cain" <darcy@druid.net>, Andrew Sullivan <ajs@crankycanuck.ca>
Subject: Re: Differentiate Between Zero-Length String and NULLColumn Values
Message-ID: <20070201185316.GE7985@phlogiston.dyndns.org>
References: <20070130131334.GD31676@phlogiston.dyndns.org>
	<20070130142332.GA31905@phlogiston.dyndns.org>
	<20070130113834.fa8d09e0.darcy@druid.net>
	<200701301959.37775.peter_e@gmx.net>
	<45C0F97B.4080104@williamrosmus.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <45C0F97B.4080104@williamrosmus.com>
User-Agent: Mutt/1.5.9i

On Wed, Jan 31, 2007 at 12:18:03PM -0800, BillR wrote:
> Peter Eisentraut wrote:

> >It doesn't violate any spec and it's certainly allowed by PostgreSQL 
> >without any flags.  It's just that the result is not what some people 
> >expect.

> "= NULL" violates the SQL-92 Specification.  

I don't want to put words in his mouth, but I think you missed the
bit where Peter said "the result is not what some people expect". 
Hint: 'somevalue = NULL' is not a violation of SQL in that you don't
get an ERROR.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
"The year's penultimate month" is not in truth a good way of saying
November.
		--H.W. Fowler