Skip site navigation (1) Skip section navigation (2)

Re: Question about Oracle compatibility

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: (view raw, whole thread or download thread mbox)
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 - Production
With the Partitioning option
JServer Release - 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;



- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at

In response to

pgsql-hackers by date

Next:From: Alex PerelDate: 2000-11-27 19:00:33
Subject: Re: Question about Oracle compatibility
Previous:From: Don BaccusDate: 2000-11-27 18:42:01
Subject: Re: Question about Oracle compatibility

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group