Re: '' <> NULL - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: '' <> NULL
Date
Msg-id 20030325075613.A18817@mail.libertyrms.com
Whole thread Raw
In response to '' <> NULL  ("Cristian Custodio" <crstian@terra.com.br>)
List pgsql-general
On Mon, Mar 24, 2003 at 08:45:00PM -0300, Cristian Custodio wrote:

> Does anybody here in this forum, and that work
> with Oracle already resolve this?
>
> Are there any way to change the PG to equal
>  '' like NULL?

It's been discussed before, and I've never seen a way to do it.

It's important to see that, even though Oracle does it that way, ''
is _not_ NULL.  It's an empty string.  There's a fairly important
difference.

Could you arrange things such that you always look for and insert ''?
Then you'd have empty values all the time.  (NOT NULL constraints
wouldn't work against these cases, of course, because they're not
null.)

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: Tony Grant
Date:
Subject: Re: Advice on Database Schema
Next
From: "Jennifer Lee"
Date:
Subject: Re: Advice on Database Schema