Re: Question about Oracle compatibility

At 12:44 PM 11/27/00 -0500, Tom Lane wrote:
>Mario Weilguni  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  Nature photos, on-line guides, Pacific Northwest Rare Bird Alert Service and other goodies at http://donb.photo.net.