Re: Making jsonb_agg() faster

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Making jsonb_agg() faster
Дата
Msg-id 1178694.1765641273@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Making jsonb_agg() faster  (Alexander Lakhin <exclusion@gmail.com>)
Ответы Re: Making jsonb_agg() faster
Список pgsql-hackers
Alexander Lakhin <exclusion@gmail.com> writes:
> I and SQLsmith have discovered that the following query:
> select jsonb_object_agg_unique_strict(i, null) over (order by i) from
>            (select i from generate_series(1, 20) g(i));

> triggers SIGSEGV:

Thanks for the report!  It seems to be specific to use as a window
function; I see no problem without the OVER clause.  Will look closer
later.

            regards, tom lane



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