Обсуждение: change null to 0 in SQL script

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

On Thu, 2002-01-03 at 06:00, Karl Raven wrote:
>
> 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?

What did you try?

Markus Bertheau

> I like to change a null value of a query to 0

The coalesce(something, 0) returns 0 if something is null, else returns
something.


Tibor Laszlo
ltibor@mail.tiszanet.hu

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
substitutea 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@pd.jaring.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@postgresql.org

Karl Raven wrote:

> 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
> 

I think the following should work:

select coalesce( my_attrib, 0 ) from my_tab

Thomas

thanks
will try it..


"ThomasR" <trx@wtal.de> wrote in message news:3C360816.1080103@wtal.de...
> Karl Raven wrote:
>
> > 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
> >
>
> I think the following should work:
>
> select coalesce( my_attrib, 0 ) from my_tab
>
> Thomas
>