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