From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, mweilguni(at)sime(dot)com |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Question about Oracle compatibility |
Date: | 2000-11-27 18:47:27 |
Message-ID: | 3.0.1.32.20001127104727.01b3a100@mail.pacifier.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
At 12:44 PM 11/27/00 -0500, Tom Lane wrote:
>Mario Weilguni <mweilguni(at)sime(dot)com> writes:
>> In Oracle, empty strings and null are basicly the same,
>
>Are you sure about that? It'd be a pretty major failure to comply with
>SQL standard semantics, if so.
Thought you'd get a kick out of this:
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SQL> create table fubar(some_string varchar(1000));
Table created.
SQL> insert into fubar values('');
1 row created.
SQL> select count(*) from fubar where some_string is null;
COUNT(*)
----------
1
SQL>
- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Perel | 2000-11-27 19:00:33 | Re: Question about Oracle compatibility |
Previous Message | Don Baccus | 2000-11-27 18:42:01 | Re: Question about Oracle compatibility |