Re: Case clause doesn't report syntactic error

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Case clause doesn't report syntactic error
Дата
Msg-id CAKFQuwYMz9Ntog_UL-f2+A8YBvNWp3ZbRHYUWx5EkaiWz+ivRw@mail.gmail.com
обсуждение исходный текст
Список pgsql-bugs
Дерево обсуждения
On Saturday, September 14, 2024, Leo Volin <lvolin@intelligentaudit.com> wrote:

It doesn't match the documented format: 
CASE WHEN condition THEN result
     [WHEN ...]
     [ELSE result]
END
As long as the type of entry between CASE and first WHEN matches type of WHEN conditions no syntax error is being generated!

Read the entire section documenting case.


There are two forms documented - the general and then the “simple” variant.  You example demonstrates the later.

David J.

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