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

From Jaime Casanova
Subject Re: Implementing next 30 (or so) rows "sliding window"
Date
Msg-id 3073cc9b0912081142x4738ed1of5bd457edb19787b@mail.gmail.com
Whole thread Raw
In response to Re: Implementing next 30 (or so) rows "sliding window"  (Allan Kamau <kamauallan@gmail.com>)
Responses Re: Implementing next 30 (or so) rows "sliding window"  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-general
On Tue, Dec 8, 2009 at 2:12 PM, Allan Kamau <kamauallan@gmail.com> wrote:
> Hi,
> I did follow the basic advise and consulted the documentation for
> "SELECT" and came across "[ FETCH { FIRST | NEXT } [ count ] { ROW |
> ROWS } ONLY]" clause which seems to satisfy my requirement.
>

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

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

pgsql-general by date:

Previous
From: Allan Kamau
Date:
Subject: Re: Implementing next 30 (or so) rows "sliding window"
Next
From: Guillaume Lelarge
Date:
Subject: Re: Tuesday (PST8PDT) Jeff Davis Presents: Operator Exclusion Constraints