Search Postgresql Archives
concatenating hstores in a group by?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: concatenating hstores in a group by?
From
: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date
: Sun, 19 Jan 2025 08:28:32 -0700
Cc
: "pgsql-general@xxxxxxxxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <
SY7P300MB0761A579730344B2813CA07DA11B2@SY7P300MB0761.AUSP300.PROD.OUTLOOK.COM
>
References
: <
CH2PR01MB5765698BB9F71CEB662D5AE4AD1B2@CH2PR01MB5765.prod.exchangelabs.com
> <
2268303.1737134384@sss.pgh.pa.us
> <
SY7P300MB0761A579730344B2813CA07DA11B2@SY7P300MB0761.AUSP300.PROD.OUTLOOK.COM
>
On Friday, January 17, 2025, Brent Wood <
Brent.Wood@xxxxxxxxxx
> 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.
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: concatenating hstores in a group by?
From:
Brent Wood
Re: concatenating hstores in a group by?
From:
Tom Lane
References
:
pgvector extension error
From:
Zacher, Stacy
Re: pgvector extension error
From:
Tom Lane
concatenating hstores in a group by?
From:
Brent Wood
Prev by Date:
Re: Design of a reliable task processing queue
Next by Date:
Re: Design of a reliable task processing queue
Previous by thread:
concatenating hstores in a group by?
Next by thread:
Re: concatenating hstores in a group by?
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
