Home > mailing lists

Re: Fwd: TSQL To Postgres - Unpivot/Union All - Mailing list pgsql-general

From	Thomas Kellerer
Subject	Re: Fwd: TSQL To Postgres - Unpivot/Union All
Date	July 20, 2023 18:07:31
Msg-id	bd9eab6e-7794-9b38-3958-a08d83d15709@gmx.net Whole thread Raw
In response to	Fwd: TSQL To Postgres - Unpivot/Union All (Anthony Apollis <anthony.apollis@gmail.com>)
List	pgsql-general

Tree view

Anthony Apollis schrieb am 20.07.2023 um 14:17:
> Does not give me outputs for columns: Metric and Pricing Channel:
> image.png
>
> What am i doing wrong? Please assist?

UNPIVOT can be done using a LATERAL sub-query with a VALUES clause:

https://blog.sql-workbench.eu/post/unpivot-with-postgres/

pgsql-general by date:

From: Geoff Winkless
Date: 20 July 2023, 17:51:35
Subject: Re: TSQL To Postgres - Unpivot/Union All

From: Adrian Klaver
Date: 20 July 2023, 18:18:32
Subject: Re: My 1st JDBC and PostgreSQL

Re: Fwd: TSQL To Postgres - Unpivot/Union All - Mailing list pgsql-general

Previous

Next