On Mon, Jul 7, 2008 at 4:54 AM, Jack Brown <[EMAIL PROTECTED]> wrote:
Richard Broersma escreveu:
in the mean time i did some research for other rdbms and i guess, what i was
looking for was more along the lines of e.g. the row_number() function of mssql
[1]. fwiw this seems like the most efficient pagination solution, assuming, of
course, the rdbms implements this functionality efficiently.
[1]: http://www.davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx
actually, this functionality is most commonly implemented in a
reporting utility. But it can be done using SQL.
Sure, there is a rownum() implementation from depesz [1] that works nice
for reports.
[1]
http://www.depesz.com/index.php/2007/08/17/rownum-anyone-cumulative-sum-in-one-query/
--
André Volpato
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
