On Wed, Jun 23, 2004 at 19:10:05 +0100,
Simon Windsor <simon.windsor@cornfield.org.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')
