Horton
Menu

Re: Fwd: TSQL To Postgres - Unpivot/Union All

shammat@gmx.net

View thread
From: Thomas Kellerer <shammat@gmx.net>
To: pgsql-general@lists.postgresql.org
Date: 2023-07-20T15:07:31Z
Lists: pgsql-general 
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/