Re: [SQL] convert NULL into a value

No, the SQL standard command is COALESCE. --- Jonathan Man 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 PostgreS

Re: [SQL] convert NULL into a value

--- Jonathan Man <[EMAIL PROTECTED]> 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, lu

[SQL] convert NULL into a value

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??     Thank you for your help!!   Regards,   JONATHAN MAN