Re: check for null value

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
Thread:
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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message scott.marlowe 2004-01-16 17:40:37 Re: Trouble connecting
Previous Message Martinelli Paolo A. 2004-01-16 17:19:53 R: problem creating user