From: | "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com> |
---|---|
To: | zidibik(at)yahoo(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: creating "a perfect sequence" column |
Date: | 2008-07-07 12:23:49 |
Message-ID: | 396486430807070523q1f83d78fy712095d4eda35b2d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Jul 7, 2008 at 4:54 AM, Jack Brown <zidibik(at)yahoo(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | André Volpato | 2008-07-07 12:43:13 | Re: creating "a perfect sequence" column |
Previous Message | Jack Brown | 2008-07-07 11:54:45 | Re: creating "a perfect sequence" column |