Re: change null to 0 in SQL script

I believe that you need the coalesce function. Here's the excerpt
from the manual:

COALESCE

COALESCE(value[, ...])

The COALESCE function returns the first of its arguments that
is not NULL. This is often useful to substitute a default
value for NULL values when data is retrieved for display, for
example:

SELECT COALESCE(description, short_description, '(none)') ...

Just write your query so that it looks something like this:

SELECT coalesce(value_that_may_be_null, 0) FROM your_table;

Jason

"Karl Raven" <lcaasia(at)pd(dot)jaring(dot)my> writes:

> I like to change a null value of a query to 0 in the SQL script. I
> know how to do it in MS-SQL server and MS-Access but those commands
> does not work in pg-sql.
>
> Anyone has any ideas?
>
> Thanks
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org