Hello, There is also a funny approach here with custom operators and variables that could be adapted to build a rownum functioanlity in functions (look for Vladimir)
http://archives.postgresql.org/pgsql-hackers/2008-11/msg00048.php not very clean, but apparently fast .... Marc Mamin -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Guy Rouillier Sent: Friday, March 27, 2009 2:54 AM To: [email protected] Subject: Re: [GENERAL] Enumerating a row set On Thu, Mar 26, 2009 at 06:42:45PM -0400, George Sakkis wrote: > Hi all, > > Is there a function similiar to Python's enumerate() [1] ? Searching > the docs didn't reveal any relevant builtin but I hope it's doable in > pgsql. I found this via Google: http://www.depesz.com/index.php/2007/08/17/rownum-anyone-cumulative-sum- in-one-query/ -- Guy Rouillier -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
