From: | André Volpato <andre(dot)volpato(at)ecomtecnologia(dot)com(dot)br> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: creating "a perfect sequence" column |
Date: | 2008-07-07 12:43:13 |
Message-ID: | 48720F61.3090501@ecomtecnologia.com.br |
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:
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2008-07-07 12:50:50 | Re: Altering a column type w/o dropping views |
Previous Message | Richard Broersma | 2008-07-07 12:23:49 | Re: creating "a perfect sequence" column |