Re: Differentiate Between Zero-Length String and NULLColumn Values

From: Jamie A Lawrence <jal(at)clueinc(dot)net>
To: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Differentiate Between Zero-Length String and NULLColumn Values
Date: 2007-01-30 20:17:56
Message-ID: 9B53782A-CDF7-4117-9236-62D4926F7835@clueinc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

SQL> select * from dual where '' IS NULL;

D
-
X

SQL> select * from dual where '' = NULL;

no rows selected

-j

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Hiltibidal, Robert 2007-01-30 20:42:11 Index ANDing & Index ORing
Previous Message Tomas Vondra 2007-01-30 19:34:13 Re: Differentiate Between Zero-Length String and NULLColumn Values