concatenating hstores in a group by?
От | Brent Wood |
---|---|
Тема | concatenating hstores in a group by? |
Дата | |
Msg-id | SY7P300MB0761A579730344B2813CA07DA11B2@SY7P300MB0761.AUSP300.PROD.OUTLOOK.COM обсуждение исходный текст |
Ответ на | Re: pgvector extension error (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
concatenating hstores in a group by?
Re: concatenating hstores in a group by? |
Список | pgsql-general |
Hi,
I have a table with a timestamp and hstore columns with times in milliseconds.
I want to concatenate the hstores, grouped by timestamp, with the timestamps truncated to whole seconds: date_trunc('seconds', timer).
How can I concatenate all the hstores within a one second interval,
ie, something like:
select timer,
<hstores concatenated>
from (select date_trunc('seconds', timer) as timer_sec, hstore)
group by timer;
Thanks
Brent Wood
Principal Technician, Fisheries
NIWA
DDI: +64 (4) 3860529
Principal Technician, Fisheries
NIWA
DDI: +64 (4) 3860529
![]() |
Note: This email is intended solely for the use of the addressee and may contain information that is confidential or subject to legal professional privilege. If you receive this email in error please immediately notify the sender and delete the email.
В списке pgsql-general по дате отправления: