Re: [PATCH] Add native PIVOT syntax for SQL Server/Oracle compatibility

2025-11-26 Thread Kirill Reshke
On Tue, 25 Nov 2025 at 13:11, Myles Lewis wrote: > > I've developed a patch that adds native PIVOT syntax to PostgreSQL, > enabling SQL Server and Oracle-style pivot queries. > > Example: > SELECT region > FROM sales > PIVOT (SUM(revenue) FOR quarter IN ('Q1', 'Q2', 'Q3', 'Q4')); > > Key fea

Re: [PATCH] Add native PIVOT syntax for SQL Server/Oracle compatibility

2025-11-25 Thread Peter Eisentraut
On 25.11.25 06:01, Myles Lewis wrote: I've developed a patch that adds native PIVOT syntax to PostgreSQL, enabling SQL Server and Oracle-style pivot queries. Your patch does not contain any documentation, so it's hard to tell what this is supposed to do if you don't already know those other pr