Re: check for null value

Lists: pgsql-admin
From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Ashok Chauhan <ashok(at)kalculate(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: check for null value
Date: 2004-01-16 17:34:02
Message-ID: Pine.LNX.4.33.0401161033440.27657-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

On 16 Jan 2004, Ashok Chauhan wrote:

>
> hello
>
> i am selecting ten fields form a table and i want to replace the null
> values with any other value.

Look up coalesce(), it should do exactly what you need.

From: Ashok Chauhan <ashok(at)kalculate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: check for null value
Date: 2004-01-16 20:22:42
Message-ID: 1074284562.5240.3.camel@delta.greatindianproducts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin


hello

i am selecting ten fields form a table and i want to replace the null
values with any other value.

plz. help me

Ashok