Home > mailing lists

Re: check for null value - Mailing list pgsql-admin

From	scott.marlowe
Subject	Re: check for null value
Date	January 16, 2004 16:38:20
Msg-id	Pine.LNX.4.33.0401161033440.27657-100000@css120.ihs.com Whole thread Raw
In response to	check for null value (Ashok Chauhan <ashok@kalculate.com>)
List	pgsql-admin

Tree view

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.

pgsql-admin by date:

From: "Martinelli Paolo A."
Date: 16 January 2004, 16:20:33
Subject: R: problem creating user

From: "scott.marlowe"
Date: 16 January 2004, 16:43:33
Subject: Re: Trouble connecting

Re: check for null value - Mailing list pgsql-admin

Previous

Next