Received: from mail.opentec.com.au ([203.5.51.3]) by hub.org (8.10.1/8.10.1) with ESMTP id e662dZS02683 for ; Wed, 5 Jul 2000 22:39:36 -0400 (EDT) Received: from opentec.com.au (ochre) by mail.opentec.com.au (Sun Internet Mail Server sims.3.5.1999.07.30.00.05.p8) with ESMTP id <0FX9001028SS6C@mail.opentec.com.au> for pgsql-sql@hub.org; Thu, 6 Jul 2000 12:41:17 +1000 (EST) Date: Thu, 06 Jul 2000 12:45:15 +1000 From: Paul McGarry Subject: Re: ERROR: ExecEvalAggref: no aggregates in thisexpressioncontext To: Tom Lane Cc: pgsql-sql@hub.org Message-id: <3963F2BB.3EF47D@opentec.com.au> MIME-version: 1.0 X-Mailer: Mozilla 4.61 [en] (Win98; I) Content-type: multipart/mixed; boundary="------------71340C184B41A8C8B5C8A681" X-Accept-Language: en References: <200007042201.e64M1GS36467@hub.org> <3962834C.5EF48AB7@opentec.com.au> <3397.962817322@sss.pgh.pa.us> <3963DA0C.B248C79D@opentec.com.au> X-Archive-Number: 200007/52 This is a multi-part message in MIME format. --------------71340C184B41A8C8B5C8A681 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Paul McGarry wrote: > If I do a 'SELECT * from view_name' and get 8 rows of data, when I > do a 'SELECT count(*) from view_name' I get 8 rows of the > number 1 returned. I've attached a script which will generate a bunch of tables and a view then do a select * and select count(*) on that view. It is almost certainly to do with the GROUPing used in the view. The ouput I get is: select * from entry_view; id | description_text | parent_id | minamount ----+------------------+-----------+----------- 1 | entry one | 0 | 1 2 | entry two | 1 | 2 3 | entry three | 2 | 7 (3 rows) select count(*) from entry_view; count ------- 2 2 1 (3 rows) That doesn't make much sense to me... Postgres 7.0.2 by the way. I'll work on the more complex case where I got the ERROR: ExecEvalAggref error message now. -- Paul McGarry mailto:paulm@opentec.com.au Systems Integrator http://www.opentec.com.au Opentec Pty Ltd http://www.iebusiness.com.au 6 Lyon Park Road Phone: (02) 9878 1744 North Ryde NSW 2113 Fax: (02) 9878 1755 --------------71340C184B41A8C8B5C8A681 Content-Type: application/x-unknown-content-type-sql_auto_file; name="countbug.sql" Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="countbug.sql" LyogU2NyaXB0IGRlc2lnbmVkIHRvIGRlbW9uc3RyYXRlIHNlbGVjdCBjb3Vu dCgqKSBwcm9ibGVtOyAqLw0KDQpDUkVBVEUgVEFCTEUgcGFyZW50KA0KCXBh cmVudF9pZCBJTlQ0IFBSSU1BUlkgS0VZLA0KCXBhcmVudF9uYW1lIHRleHQs DQoJcGFyZW50X2FjdGl2aXR5IGludDINCik7DQpHUkFOVCBBTEwgb24gcGFy ZW50IFRPIFBVQkxJQzsNCklOU0VSVCBJTlRPIHBhcmVudCBWQUxVRVMgKDAs J3plcm8nLDApOw0KSU5TRVJUIElOVE8gcGFyZW50IFZBTFVFUyAoMSwnb25l JywwKTsNCklOU0VSVCBJTlRPIHBhcmVudCBWQUxVRVMgKDIsJ3R3bycsMCk7 DQoNCkNSRUFURSBUQUJMRSBlbnRyeSgNCgllbnRyeV9pZCBJTlQ0IFBSSU1B UlkgS0VZLA0KCWVudHJ5X2Rlc2NyaXB0aW9uX3RleHQgVEVYVCwNCgllbnRy eV9saXZlIGJvb2wgTk9UIE5VTEwgREVGQVVMVCAndCcNCik7DQpHUkFOVCBB TEwgb24gZW50cnkgVE8gUFVCTElDOw0KSU5TRVJUIElOVE8gZW50cnkgVkFM VUVTICgxLCdlbnRyeSBvbmUnLCd0Jyk7DQpJTlNFUlQgSU5UTyBlbnRyeSBW QUxVRVMgKDIsJ2VudHJ5IHR3bycsJ3QnKTsNCklOU0VSVCBJTlRPIGVudHJ5 IFZBTFVFUyAoMywnZW50cnkgdGhyZWUnLCd0Jyk7DQoNCkNSRUFURSBUQUJM RSBlbnRyeV9wYXJlbnRfbWFwKA0KCXBhcmVudF9pZCBJTlQ0IE5PVCBOVUxM IFJFRkVSRU5DRVMgcGFyZW50IE9OIERFTEVURSBDQVNDQURFLA0KCWVudHJ5 X2lkIElOVDQgTk9UIE5VTEwgUkVGRVJFTkNFUyBlbnRyeSBPTiBERUxFVEUg Q0FTQ0FERQ0KKTsNCkdSQU5UIEFMTCBvbiBlbnRyeV9wYXJlbnRfbWFwIFRP IFBVQkxJQzsNCklOU0VSVCBJTlRPIGVudHJ5X3BhcmVudF9tYXAgVkFMVUVT ICgwLDEpOw0KSU5TRVJUIElOVE8gZW50cnlfcGFyZW50X21hcCBWQUxVRVMo MSwyKTsNCklOU0VSVCBJTlRPIGVudHJ5X3BhcmVudF9tYXAgVkFMVUVTICgy LDMpOw0KQ1JFQVRFIElOREVYIGVfcF9tX3BfaWR4IE9OIGVudHJ5X3BhcmVu dF9tYXAgKHBhcmVudF9pZCk7DQpDUkVBVEUgSU5ERVggZV9wX21fZV9pZHgg T04gZW50cnlfcGFyZW50X21hcCAoZW50cnlfaWQpOw0KDQpDUkVBVEUgVEFC TEUgZGV0YWlsICgNCglkZXRhaWxfaWQgSU5UNCBQUklNQVJZIEtFWSwNCgll bnRyeV9pZCBJTlQ0IE5PVCBOVUxMIFJFRkVSRU5DRVMgZW50cnkgT04gREVM RVRFIE5PIEFDVElPTiwNCglhbW91bnQgSU5UNCBOT1QgTlVMTA0KKTsNCkdS QU5UIEFMTCBPTiBkZXRhaWwgdG8gUFVCTElDOw0KQ1JFQVRFIElOREVYIGRl dGFpbF9lbnRyeV9pZF9pZHggT04gZGV0YWlsIChlbnRyeV9pZCk7DQpJTlNF UlQgSU5UTyBkZXRhaWwgVkFMVUVTICgxLDEsMSk7DQpJTlNFUlQgSU5UTyBk ZXRhaWwgVkFMVUVTICgyLDEsNSk7DQpJTlNFUlQgSU5UTyBkZXRhaWwgVkFM VUVTICgzLDIsMik7DQpJTlNFUlQgSU5UTyBkZXRhaWwgVkFMVUVTICg0LDIs MTAwKTsNCklOU0VSVCBJTlRPIGRldGFpbCBWQUxVRVMgKDUsMyw3KTsNCg0K DQoNCkNSRUFURSBWSUVXIGVudHJ5X3ZpZXcgQVMNClNFTEVDVCBlbnRyeS5l bnRyeV9pZCBhcyBpZCwNCiAgICAgICBlbnRyeS5lbnRyeV9kZXNjcmlwdGlv bl90ZXh0IGFzIGRlc2NyaXB0aW9uX3RleHQsDQogICAgICAgZW50cnlfcGFy ZW50X21hcC5wYXJlbnRfaWQsDQogICAgICAgbWluIChkZXRhaWwuYW1vdW50 KSBhcyBtaW5hbW91bnQNCkZST00gICBlbnRyeSwNCiAgICAgICBlbnRyeV9w YXJlbnRfbWFwLA0KICAgICAgIHBhcmVudCwNCiAgICAgICBkZXRhaWwNCldI RVJFICBlbnRyeV9saXZlPSd0Jw0KICBBTkQgIGVudHJ5LmVudHJ5X2lkPWVu dHJ5X3BhcmVudF9tYXAuZW50cnlfaWQNCiAgQU5EICBlbnRyeV9wYXJlbnRf bWFwLnBhcmVudF9pZD1wYXJlbnQucGFyZW50X2lkDQogIEFORCAgcGFyZW50 LnBhcmVudF9hY3Rpdml0eT0wDQogIEFORCAgZGV0YWlsLmVudHJ5X2lkPWVu dHJ5LmVudHJ5X2lkDQpHUk9VUCBCWSANCiAgICAgIGVudHJ5LmVudHJ5X2lk LA0KICAgICAgZW50cnkuZW50cnlfZGVzY3JpcHRpb25fdGV4dCwNCiAgICAg IGVudHJ5X3BhcmVudF9tYXAucGFyZW50X2lkDQo7DQpHUkFOVCBTRUxFQ1Qg T04gZW50cnlfdmlldyBUTyBQVUJMSUM7DQoNClNFTEVDVCAqIGZyb20gZW50 cnlfdmlldzsNCg0KU0VMRUNUIGNvdW50KCopIGZyb20gZW50cnlfdmlldzsN Cg0K --------------71340C184B41A8C8B5C8A681--