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

2025-11-26 Thread Michael Paquier
On Tue, Nov 25, 2025 at 09:21:49PM +0100, Peter Eisentraut wrote: > 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 products. Can > you supply at least some informal documentation, and maybe some links to > rele

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