Re: '' <> NULL

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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110