Re: [GENERAL] CREATE AGGREGATE on jsonb concat - Mailing list pgsql-general

Seamus Abshere <seamus@abshere.net> writes:
> We do this in our database:

> CREATE AGGREGATE jsonb_collect(jsonb) (
>     SFUNC = 'jsonb_concat',
>     STYPE = jsonb,
>     INITCOND = '{}'
> );

> Is there some other built-in aggregate I'm missing that would do the
> same thing? It just feels like such an obvious feature.

Doesn't jsonb_agg() do exactly that?

            regards, tom lane