Re: Nulls get converted to 0 problem

On Thu, 5 Jun 2003, Alvaro Herrera wrote:

> On Wed, Jun 04, 2003 at 10:26:22AM -0500, Avi Schwartz wrote:
>
> > select * from item_catalog where item_category is null
> >
> > With SQl Server 7, this works as expected, but with PostgreSQL, the
> > value Coldfusion is setting the integer variables to is 0 (zero) and
> > not "" as it should.
>
> You probably can do
>
> select coalesce(column1::text, ''), coalesce(column2::text, ''), ...
> from item_catalog where item_category is null;
>
> (Note that everything is going to come back as TEXT rather than numbers,
> though)

Adding to this, if they DON'T want to have pgsql specific code in their
application, they could create views with update triggers to handle the
tables underneath.