From: Andrew Sullivan <ajs@crankycanuck.ca>
To: BillR <iambill@williamrosmus.com>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-sql@postgresql.org, "D'Arcy J.M. Cain" <darcy@druid.net>
Cc: Andrew Sullivan <ajs@crankycanuck.ca>
Subject: Re: Differentiate Between Zero-Length String and NULLColumn Values
Date: Thu, 1 Feb 2007 13:53:16 -0500
Message-ID: <20070201185316.GE7985@phlogiston.dyndns.org> (raw)
In-Reply-To: <45C0F97B.4080104@williamrosmus.com>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ajs@crankycanuck.ca, iambill@williamrosmus.com, peter_e@gmx.net, darcy@druid.net
Subject: Re: Differentiate Between Zero-Length String and NULLColumn Values
In-Reply-To: <20070201185316.GE7985@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox