Re: Nulls get converted to 0 problem - Mailing list pgsql-general

From Vincent Hikida
Subject Re: Nulls get converted to 0 problem
Date
Msg-id 024d01c32adb$7c1d3840$6601a8c0@HOMEOFFICE
Whole thread Raw
In response to Nulls get converted to 0 problem  (Avi Schwartz <avi@CFFtechnologies.com>)
List pgsql-general
Thanks for the detail. :)

Vincent Hikida,
Member of Technical Staff - Urbana Software, Inc.
"A Personalized Learning Experience"

www.UrbanaSoft.com

----- Original Message -----
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: "Vincent Hikida" <vhikida@inreach.com>
Cc: "Avi Schwartz" <avi@CFFtechnologies.com>; <pgsql-general@postgresql.org>
Sent: Wednesday, June 04, 2003 1:28 PM
Subject: Re: [GENERAL] Nulls get converted to 0 problem


> On Wed, 4 Jun 2003, Vincent Hikida wrote:
>
> > > FYI, "" does NOT equal NULL does not equal 0.
> >
> >
> > Interesting, I noticed that a few days ago. I noticed that in pg sql, if
I
> > used RTRIM on a column with all blanks. the RTRIM'ed result is not null.
In
> > Oracle I think it would be a null. That is in Oracle "" and NULL are
> > equivalent.
>
> Yeah, this is an issue we run into a lot on the lists.  Basically, Oracle
> got this one wrong, people wrote a lot of code expecting it, and now
> Oracle can't change it to the proper behaviour without breaking folks'
> applications.
>
> There is a setting in postgresql that turns where field=NULL into where
> field IS NULL, but I don't think there's much more support for "" being
> equivalent to NULL.
>
>


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Nulls get converted to 0 problem
Next
From: "scott.marlowe"
Date:
Subject: Re: regular expression question