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.