Greg Sabino Mullane wrote:
>
>>> Granted, I use a few MySQL features for this; I'm not sure if LIMIT
>>> exists in postgresql, and I'm fairly sure that the SQL_CALC_FOUND_ROWS
>>> directive (which will return the total rows in a select statement
>>> regardless of the LIMIT directives) doesn't...
> (a) Create a database cursor and page through it
> (b) Repeat the query (making sure there is a sort criterium) at each
> page request, starting at a variable offset and limiting the
> result set
> (c) Do the whole query at once, putting the results in some kind
> of array.
>
> same
