Re: Paged Query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





Понеділок, 9 липня 2012 р. користувач Misa Simic <misa.simic@xxxxxxxxx> написав:
>
>
> 2012/7/9 Gregg Jaskiewicz <gryzman@xxxxxxxxx>
>>
>> Use cursors.
>> By far the most flexible. offset/limit have their down sides.
>
>
> Well, I am not aware what down sides there are in LIMIT OFFSET what does not exist in any other solutions for paged queries...

where key > last-previous-key order by key

--
Best regards,
 Vitalii Tymchyshyn

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux