Re: Improving inferred query column names

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Improving inferred query column names
Дата
Msg-id 20230222204022.uc4i5fm43ba67pjx@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: Improving inferred query column names  (Vladimir Churyukin <vladimir@churyukin.com>)
Ответы Re: Improving inferred query column names  (Vladimir Churyukin <vladimir@churyukin.com>)
Список 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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Improving inferred query column names
Следующее
От: Daniel Gustafsson
Дата:
Сообщение: Re: pg_regress: Treat child process failure as test failure