Re: JSON_AGG produces extra square brakets

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Davide S <swept(dot)along(dot)by(dot)events(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: JSON_AGG produces extra square brakets
Date: 2014-11-30 22:41:14
Message-ID: 31118.1417387274@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Davide S <swept(dot)along(dot)by(dot)events(at)gmail(dot)com> writes:
> Note that the tags are just fine, but the arrays with the states have an
> increasing number of square brackets at the end: the first has 1 (correct),
> the second has 2, the third has 3, etc., which is invalid json.

Could you provide a self-contained test case for that?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Powrie, William 2014-12-01 00:34:14 Ever increasing pg_clog disk usage v8.4
Previous Message John R Pierce 2014-11-30 22:16:43 Re: Re: Remote PostgreSQL database - C/C++ program / Unix / Required Libraries