Postgres Pro
Downloads
Home   >   mailing lists

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 01a201c32acf$3a05a070$6601a8c0@HOMEOFFICE
Whole thread Raw
In response to Re: Nulls get converted to 0 problem  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Nulls get converted to 0 problem  (<terry@ashtonwoodshomes.com>)
Re: Nulls get converted to 0 problem  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Tree view 
> 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.

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

www.UrbanaSoft.com

pgsql-general by date:

Previous
From: Avi Schwartz
Date:
Subject: Re: Nulls get converted to 0 problem
Next
From: Avi Schwartz
Date:
Subject: Re: Nulls get converted to 0 problem