Re: Nulls get converted to 0 problem
От | Vincent Hikida |
---|---|
Тема | Re: Nulls get converted to 0 problem |
Дата | |
Msg-id | 024d01c32adb$7c1d3840$6601a8c0@HOMEOFFICE обсуждение исходный текст |
Ответ на | Nulls get converted to 0 problem (Avi Schwartz <avi@CFFtechnologies.com>) |
Список | 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 по дате отправления: