--- Jonathan Man <jman@equityunderwriters.com.hk>
wrote:
> Hi,
>
> There is a function on the Oracle. That is
> NVL(field, 0) to convert null into a value (e.g.
> ZERO).
>
> Can I use this function on the PostgreSQL??
>
-- The equivalent function is PostgreSQL is
SELECT COALESCE(field,0)
regards,
ludwig.
__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com