On Fri, Aug 21, 2009 at 9:22 AM, Greg Stark<gsstark@mit.edu> wrote:
> Of course immediately upon hitting send I did think of a way:
>
> SELECT (r).*
> FROM (SELECT (SELECT x FROM x WHERE a=id) AS r
> FROM unnest(array[1,2]) AS arr(id)
> ) AS subq;
nice use of composite type in select-list subquery. I use this
approach often...it's a 'wonder trick'.
merlin
