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.
Huh? Even if you slam your brakes immediately when the light turns yellow, you might not stop on time if the yellow light is only on for, say, 100 milliseconds if you were close enough to the intersection.
This isn't at all as simple as you make it out to be, and the article made a pretty good point.