plpgsql case use end case,while sql case use end,they are different language
jov
在 2014-2-26 上午8:32,"Susan Cassidy" <susan.cassidy@xxxxxxxxxxxxxxxxxxxxxxxx>写道:
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" phrase in other examples.
However, that doesn't work. You have to just use "END".Shouldn't the documentation be fixed?Susan