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

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 products. 
Can you supply at least some informal documentation, and maybe some 
links to relevant documentation from those other products.

> - Supports SUM, COUNT, AVG, MIN, MAX

Hardcoding aggregate names like this is not going to work.  Aggregate 
functions can be user-defined, so you can't tell just from the name what 
they are doing.  You'll need to look them up in the catalog based on 
their properties.