Mark Muffett writes:
> Is there a Postgresql equivalent to the Oracle NVL( ) function, which
> allows a SELECT statement to fill in default values if a column is
> NULL?
COALESCE(x1, x2, x3, ...)
returns the first xn that is not null.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter