Re: confusing `case when` column name - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: confusing `case when` column name
Date
Msg-id A2904471-7798-45F5-8F21-F19907D365B2@yesql.se
Whole thread Raw
In response to Re: confusing `case when` column name  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> On 12 Mar 2024, at 15:19, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> users are probably going to end up applying an AS clause most of
> the time if they care about the column name at all.

If anything, we could perhaps add a short note in the CASE documentation about
column naming, the way it's phrased now a new user could very easily assume it
would be "case".

--
Daniel Gustafsson




pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: On disable_cost
Next
From: Daniel Gustafsson
Date:
Subject: Re: Disable LLVM bitcode generation with pgxs.mk framework.