[COMMITTERS] pgsql-server: Test HAVING condition before computing targetlist of an

2004-07-10 Thread Tom Lane
Log Message: --- Test HAVING condition before computing targetlist of an Aggregate node. This is required by SQL spec to avoid failures in cases like SELECT sum(win)/sum(lose) FROM ... GROUP BY ... HAVING sum(lose) > 0; AFAICT we have gotten this wrong since day one. Kudos to Holger Jako

[COMMITTERS] pgsql-server: Test HAVING condition before computing targetlist of an

2004-07-10 Thread Tom Lane
Log Message: --- Test HAVING condition before computing targetlist of an Aggregate node. This is required by SQL spec to avoid failures in cases like SELECT sum(win)/sum(lose) FROM ... GROUP BY ... HAVING sum(lose) > 0; AFAICT we have gotten this wrong since day one. Kudos to Holger Jako