On Mon, Jul 7, 2008 at 4:54 AM, Jack Brown <[EMAIL PROTECTED]> wrote:
> Thank you, i didn't know the term so when I'd searched the archives, i hadn't > found much. Here is the result of a discussion that came up a couple of years ago: http://www.varlena.com/GeneralBits/130.php I guess that german account laws require a gapless sequence for all documents. > 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. -- Regards, Richard Broersma Jr. Visit the Los Angles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
