Postgres Pro
Downloads
Home   >   mailing lists

Re: How to return a jsonb list of lists (with integers) - Mailing list pgsql-general

From David G. Johnston
Subject Re: How to return a jsonb list of lists (with integers)
Date
Msg-id CAKFQuwYgHf=fUbQ-js1Xk5h=E7v_FSwuVyG+eD_JAp=mcPsqaQ@mail.gmail.com
Whole thread Raw
In response to Re: How to return a jsonb list of lists (with integers)  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: How to return a jsonb list of lists (with integers)
List pgsql-general
Tree view
On Tuesday, February 16, 2021, Alexander Farber <alexander.farber@gmail.com> wrote:
But is it possible in SQL to combine all 3 queries, so that a JSONB list of lists is returned?
So I have to use PL/PgSQL, correct?

With liberal usage of CTEs and subqueries writing a single SQL query should be doable.

David J.

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: How to return a jsonb list of lists (with integers)
Next
From: Ron
Date:
Subject: Re: Order by not working