Re: range_agg with multirange inputs

Поиск
Список
Период
Сортировка
От Paul Jungwirth
Тема Re: range_agg with multirange inputs
Дата
Msg-id 71eabe81-3e69-0476-347a-c8342de5cd41@illuminatedcomputing.com
обсуждение исходный текст
Ответ на Re: range_agg with multirange inputs  (Chapman Flack <chap@anastigmatix.net>)
Ответы Re: range_agg with multirange inputs  (Chapman Flack <chap@anastigmatix.net>)
Re: range_agg with multirange inputs  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Список pgsql-hackers
On 3/10/22 14:07, Chapman Flack wrote:
> When I apply this patch, I get a func.sgml with two entries for
> range_intersect_agg(anymultirange).

Arg, fixed.

> In range_agg_transfn, you've changed the message in the "must be called
> with a range or multirange"; that seems like another good candidate to
> be an elog.

Agreed. Updated here.

> I think your query finds aggregate declarations that share the same SQL
> function declaration as their finalizer functions. That seems to be more
> common.
> 
> The query I used looks for cases where different SQL-declared functions
> appear as finalizers of aggregates, but the different SQL declared functions
> share the same internal C implementation.

Okay, I see. I believe that is quite common for ordinary SQL functions. 
Sharing a prosrc seems even less remarkable than sharing an aggfinalfn. 
You're right there are no cases for other finalfns yet, but I don't 
think there is anything special about finalfns that would make this a 
weirder thing to do there than with ordinary functions. Still, noting it 
with a comment does seem helpful. I've updated the remark to match what 
you suggested.

Thank you again for the review, and sorry for so many iterations! :-)

Yours,

-- 
Paul              ~{:-)
pj@illuminatedcomputing.com
Вложения

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Issue with pg_stat_subscription_stats
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: pg_walinspect - a new extension to get raw WAL data and WAL stats