Re: Making jsonb_agg() faster - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Making jsonb_agg() faster
Date
Msg-id 1178694.1765641273@sss.pgh.pa.us
Whole thread Raw
In response to Re: Making jsonb_agg() faster  (Alexander Lakhin <exclusion@gmail.com>)
Responses Re: Making jsonb_agg() faster
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Clarify temporal FK comments
Next
From: Peter Eisentraut
Date:
Subject: Re: Fix out-of-date comment on makeRangeConstructors