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

From Seamus Abshere
Subject [GENERAL] CREATE AGGREGATE on jsonb concat
Date
Msg-id 1499360350.649531.1032553256.0FC3CB3B@webmail.messagingengine.com
Whole thread Raw
Responses Re: [GENERAL] CREATE AGGREGATE on jsonb concat  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
hi,

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.

Thanks for your advice,
Seamus

--
Seamus Abshere, SCEA
https://github.com/seamusabshere
https://linkedin.com/in/seamusabshere
https://www.faraday.io


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Renaming Raster Table
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Renaming Raster Table