Re: Improving inferred query column names - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Improving inferred query column names
Date
Msg-id 20230222204022.uc4i5fm43ba67pjx@awork3.anarazel.de
Whole thread Raw
In response to Re: Improving inferred query column names  (Vladimir Churyukin <vladimir@churyukin.com>)
Responses Re: Improving inferred query column names
List pgsql-hackers
Hi,

On 2023-02-11 12:47:04 -0800, Vladimir Churyukin wrote:
> That is a good idea for simple cases, I'm just curious how it would look
> like for more complex cases (you can have all kinds of expressions as
> parameters for aggregate function calls).
> If it works only for simple cases, I think it would be confusing and not
> very helpful.

I don't think it needs to be perfect to be helpful.


> Wouldn't it make more sense to just deduplicate the names by adding
> numerical postfixes, like sum_1, sum_2?

That'd be considerably worse than what we do today imo, because any reordering
/ added aggregate would lead to everything else changing as well.


Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Improving inferred query column names
Next
From: Daniel Gustafsson
Date:
Subject: Re: pg_regress: Treat child process failure as test failure