concatenating hstores in a group by?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)nz>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: concatenating hstores in a group by?
Date: 2025-01-19 15:28:32
Message-ID: CAKFQuwasxOzkA-BECEaOz1b8EOh2hGaEfcG3JHquL-eDJkSrMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday, January 17, 2025, Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)nz> wrote:

>
> I want to concatenate the hstores,
>
>
There are no hstore aggregate functions. You’ll want to convert them
to,json first then use the json_objectagg aggregate function.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message auxsvr 2025-01-19 16:06:12 Re: Design of a reliable task processing queue
Previous Message Shaheed Haque 2025-01-19 15:17:14 Re: Design of a reliable task processing queue