Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk> writes:
> 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.
I don't think so, but you could use a CASE clause for this.
-Doug