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