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

From David G. Johnston
Subject Re: TSQL To Postgres - Unpivot/Union All
Date
Msg-id CAKFQuwZi0MzMxNghVk8DBiqACbjp8YNFKF9g44_hK1dBX8BzhA@mail.gmail.com
Whole thread Raw
In response to Fwd: TSQL To Postgres - Unpivot/Union All  (Anthony Apollis <anthony.apollis@gmail.com>)
List pgsql-general
On Thursday, July 20, 2023, Anthony Apollis <anthony.apollis@gmail.com> wrote:

I am trying to convert this TSQL:
 
This doesn’t really seem relevant all that relevant at this point.  Given some input data either the query produces the expected result or it doesn’t.
 

What am i doing wrong? Please assist?


You need to provide more info - specifically the input data mentioned above.  Try making a reproducer on this fiddle site.


David J.

pgsql-general by date:

Previous
From: Anthony Apollis
Date:
Subject: Fwd: TSQL To Postgres - Unpivot/Union All
Next
From: Geoff Winkless
Date:
Subject: Re: TSQL To Postgres - Unpivot/Union All