MIME-Version: 1.0
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>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 19 Jan 2025 08:28:32 -0700
Message-ID: <CAKFQuwasxOzkA-BECEaOz1b8EOh2hGaEfcG3JHquL-eDJkSrMQ@mail.gmail.com>
Subject: concatenating hstores in a group by?
To: Brent Wood <Brent.Wood@niwa.co.nz>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f20ea0062c10cb8a"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwasxOzkA-BECEaOz1b8EOh2hGaEfcG3JHquL-eDJkSrMQ%40mail.gmail.com>
Precedence: bulk

--000000000000f20ea0062c10cb8a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=99ll want to convert th=
em
to,json first then use the json_objectagg aggregate function.

David J.

--000000000000f20ea0062c10cb8a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Friday, January 17, 2025, Brent Wood &lt;<a href=3D"mailto:Brent.Wood@ni=
wa.co.nz" target=3D"_blank">Brent.Wood@niwa.co.nz</a>&gt; wrote:<br><blockq=
uote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc =
solid;padding-left:1ex">


<div dir=3D"ltr">
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)"><br></div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
I want to concatenate the hstores,</div><div style=3D"font-family:Aptos,Apt=
os_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif;font-size:=
12pt;color:rgb(0,0,0)"><br></div></div></blockquote><div><br></div><div>The=
re are no hstore aggregate functions.=C2=A0 You=E2=80=99ll want to convert =
them to,json first then use the json_objectagg aggregate function.</div><di=
v>=C2=A0</div><div>David J.</div><div><br></div>

--000000000000f20ea0062c10cb8a--