March 7th, 2011 by depesz | Tags: array, foreach, generate_subscripts, pg91, plpgsql, postgresql, unnest | 3 comments »
On 16th of February, Tom Lane committed patch: Add FOREACH IN ARRAY looping to plpgsql. (I'm not entirely sure that we've finished bikeshedding the syntax details, but the functionality seems OK.) Pavel Stehule, reviewed by Stephen Frost and Tom Lane
July 25th, 2010 by depesz | Tags: generate_series, order, postgresql, row_number, unnest, window, window functions | 4 comments »
Let's imagine simple situation - you have table of objects (each with id), and you want objects 3, 71, 5 and 16. And in that order! How to do it?
November 14th, 2008 by depesz | Tags: aggregate, arrays, array_agg, pg84, postgresql, unnest | 4 comments »
Finally, we got very important addons to PostgreSQL, which help with dealing with arrays. It solves a lot of problems, which were usually solved with standard cookbook code, which was in faqs, blog posts and number of examples on irc.
