Re: Nulls get converted to 0 problem

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)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Las cosas son buenas o malas segun las hace nuestra opinion" (Lisias)