Re: switch / case in plpgsql functions

From: Joachim Wieland <joe(at)mcknight(dot)de>
To: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
Cc: 'PostgreSQL pg-general List' <pgsql-general(at)postgresql(dot)org>
Subject: Re: switch / case in plpgsql functions
Date: 2006-02-15 21:08:09
Message-ID: 20060215210809.GA3965@mcknight.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)mcknight(dot)de
C/ Usandizaga 12 1°B ICQ: 37225940
20002 Donostia / San Sebastian (Spain) GPG key available

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-02-15 22:06:29 Re: Oracle purchases Sleepycat - is this the "other shoe"
Previous Message Ben 2006-02-15 21:02:03 Re: Oracle purchases Sleepycat - is this the "other shoe"