Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1F607475F3D for ; Wed, 11 Dec 2002 22:44:42 -0500 (EST) Received: from imsmq06.netvigator.com (imsmq06.netvigator.com [218.102.48.42]) by postgresql.org (Postfix) with SMTP id 5FEF5475E41 for ; Wed, 11 Dec 2002 22:44:40 -0500 (EST) Received: (qmail 4479 invoked from network); 12 Dec 2002 03:44:42 -0000 Received: from aworklan032048.netvigator.com (HELO pc32) (218.103.38.48) by imsmq06.netvigator.com with SMTP; 12 Dec 2002 03:44:42 -0000 Message-ID: <003701c2a194$28fc4b90$8401a8c0@equity.com> From: "Jonathan Man" To: "pgsql" Subject: convert NULL into a value Date: Thu, 12 Dec 2002 12:08:43 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0034_01C2A1D7.36ED30F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/139 X-Sequence-Number: 10727 This is a multi-part message in MIME format. ------=_NextPart_000_0034_01C2A1D7.36ED30F0 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: quoted-printable Hi, There is a function on the Oracle. That is NVL(field, 0) to convert null in= to a value (e.g. ZERO).=20 Can I use this function on the PostgreSQL?? Thank you for your help!! Regards, JONATHAN MAN ------=_NextPart_000_0034_01C2A1D7.36ED30F0 Content-Type: text/html; charset="big5" Content-Transfer-Encoding: quoted-printable

Hi,

There is a function on the Ora= cle. That=20 is NVL(field, 0) to convert null into a value (e.g. = =20 ZERO).

Can I use this function on the= =20 PostgreSQL??

Thank you for your help!!

Regards,

JONATHAN MAN

------=_NextPart_000_0034_01C2A1D7.36ED30F0--