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