Re: how to handle Pagination > - Mailing list pgsql-novice

From Kevin Hunter Kesling
Subject Re: how to handle Pagination >
Date
Msg-id 525D7867.80903@ncsu.edu
Whole thread Raw
In response to Re: how to handle Pagination >  (Vik Fearing <vik.fearing@dalibo.com>)
List pgsql-novice
At 12:54pm -0400 Tue, 15 Oct 2013, Vik Fearing wrote:
> On 10/15/2013 05:01 PM, jesusthefrog wrote:
>> You will probably want to use OFFSET and LIMIT, which are the
>> window size and page. Something like
>>
>> SELECT .. FROM ... WHERE ... ORDER BY (...) OFFSET y LIMIT x
>>
>> So say you want to get 100 records at a time. You would get page 1
>> with OFFSET 0 LIMIT 100, then page 2 with OFFSET 100, OFFSET 200,
>> and so on.
>
> You will most certainly NOT want to use that technique.
>
> Instead, try these links:

Doh!  My previous email was late!  Vik wins this round!  :-)

Kevin


pgsql-novice by date:

Previous
From: Kevin Hunter Kesling
Date:
Subject: Re: how to handle Pagination >
Next
From: Kinnard Hockenhull
Date:
Subject: Re: error: there is no parameter $1