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?
