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 [EMAIL PROTECTED] C/ Usandizaga 12 1°B ICQ: 37225940 20002 Donostia / San Sebastian (Spain) GPG key available ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend