Re: How to return a jsonb list of lists (with integers)

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to return a jsonb list of lists (with integers)
Date: 2021-02-16 20:30:59
Message-ID: CAADeyWhB8H+03ujzdmP+T-yCTRZwR0U9skRQpOBieYcK=oU9Gg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 16, 2021 at 7:52 PM Michael Lewis <mlewis(at)entrata(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2021-02-16 20:55:28 Re: How to return a jsonb list of lists (with integers)
Previous Message Dan Nessett 2021-02-16 19:41:08 Re: Order by not working