Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 8A191475E88
	for <pgsql-sql@postgresql.org>; Wed, 11 Dec 2002 23:03:43 -0500 (EST)
Received: from web80305.mail.yahoo.com (web80305.mail.yahoo.com
 [66.218.79.21])
	by postgresql.org (Postfix) with SMTP id DB104475E41
	for <pgsql-sql@postgresql.org>; Wed, 11 Dec 2002 23:03:42 -0500 (EST)
Message-ID: <20021212040347.81662.qmail@web80305.mail.yahoo.com>
Received: from [203.87.150.116] by web80305.mail.yahoo.com via HTTP;
	Wed, 11 Dec 2002 20:03:47 PST
Date: Wed, 11 Dec 2002 20:03:47 -0800 (PST)
From: Ludwig Lim <lud_nowhere_man@yahoo.com>
Subject: Re: convert NULL into a value
To: Jonathan Man <jman@equityunderwriters.com.hk>
Cc: PostgreSQL Mailing List <pgsql-sql@postgresql.org>
In-Reply-To: <003701c2a194$28fc4b90$8401a8c0@equity.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/140
X-Sequence-Number: 10728


--- Jonathan Man <jman@equityunderwriters.com.hk>
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,

ludwig.

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com