Problem with Avg function and Money type in PostgreSQL 15
Erki Eessaar <erki.eessaar@taltech.ee>
From: Erki Eessaar <erki.eessaar@taltech.ee>
To: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2022-10-30T10:15:32Z
Lists: pgsql-bugs
CREATE TABLE Product(product_id SERIAL PRIMARY KEY, price MONEY NOT NULL); INSERT INTO Product(price) VALUES (30); INSERT INTO Product(price) VALUES (40); SELECT Avg(price) AS av FROM Product; PostgreSQL 14.5 ERROR: function avg(money) does not exist LINE 1: SELECT Avg(price) AS av FROM Product; HINT: No function matches the given name and argument types. You might need to add explicit type casts. PostgreSQL 15 ERROR: stack depth limit exceeded HINT: Increase the configuration parameter "max_stack_depth" (currently 2048kB), after ensuring the platform's stack depth limit is adequate. CONTEXT: SQL function "avg" during inlining SQL function "avg" during startup SQL function "avg" statement 1 --this line is repeated more than 3000 times It seems to me that PostgreSQL 14.5 response is much better than in case of PostgreSQL 15. Best regards Erki Eessaar