Postgres Pro
Downloads
Home   >   mailing lists

Re: oracle decode() - Mailing list pgsql-sql

From Richard Huxton
Subject Re: oracle decode()
Date
Msg-id 200403031251.12607.dev@archonet.com
Whole thread Raw
In response to oracle decode()  (Andreas Schmitz <a.schmitz@cityweb.de>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Andreas Schmitz
Date:
Subject: oracle decode()
Next
From: Achilleus Mantzios
Date:
Subject: Encoding bytea