Alvaro Herrera schrieb:
"simple case" and "searched case" is SQL/PSM's terminology. I'm not sure it's necessarily a good idea to deviate from that. See SQL part 4, 13.6 <case statement>:Function Provide conditional execution based on truth of <search condition>s or on equality of operands. Format <case statement> ::= <simple case statement> | <searched case statement> <simple case statement> ::= CASE <case operand> <simple case statement when clause>... [ <case statement else clause> ] END CASE <searched case statement> ::= CASE <searched case statement when clause>... [ <case statement else clause> ] END CASE <simple case statement when clause> ::= WHEN <when operand list> THEN <SQL statement list> <searched case statement when clause> ::= WHEN <search condition> THEN <SQL statement list> <case statement else clause> ::= ELSE <SQL statement list>
Agreed ... using the standard terminology is better (as Tom also mentioned already). Cheers Andy -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
