Home > mailing lists

convert NULL into a value - Mailing list pgsql-sql

From	Jonathan Man
Subject	convert NULL into a value
Date	December 11, 2002 22:44:43
Msg-id	003701c2a194$28fc4b90$8401a8c0@equity.com Whole thread Raw
Responses	Re: convert NULL into a value Re: convert NULL into a value
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, 20:02:26
Subject: Re: trigger to maintain relationships

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