Oracle转到PostGreSQL用什么取代UNPIVOT？

Question

代码如下

UNPIVOT(
                    AA 
                    FOR SJ 
                    IN(I1,
                                                                                                                                                                                                                                                                                    I2,
                                                                                                                                                                                                                                                                                I3,
                                                                                                                                                                                                                                                                                I4,
                                                                                                                                                                                                                                                                                I5,
                                                                                                                                                                                                                                                                                I6,
                                                                                                                                                                                                                                                                                I7,
                                                                                                                                                                                                                                                                                I8,
                                                                                                                                                                                                                                                                                I9,
                                                                                                                                                                                                                                                                                I10,
                                                                                                                                                                                                                                                                                I11,
                                                                                                                                                                                                                                                                                I12,
                                                                                                                                                                                                                                                                                I13,
                                                                                                                                                                                                                                                                                I14,
                                                                                                                                                                                                                                                                                I15,
                                                                                                                                                                                                                                                                                I16,
                                                                                                                                                                                                                                                                                I17,
                                                                                                                                                                                                                                                                                I18,
                                                                                                                                                                                                                                                                                I19,
                                                                                                                                                                                                                                                                                I20,
                                                                                                                                                                                                                                                                                I21,
                                                                                                                                                                                                                                                                                I22,
                                                                                                                                                                                                                                                                                I23,
                                                                                                                                                                                                                                                                                I24,
                                                                                                                                                                                                                                                                                I25,
                                                                                                                                                                                                                                                                                I26,
                                                                                                                                                                                                                                                                                I27,
                                                                                                                                                                                                                                                                                I28,
                                                                                                                                                                                                                                                                                I29,
                                                                                                                                                                                                                                                                                I30,
                                                                                                                                                                                                                                                                                I31,
                                                                                                                                                                                                                                                                                I32,
                                                                                                                                                                                                                                                                                I33,
                                                                                                                                                                                                                                                                                I34,
                                                                                                                                                                                                                                                                                I35,
                                                                                                                                                                                                                                                                                I36,
                                                                                                                                                                                                                                                                                I37,
                                                                                                                                                                                                                                                                                I38,
                                                                                                                                                                                                                                                                                I39,
                                                                                                                                                                                                                                                                                I40,
                                                                                                                                                                                                                                                                                I41,
                                                                                                                                                                                                                                                                                I42,
                                                                                                                                                                                                                                                                                I43,
                                                                                                                                                                                                                                                                                I44,
                                                                                                                                                                                                                                                                                I45,
                                                                                                                                                                                                                                                                                I46,
                                                                                                                                                                                                                                                                                I47,
                                                                                                                                                                                                                                                                                I48,
                                                                                                                                                                                                                                                                                I49,
                                                                                                                                                                                                                                                                                I50,
                                                                                                                                                                                                                                                                                I51,
                                                                                                                                                                                                                                                                                I52,
                                                                                                                                                                                                                                                                                I53,
                                                                                                                                                                                                                                                                                I54,
                                                                                                                                                                                                                                                                                I55,
                                                                                                                                                                                                                                                                                I56,
                                                                                                                                                                                                                                                                                I57,
                                                                                                                                                                                                                                                                                I58,
                                                                                                                                                                                                                                                                                I59,
                                                                                                                                                                                                                                                                                I60,
                                                                                                                                                                                                                                                                                I61,
                                                                                                                                                                                                                                                                                I62,
                                                                                                                                                                                                                                                                                I63,
                                                                                                                                                                                                                                                                                I64,
                                                                                                                                                                                                                                                                                I65,
                                                                                                                                                                                                                                                                                I66,
                                                                                                                                                                                                                                                                                I67,
                                                                                                                                                                                                                                                                                I68,
                                                                                                                                                                                                                                                                                I69,
                                                                                                                                                                                                                                                                                I70,
                                                                                                                                                                                                                                                                                I71,
                                                                                                                                                                                                                                                                                I72,
                                                                                                                                                                                                                                                                                I73,
                                                                                                                                                                                                                                                                                I74,
                                                                                                                                                                                                                                                                                I75,
                                                                                                                                                                                                                                                                                I76,
                                                                                                                                                                                                                                                                                I77,
                                                                                                                                                                                                                                                                                I78,
                                                                                                                                                                                                                                                                                I79,
                                                                                                                                                                                                                                                                                I80,
                                                                                                                                                                                                                                                                                I81,
                                                                                                                                                                                                                                                                                I82,
                                                                                                                                                                                                                                                                                I83,
                                                                                                                                                                                                                                                                                I84,
                                                                                                                                                                                                                                                                                I85,
                                                                                                                                                                                                                                                                                I86,
                                                                                                                                                                                                                                                                                I87,
                                                                                                                                                                                                                                                                                I88,
                                                                                                                                                                                                                                                                                I89,
                                                                                                                                                                                                                                                                                I90,
                                                                                                                                                                                                                                                                                I91,
                                                                                                                                                                                                                                                                                I92,
                                                                                                                                                                                                                                                                                I93,
                                                                                                                                                                                                                                                                                I94,
                                                                                                                                                                                                                                                                                I95,
                                                                                                                                                                                                                                                                                I96))

pgSQL里面没有UNPIVOT函数，需要怎么修改才能达到同样的效果

Answer 1

用tablefunc插件的crosstab函数，可以参考下：
https://blog.csdn.net/weixin_39540651/article/details/103886411?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159411669619725222408856%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=159411669619725222408856&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~blog~first_rank_v1~rank_blog_v1-1-103886411.pc_v1_rank_blog_v1&utm_term=pivot