Re: is it possible to do this? have a subselect that returns

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.
>
>
>