Re: oracle decode()

From: Richard Huxton <dev(at)archonet(dot)com>
To: a(dot)schmitz(at)cityweb(dot)de, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: oracle decode()
Date: 2004-03-03 12:51:12
Message-ID: 200403031251.12607.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wednesday 03 March 2004 10:48, Andreas Schmitz wrote:
> Hello,
>
> is there any equivalent for ORACLEs decode() in pl/pgsql ?

Is that the function that works like CASE?

CASE WHEN x=1 THEN 'ONE' WHEN x=2 THEN 'TWO' END

See the reference manual for syntax (conditional functions/operators iirc).

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2004-03-03 13:12:39 Encoding bytea
Previous Message Andreas Schmitz 2004-03-03 10:48:39 oracle decode()