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.
