Postgres Pro
Downloads
Home   >   mailing lists

Re: union & subqueries - Mailing list pgsql-sql

From Tom Lane
Subject Re: union & subqueries
Date
Msg-id 3936.983553490@sss.pgh.pa.us
Whole thread Raw
In response to union & subqueries  (Martin Lillepuu <martin@lillepuu.com>)
List pgsql-sql
Tree view 
Martin Lillepuu <martin@lillepuu.com> writes:
> when I run following sql in 2 separate queries, they work fine. but when
> used as one beg statement with UNION, I get following error:
>  join_references: variable not in subplan target lists

AFAICT this works OK in 7.1beta.
        regards, tom lane

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Help creating rules/triggers/functions
Next
From: "Tangorre, Michael T."
Date:
Subject: Database Question