Hello > > 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. > I'd love to have CASE in PL/pgSQL, but I always thought that stood in the way. > it's safe. SQL/PSM use it too. Pavel ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org