Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Fwd: TSQL To Postgres - Unpivot/Union All
From: Thomas Kellerer <shammat@xxxxxxx>
Date: Thu, 20 Jul 2023 17:07:31 +0200
In-reply-to: <CAJyMCYLL-mMuCfXT8M1kD-=6=r8YHHrSGbT-rN25vCwtVyr1jg@mail.gmail.com>
References: <CAJyMCYJ+JGpHtpV36UP+kUAW4LoprmgbgDPLCpe_8A0xbe=GZA@mail.gmail.com> <CAJyMCYLL-mMuCfXT8M1kD-=6=r8YHHrSGbT-rN25vCwtVyr1jg@mail.gmail.com>
Ui-outboundreport: notjunk:1;M01:P0:L0tTrOw6oD8=;bpIWqA3i3Mu+/oBsCJ8itjmnOkf atXsbcQUg6axdqccrDqibn3OuRztmWdA0w9wZwIfCka+bdDjtquLTH/IJp60K0+n40rsZD88i jNxPvR8x3Jm9vTKCZA+MpNGHROIIUKzjD0yQvdrk1lQM4ZZtcps1RhmrV8TdQ61HTWOOHQCFx G3fRV2Lf+si+OFiJfXwaZ5cli5od4B3C7yasB62MnQrbpuUNSgfM44PCGyqQO1CGJBrOPf9Ah LFKQnqN0X/mpMikaS9xcJkmTDEaqUsU6I2jORCDG3Gx5/V2gOKK1uE1QHVCQqumynGGzNZ9KJ +6FVAIHlc/6AakVQFpCwokSO8OgUgiyE0W76eLnLZN1zxu1T5Q8xEuWqsQo11ec9ctabi7f29 HO3frUF5csPVQPggqBepFgTABZkpUGYwoRourJqT4+U5dSyoDmSpmAEFsrYgLyEwsTmldaTsS fLYUj+BXtqNWx/EXFnq6+3+S0F4v4+uUb6WktMay/ZXSUvMPafxKH762x9Y0OUZ5Xj8hZJrjB frbt4aoRah793bcyVfCuqRej37xB/48131qd+FImX40TQfVjpDehwHoKh2A2Tu+BcHhU9w4LL dPWbwJV1InWoP0gKKreIx6CfLC0EEKXMAmN13ZMzbmT4ROOA6528qyU4lYV6Hx4J7/D97Sl9y cwZtWwrfa8mSIo38X8pZmK3jnFQdYMlRus2F+9oAXe7+GmpDrlXHGJ7O8BhXi8hVgDyi6Glhp /omenfq1avvIrTpvj9jZVDJ0uzIVp0m+VjR/c0izPx/EOEi+O28DgGKCW91/xz9hknZbIeXKw I6UrZiodT2w1rCY36E3hST2Kx80Aevm76MfR9qh2wH9sGH+tValJZNTRy7NNdZjs6kioRk7lh 3CbtUOBkdSlJ5t2iA/WTyY+kArB5+/EjTna2wPe43MfeoSGkqQEjCfvzLOM8CiTfdIv0MBXhY 8Z9EDA==
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666


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/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Fwd: TSQL To Postgres - Unpivot/Union All
  - From: Anthony Apollis

Prev by Date: Re: TSQL To Postgres - Unpivot/Union All
Next by Date: Re: My 1st JDBC and PostgreSQL
Previous by thread: Re: TSQL To Postgres - Unpivot/Union All
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]