Home > mailing lists

concatenating hstores in a group by? - Mailing list pgsql-general

From	David G. Johnston
Subject	concatenating hstores in a group by?
Date	January 19 18:28:32
Msg-id	CAKFQuwasxOzkA-BECEaOz1b8EOh2hGaEfcG3JHquL-eDJkSrMQ@mail.gmail.com Whole thread Raw
In response to	concatenating hstores in a group by? (Brent Wood <Brent.Wood@niwa.co.nz>)
Responses	Re: concatenating hstores in a group by? Re: concatenating hstores in a group by?
List	pgsql-general

On Friday, January 17, 2025, Brent Wood <Brent.Wood@niwa.co.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.

From: Shaheed Haque
Date: 19 January, 18:17:14
Subject: Re: Design of a reliable task processing queue

From: auxsvr@gmail.com
Date: 19 January, 19:06:12
Subject: Re: Design of a reliable task processing queue