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 thishttps://www.postgresql.org/docs/current/tablefunc.htmlorselect ..., max(value) filter (where name = 'name1') as name1, max(value) filter (where name = 'name2') as name2, etc from tbl group by ...David J.
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
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных