On Wed, 2003-09-03 at 13:49, Ron wrote:
> see below....
>
> Greg Stark wrote:
>
> >So I have a query in which some of the select values are subqueries. The
> >subqueries are aggregates so I don't want to turn this into a join, it would
> >become too complex and postgres would have trouble optimizing things.
> >
> >So my question is, is there some way to have a subselect return multiple
> >columns and break those out in the outer query?
> >
> >Something like:
> >
> >SELECT x,y,z,
> > (SELECT a,b FROM foo) AS (sub_a,sub_b)
> > FROM tab
> >
>
> SELECT x, y, z, SS.*
> FROM tab, (SELECT a,b FROM foo) SS
But where's the join between tab and foo? Wouldn't you then get
a combinatorial explosion?
--
-----------------------------------------------------------------
Ron Johnson, Jr. [EMAIL PROTECTED]
Jefferson, LA USA
"Perl is worse than Python because people wanted it worse."
Larry Wall, 10/14/1998
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
