Re: transpose time-series columnar data

Поиск
Список
Период
Сортировка
От Cachique
Тема Re: transpose time-series columnar data
Дата
Msg-id CAEfeRhVcEa=UtLtGE1TAF14DTWLSsqya1Oo_r4qptJHCDUPf2A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: transpose time-series columnar data  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения
As suggested by David I would use Tablefunc.

This query should work.


select * from crosstab (
 'select timestamp, name, value from originaltable',
 'select distinct name from originaltable order by name'
 )
as transposedtable (timestamp varchar, name1 varchar, name2 varchar, name3 varchar)

Regards,
Walter


El mar, 17 de ago. de 2021 a la(s) 14:42, David G. Johnston (david.g.johnston@gmail.com) escribió:
On Tue, Aug 17, 2021 at 11:29 AM Edu Gargiulo <egargiulo@gmail.com> wrote:

I need to transpose and return one row for a single timestamp and one column for every name (fixed number of names), something like this



or

select ..., max(value) filter (where name = 'name1') as name1, max(value) filter (where name = 'name2') as name2, etc from tbl group by ...

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: transpose time-series columnar data
Следующее
От: A Z
Дата:
Сообщение: Serious Assistance with PostgreSQL True Infinite Arbitrary Precision Maths.