Postgres Pro
Downloads
Home   >   mailing lists

Re: Implementing next 30 (or so) rows "sliding window" - Mailing list pgsql-general

From Richard Broersma
Subject Re: Implementing next 30 (or so) rows "sliding window"
Date
Msg-id 396486430912081239y1bf73eebj7f53afe7840cd928@mail.gmail.com
Whole thread Raw
In response to Re: Implementing next 30 (or so) rows "sliding window"  (Jaime Casanova <jcasanov@systemguards.com.ec>)
List pgsql-general
Tree view 
On Tue, Dec 8, 2009 at 11:42 AM, Jaime Casanova
<jcasanov@systemguards.com.ec> wrote:

> that's basically LIMIT, you have to combine that with OFFSET

Keep in mind that offset begins to preform badly for large values.

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

pgsql-general by date:

Previous
From: jackassplus
Date:
Subject: Counts and percentages and such
Next
From: "Gauthier, Dave"
Date:
Subject: Re: how to allow a sysid to be a superuser?