pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jonathan Man <jman@equityunderwriters.com.hk>
To: pgsql <pgsql-sql@postgresql.org>
Subject: convert NULL into a value
Date: Thu, 12 Dec 2002 12:08:43 +0800
Message-ID: <003701c2a194$28fc4b90$8401a8c0@equity.com> (raw)

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

view thread (3+ messages)

Message-ID: <003701c2a194$28fc4b90$8401a8c0@equity.com>
Permalink:  ../003701c2a194$28fc4b90$8401a8c0@equity.com/
Also on:    postgresql.org/message-id/003701c2a194$28fc4b90$8401a8c0@equity.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jman@equityunderwriters.com.hk
  Subject: Re: convert NULL into a value
  In-Reply-To: <003701c2a194$28fc4b90$8401a8c0@equity.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox