CREATE AGGREGATE on jsonb concat

From: Seamus Abshere <seamus(at)abshere(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: CREATE AGGREGATE on jsonb concat
Date: 2017-07-06 16:59:10
Message-ID: 1499360350.649531.1032553256.0FC3CB3B@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-07-06 17:27:13 Re: Renaming Raster Table
Previous Message David G. Johnston 2017-07-06 16:05:54 Re: Renaming Raster Table