Re: Postgres behavior - Conditional statements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres behavior - Conditional statements
Дата
Msg-id 3754.1393262289@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgres behavior - Conditional statements  (David Johnston <polobo@yahoo.com>)
Ответы Re: Postgres behavior - Conditional statements  (David Johnston <polobo@yahoo.com>)
Список pgsql-sql
David Johnston <polobo@yahoo.com> writes:
> Tom Lane-2 wrote
>> The behavior of CASE didn't change, but the behavior of the sub-select
>> did.

> CASE should be treated just like a function and the name of the function
> should be returned.  Arbitrarily picking the "else" branch to obtain the
> name of the result column seems somehow wrong.

[ shrug... ]  It's acted like that since roughly the late bronze age;
or to be more specific, since commit 2b189aa9537f7b4a of 1998-12-13.
Given the lack of previous complaints, it's going to take a lot more
than one man's opinion to change it.
        regards, tom lane



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

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: Postgres behavior - Conditional statements
Следующее
От: AlexK
Дата:
Сообщение: Can I specify a copying type for an array element