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

From Seamus Abshere
Subject Re: [GENERAL] CREATE AGGREGATE on jsonb concat
Date
Msg-id 1499705532.364570.1036230184.62905891@webmail.messagingengine.com
Whole thread Raw
In response to Re: [GENERAL] CREATE AGGREGATE on jsonb concat  (Seamus Abshere <seamus@abshere.net>)
List pgsql-general
Seamus Abshere <seamus@abshere.net> writes:

> That aggregates into an array. Our `jsonb_collect` aggregates into an object.

Postgres 9.6 has (per
https://www.postgresql.org/docs/9.6/static/functions-aggregate.html):

* jsonb_agg(expression)
* jsonb_object_agg(name, value)

In retrospect, I think what I am proposing is:

* jsonb_object_agg(expression)

Is that sane?

Best,
Seamus


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Changing collate & ctype for an existing database
Next
From: rihad
Date:
Subject: Re: [GENERAL] Changing collate & ctype for an existing database