Received: from nimbus.dartmouth.edu (nimbus.dartmouth.edu [129.170.16.33]) by hub.org (8.9.3/8.9.3) with ESMTP id XAA10404 for ; Wed, 31 May 2000 23:12:56 -0400 (EDT) (envelope-from iliev@nimbus.dartmouth.edu) Received: (from iliev@localhost) by nimbus.dartmouth.edu (8.9.3/8.9.3) id XAA17634 for pgsql-sql@postgresql.org; Wed, 31 May 2000 23:12:54 -0400 From: "Alexander H. Iliev" Message-Id: <200006010312.XAA17634@nimbus.dartmouth.edu> Subject: question on diagnostics To: pgsql-sql@postgresql.org Date: Wed, 31 May 2000 23:12:54 -0400 (EDT) X-Mailer: ELM [version 2.5 PL1] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/230 Hi all, does anyone have a clue what this diagnostic from psql (v 7.0) means: ERROR: aggregate function in qual must be argument of boolean operator I got it from this query: SELECT * FROM last_payment NATURAL INNER JOIN admin_info WHERE date_part ('month', age(last_payment.date, timestamp 'now')) >= 3 AND balance > 0; last_payment is a view of a natural join of 3 tables with an aggregation: CREATE VIEW last_payment(ssn, cust_name, cust_addr, balance, date) AS SELECT customer.ssn, cust_name, cust_addr, balance, MAX(date) FROM customer, journal, payment_info WHERE customer.ssn = journal.ssn AND journal.entry_num = payment_info.entry_num GROUP BY customer.ssn, cust_name, cust_addr, balance; oh, btw this select refused to use an SQL natural join among the 3 relations - the server gives up and disconnects without warning. admin_info is a normal table. the idea being to get tuples timestamped 3 or more months ago. I get the impression both 'age' and 'date_part' functions are causing the problem - just a date comparison without them works fine. thanks for any ideas cheers alex