Postgres Pro
Downloads
Home   >   mailing lists

Re: switch / case in plpgsql functions - Mailing list pgsql-general

From Joachim Wieland
Subject Re: switch / case in plpgsql functions
Date
Msg-id 20060215210809.GA3965@mcknight.de
Whole thread Raw
In response to switch / case in plpgsql functions  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-general
Tree view 
On Tue, Feb 14, 2006 at 10:55:33AM -0500, Emi Lu wrote:
> May I know whether plpgsql supports "switch / case " or I have to use IF
> /ELSIF please?

http://www.postgresql.org/docs/8.1/static/plpgsql-control-structures.html#PLPGSQL-CONDITIONALS

does not list something like the switch / case construct so you'll have to
use IF ... ELSIF.


Joachim

--
Joachim Wieland                                              joe@mcknight.de
C/ Usandizaga 12 1°B                                           ICQ: 37225940
20002 Donostia / San Sebastian (Spain)                     GPG key available

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Connecting process to PostgreSQL works stunningly slow
Next
From: Ben
Date:
Subject: Re: Oracle purchases Sleepycat - is this the "other shoe"