Re: [SQL] Window function frame clause

2012-02-17 Thread vpapavas
Thank you David for your fast response. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Window-function-frame-clause-tp5491171p5494599.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)

Re: [SQL] Window function frame clause

2012-02-16 Thread David Johnston
On Feb 16, 2012, at 20:01, vpapavas wrote: > Hello all, > > I am trying to use this query in a toy database with customers and orders in > order to understand the capabilities of partitioning. In plain english what > I want to do is to select the orders of each customer and return only 3 of > t

[SQL] Window function frame clause

2012-02-16 Thread vpapavas
Hello all, I am trying to use this query in a toy database with customers and orders in order to understand the capabilities of partitioning. In plain english what I want to do is to select the orders of each customer and return only 3 of those orders. The query I am using is this: select c_cu