David Johnston <polobo(at)yahoo(dot)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