Postgres Pro
Downloads
Home   >   mailing lists

Re: Enumerating a row set - Mailing list pgsql-general

From Guy Rouillier
Subject Re: Enumerating a row set
Date
Msg-id 49CC31D3.70906@burntmail.com
Whole thread Raw
In response to Re: Enumerating a row set  (David Fetter <david@fetter.org>)
Responses Re: Enumerating a row set  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Enumerating a row set
Next
From: Johan Nel
Date:
Subject: Re: Best way to store a threaded message list/tree in SQL