On Wed, Jun 23, 2004 at 19:10:05 +0100,
Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk> wrote:
> 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
pgsql-general by date
|Next:||From: Lynna Landstreet||Date: 2004-06-23 18:50:40|
|Subject: pgHoster.com woes and looking for a new host|
|Previous:||From: Bruno Wolff III||Date: 2004-06-23 18:36:23|
|Subject: Re: insert with select as value|