Re: Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable

Daniel Grace <dgrace@wingsnw.com> writes:
> The following nonsensical query causes PostgreSQL to fail with ERROR: plan
> should not reference subplan's variable.  (This was stripped down from an
> 'useful' query that triggered the same bug).  First encountered on 8.3.4,
> reproduced on 8.3.7

Hmmm ... I guess something is getting confused about the level of query
nesting.  FWIW, you can avoid the bug in these two examples by omitting
the inner "SELECT" keyword, which is useless anyway.  Perhaps it is
needed in your real query though ...

            regards, tom lane