Re: pgplsql - Oracle nvl - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: pgplsql - Oracle nvl
Date
Msg-id 20030827130709.GG25066@wolff.to
Whole thread Raw
In response to pgplsql - Oracle nvl  (Christian Traber <christian@traber-net.de>)
List pgsql-general
On Wed, Aug 27, 2003 at 09:58:00 +0200,
  Christian Traber <christian@traber-net.de> wrote:
> Hi,
>
> I'll try to switch from Oracle to postgres for some small applications.
> Is it possible to build functions like Oracle's nvl or decode with pgplsql?
> How can I make a function like nvl that works for every datatype?

You can use coalesce to do what nvl does.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: SQL Command - To List Tables ?
Next
From: Bruno Wolff III
Date:
Subject: Re: deleting referenced data