On Fri, Aug 21, 2009 at 9:22 AM, Greg Stark<gsst...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
