Re: wording for 38.6.2.4. Simple CASE and 38.6.2.5. Searched CASE

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