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
>
>I don't think it's possible but it would simplify my life a whole heck of a
>lot if it was, so I figured I would double-check before tearing my hair out.
>
>
>