From: Jan Wieck <JanWieck@Yahoo.com>
To: Jamie A Lawrence <jal@clueinc.net>
Cc: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: Differentiate Between Zero-Length String and NULLColumn Values
Date: Thu, 08 Feb 2007 14:30:39 -0500
Message-ID: <45CB7A5F.2060501@Yahoo.com> (raw)
In-Reply-To: <9B53782A-CDF7-4117-9236-62D4926F7835@clueinc.net>
References: <20070130131334.GD31676@phlogiston.dyndns.org>
<45BF584F.A3DD.0030.0@indicator.be>
<20070130142332.GA31905@phlogiston.dyndns.org>
<20070130113834.fa8d09e0.darcy@druid.net>
<20070130165503.GC32170@phlogiston.dyndns.org>
<9B53782A-CDF7-4117-9236-62D4926F7835@clueinc.net>
On 1/30/2007 3:17 PM, Jamie A Lawrence wrote:
> Just a datapoint:
>
> SQL*Plus: Release 10.1.0.3.0 - Production on Tue Jan 30 15:15:49 2007
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
> With the Partitioning, OLAP and Data Mining options
It is well known that Oracle's handling of zero length strings violates
all ANSI SQL Standards, so what exactly is your point?
Jan
>
> SQL> select * from dual where '' IS NULL;
>
> D
> -
> X
>
> SQL> select * from dual where '' = NULL;
>
> no rows selected
>
>
> -j
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
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: JanWieck@Yahoo.com, jal@clueinc.net, ajs@crankycanuck.ca
Subject: Re: Differentiate Between Zero-Length String and NULLColumn Values
In-Reply-To: <45CB7A5F.2060501@Yahoo.com>
* 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