Re: pgplsql - Oracle nvl

From: Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org>
To: Christian Traber <christian(at)traber-net(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pgplsql - Oracle nvl
Date: 2003-08-27 22:21:03
Message-ID: 3F4D2ECF.7020802@visualdistortion.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?
>
> Best regards,
> Christian

Try coalesce. The syntax is the same as nvl.

Jeff

In response to

Browse pgsql-general by date

  From Date Subject
Next Message expect 2003-08-27 22:49:26 Re: The ..... worm
Previous Message Stuart 2003-08-27 21:38:15 Re: mysql's last_insert_id