Re: case when evaluating else condition anyway?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: case when evaluating else condition anyway?
Дата
Msg-id 8925.1227713350@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: case when evaluating else condition anyway?  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Список pgsql-general
Ivan Sergio Borgonovo <mail@webthatworks.it> writes:
> Still why does the else condition get evaluated anyway when at least
> one of the "when" condition is true?

Because 'literal'::type is a literal of that type; it does not represent
a run-time conversion.  I think we document that under the discussion
of constants in the syntax chapter.

            regards, tom lane

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

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: case when evaluating else condition anyway?
Следующее
От: Jeff MacDonald
Дата:
Сообщение: Re: pg_get_serial_sequence Strangeness/Unreliable?