Postgres Pro
Downloads
Home   >   mailing lists

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

From Alexander Farber
Subject Re: How to return a jsonb list of lists (with integers)
Date
Msg-id CAADeyWhB8H+03ujzdmP+T-yCTRZwR0U9skRQpOBieYcK=oU9Gg@mail.gmail.com
Whole thread Raw
In response to Re: How to return a jsonb list of lists (with integers)  (Michael Lewis <mlewis@entrata.com>)
List pgsql-general
Tree view
On Tue, Feb 16, 2021 at 7:52 PM Michael Lewis <mlewis@entrata.com> wrote:
Aggregate functions work on a single column to summarize many rows into fewer rows. You seem to be wanting to combine multiple columns which would be done by concatenation or array[column1,column2] or something like that.

Ah right, Michael, thanks - that is what I realised just after sending the mail. 

I don't have rows here, but a single row with several columns.

pgsql-general by date:

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