Re: variable not found in subplan target list?

On Mon, 24 Nov 2003, Klint Gore wrote:

> I've got the message "ERROR:  variable not found in subplan target lists"
> when I have a union between 2 views.  Both selects from the views run
> without the union.  Same result using intersect and except.  Same result
> using any of them with the all qualifier.  Explain of the union gives
> the error, explain of each individual select gives a result.
>
> The view definitions contain unions and cross joins.
>
> The error still occurs if I simplify the selects down to
>
>    select 'abc' from view1
>    union
>    select 'cba' from view2
>
> "PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC 2.96"
> redhat 7.2 (2.4.7-10)

Can you send a test case with table and view definitions, it's hard to
generate one from just the information above.