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 PostgreSQL?? > > > Thank you for your help!! > > Regards, > > JONATHAN MAN -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
