"David G. Johnston" <david.g.johnston@gmail.com> writes:
> 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.
It would be trivial to make a user-defined one.
More or less (untested)
create aggregate hstore_agg(hstore)
(
sfunc = hs_concat,
stype = hstore
);
Either way though, the order of aggregation is unspecified and thus
it's unclear which input will win when there are duplicate keys.
If that matters then you'll need to think about how you want
to resolve it.
regards, tom lane
