Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruno Wolff III
Subject Re: Nulls get converted to 0 problem
Date
Msg-id 20030604231118.GA17570@wolff.to
Whole thread Raw
In response to Re: Nulls get converted to 0 problem  (Avi Schwartz <avi@CFFtechnologies.com>)
List pgsql-general
Tree view 
On Wed, Jun 04, 2003 at 14:39:05 -0500,
  Avi Schwartz <avi@CFFtechnologies.com> wrote:
>
> I do not store a '' or "" into an integer column.  This is how CF does
> it when it gets a null value from the database.

Can you use coalesce to work around this problem?

pgsql-general by date:

Previous
From: "Yudha Setiawan"
Date:
Subject: Re: Re-Create Table make Faster.
Next
From: "Jim C. Nasby"
Date:
Subject: Re: to copy a record