Re: creating "a perfect sequence" column

On Mon, Jul 7, 2008 at 4:54 AM, Jack Brown <zidibik@yahoo.com> 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