I thought I'd pass this around as an interested reference page. Gives us an idea of how far we need to go to compete with Oracle for data analysis...
http://www.akadia.com/services/ora_analytic_functions.html
Interesting stuff: * Accessing rows around your current row * Lag, lead * Top N queries * Ranges * etc.
Cheers,
Chris
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
