Daniel Grace <dgr...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs