Search Postgresql Archives

Re: JSONB_AGG: aggregate function calls cannot be nested

Subject: Re: JSONB_AGG: aggregate function calls cannot be nested
From: Alexander Farber <alexander.farber@xxxxxxxxx>
Date: Sat, 20 Feb 2021 20:33:50 +0100
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAKFQuwawYEq+K3W4ZL=teSfJM8OdLzpsZ8kx-xSNBGAc6+SAWQ@mail.gmail.com>
References: <CAADeyWhzYAXxuBJaQA2n-wuK1Uoc2FbKAk+iE2G1Mcg-vD0r0g@mail.gmail.com> <CAKFQuwa+s=yq+cya-BuGMrzBcFev=4dM4YyLsZ+Kujo1iPO5AA@mail.gmail.com> <CAADeyWgGuZkaUDYVULAgO3dnt67fPsnVyP4P6xop1Nr73hxEmg@mail.gmail.com> <CAKFQuwawYEq+K3W4ZL=teSfJM8OdLzpsZ8kx-xSNBGAc6+SAWQ@mail.gmail.com>

Ah, thank you...

JSON support in PostgreSQL is cool and seems to be extended with each release.

But standard tasks of returning a JSON map of lists or JSON list of list seem to be difficult to use.

Greetings

Alex

Follow-Ups:
- Re: JSONB_AGG: aggregate function calls cannot be nested
  - From: David G. Johnston

References:
- JSONB_AGG: aggregate function calls cannot be nested
  - From: Alexander Farber
- Re: JSONB_AGG: aggregate function calls cannot be nested
  - From: David G. Johnston
- Re: JSONB_AGG: aggregate function calls cannot be nested
  - From: Alexander Farber
- Re: JSONB_AGG: aggregate function calls cannot be nested
  - From: David G. Johnston