Re: [SQL] Problem with subquery joined to a view

2000-11-21 Thread Tom Lane
Kyle <[EMAIL PROTECTED]> writes: > The fourth "select" uses a regular subquery. It gives the error: > psql:datbug.sql:44: ERROR: Sub-SELECT uses un-GROUPed attribute > pay_req.wdate from outer query This appears to work correctly in current sources. In 7.0.* and before grouped views do not wor

[SQL] Problem with subquery joined to a view

2000-11-21 Thread Kyle
I assume this is a bug of some kind.  Here's a neat little example to demonstrate it.  If it helps make 7.1 better, great. If I've done something wrong, I'd like to figure that out too if anyone can help. This forms a bunch of hypothetical payroll entries and then makes a view which aggregates th