News for hackers. Stuff that matters.
Re:PostgreSQL’s New LATERAL Join Type by nunwuo on Wednesday December 03, 2014 @05:45AM (#8692955)
Untested, but this is the general approach:

  SELECT unnest(ar).* FROM
    (SELECT ARRAY(SELECT tbl FROM tbl
                  WHERE .. ORDER BY .. LIMIT 2) AS ar
     FROM .. OFFSET 0) ss;
If you want a specific set of columns instead of *, you'd need to create a custom composite type to create an array of, since it's not possible to "unpack" anonymous records.

There are no comments on this comment yet.