Postgres Pro
Downloads
Home   >   mailing lists

Re: Add a ROWCOUNT to the output of a select. - Mailing list pgsql-sql

From Marcin Stępnicki
Subject Re: Add a ROWCOUNT to the output of a select.
Date
Msg-id 179149fe0805140134g5d2a4898ib8f87a9539d1b930@mail.gmail.com
Whole thread Raw
In response to Add a ROWCOUNT to the output of a select.  (Gavin 'Beau' Baumanis <gavinb@eclinic.com.au>)
List pgsql-sql
Tree view 
On Wed, May 14, 2008 at 1:54 AM, Gavin 'Beau' Baumanis
<gavinb@eclinic.com.au> wrote:
> Hi Everyone,
>
> After spending some time searching through our good friend Mr. Google and
> the mailing list I found a post that provided me with a query that does just
> what I need.

I think that this should be helpful:

http://www.depesz.com/index.php/2007/08/17/rownum-anyone-cumulative-sum-in-one-query/

pgsql-sql by date:

Previous
From: "Robins Tharakan"
Date:
Subject: Re: Add a ROWCOUNT to the output of a select.
Next
From: Harald Fuchs
Date:
Subject: Re: Add a ROWCOUNT to the output of a select.