Re: [SQL] question on diagnostics

2000-05-31 Thread Alexander H. Iliev
> > oh, btw this select refused to use an SQL natural join among the 3 > > relations - the server gives up and disconnects without warning. > > That sounds like a garden-variety bug. I'd be willing to look at it > if I had a complete example to follow, but I don't want to try to > reverse-engine

[SQL] question on diagnostics

2000-05-31 Thread Alexander H. Iliev
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 'no