Re: coalesce and nvl question

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk>
Cc: Mike Mascari <mascarm(at)mascari(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: coalesce and nvl question
Date: 2004-06-23 18:43:57
Message-ID: 20040623184357.GB12411@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 23, 2004 at 19:10:05 +0100,
Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk> wrote:
> Hi
>
> I understand that null and '' are different, and MySQL and Oracle
> functions are confusing, but my question was not about replacing NULL
> but replacing Empty strings. These are handled in MySQL/Oracle by the
> same functions that do NULL checks.
>
> Is there a standard function in Postgres that replaces Empty strings, as
> against a NULL value.

Something like the following may suit your purposes:
coallesce(nullif(inputstring,''), 'replacement value')

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lynna Landstreet 2004-06-23 18:50:40 pgHoster.com woes and looking for a new host
Previous Message Bruno Wolff III 2004-06-23 18:36:23 Re: insert with select as value