Re: join from array or cursor

On Fri, Aug 21, 2009 at 9:22 AM, Greg Stark 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