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