Re: why does documentation use "END CASE" when that doesn't work

Поиск
Список
Период
Сортировка
От Jov
Тема Re: why does documentation use "END CASE" when that doesn't work
Дата
Msg-id CADyrUxMZB2OGm_XwXDQ_8K9GU_O0cKnSSzquq-zZniS2uPV9oQ@mail.gmail.com
обсуждение исходный текст
Ответ на why does documentation use "END CASE" when that doesn't work  (Susan Cassidy <susan.cassidy@decisionsciencescorp.com>)
Список pgsql-general

plpgsql case use end case,while sql case use end,they are different language

jov

在 2014-2-26 上午8:32,"Susan Cassidy" <susan.cassidy@decisionsciencescorp.com>写道:
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: why does documentation use "END CASE" when that doesn't work
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: Adding a non-null column without noticeable downtime