Re: how to handle Pagination >
От
Kevin Hunter Kesling
Тема
Re: how to handle Pagination >
Дата
Msg-id
525D7867.80903@ncsu.edu
Ответ на
Re: how to handle Pagination > (Vik Fearing)
Список
Дерево обсуждения
how to handle Pagination > Madhavan <vbtamil@zoho.com>
Re: how to handle Pagination > jesusthefrog <jesusthefrog@gmail.com>
Re: how to handle Pagination > Vik Fearing <vik.fearing@dalibo.com>
Re: how to handle Pagination > Kevin Hunter Kesling <kmhunte2@ncsu.edu>
Re: how to handle Pagination > Kevin Hunter Kesling <kmhunte2@ncsu.edu>
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 по дате отправления
