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 | 3 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.
