Re: Implementing next 30 (or so) rows "sliding window"

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: Allan Kamau <kamauallan(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Implementing next 30 (or so) rows "sliding window"
Date: 2009-12-08 20:39:26
Message-ID: 396486430912081239y1bf73eebj7f53afe7840cd928@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 8, 2009 at 11:42 AM, Jaime Casanova
<jcasanov(at)systemguards(dot)com(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2009-12-08 20:44:09 Re: how to allow a sysid to be a superuser?
Previous Message Guillaume Lelarge 2009-12-08 20:11:11 Re: Tuesday (PST8PDT) Jeff Davis Presents: Operator Exclusion Constraints