convert NULL into a value

From: "Jonathan Man" <jman(at)equityunderwriters(dot)com(dot)hk>
To: "pgsql" <pgsql-sql(at)postgresql(dot)org>
Subject: convert NULL into a value
Date: 2002-12-12 04:08:43
Message-ID: 003701c2a194$28fc4b90$8401a8c0@equity.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A.M. 2002-12-12 05:14:22 Re: Getting the latest unique items
Previous Message Ludwig Lim 2002-12-12 04:03:47 Re: convert NULL into a value