plpgsql case use end case，while sql case use end，they are different language
jov
在 2014-2-26 上午8:32，"Susan Cassidy" 写道：
> The documentation says:
>
> CASE search-expression
> WHEN expression [, expression [ ... ]] THEN
> statements
> [ WHEN expression [, expression [ ... ]] THEN
>
Susan Cassidy writes:
> The documentation says:
> CASE search-expression
> WHEN expression [, expression [ ... ]] THEN
> statements
> [ WHEN expression [, expression [ ... ]] THEN
> statements
> ... ]
> [ ELSE
> statements ]
> END CASE;
> And it repeats the "END CASE
