Home > mailing lists

convert NULL into a value - Mailing list pgsql-sql

From	Jonathan Man
Subject	convert NULL into a value
Date	December 12, 2002 01:44:43
Msg-id	003701c2a194$28fc4b90$8401a8c0@equity.com Whole thread Raw
Responses	Re: convert NULL into a value (Ludwig Lim <lud_nowhere_man@yahoo.com>) Re: convert NULL into a value (Bruce Momjian <pgman@candle.pha.pa.us>)
List	pgsql-sql

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

From: "Josh Berkus"
Date: 11 December 2002, 23:02:26
Subject: Re: trigger to maintain relationships

From: Ludwig Lim
Date: 12 December 2002, 02:03:44
Subject: Re: convert NULL into a value