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)
