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

From Tom Lane
Subject Re: Making jsonb_agg() faster
Date
Msg-id 1361925.1765661150@sss.pgh.pa.us
Whole thread Raw
In response to Re: Making jsonb_agg() faster  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I wrote:
> 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.

Fixed, thanks again for finding this.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: SQL Property Graph Queries (SQL/PGQ)
Next
From: Chao Li
Date:
Subject: Re: Small patch to improve safety of utf8_to_unicode().