On Jan 18, 2008 3:19 AM, Pavel Stehule <[EMAIL PROTECTED]> wrote: > > Isn't there a danger of syntactical conflict with the SQL SELECT ... CASE > > statement? > > no, isn't. SELECT CASE can be only in expression .. inside SQL > statement, but PL/SQL CASE is PL statement. These are two different > worlds. SELECT CASE is invisible for pl parser, because pl parser > solves statements, not expressions. >
Sounds good. Chaining ELSIFs is ugly; I've wished for something like this in PL/pgSQL from time to time while writing my functions. A hearty "+1" from me. Let me know if there's anything I can do to help move it forward. Cheers BJ ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq