Skip site navigation (1) Skip section navigation (2)

Re: Add a ROWCOUNT to the output of a select.

From: Marcin Stępnicki <mstepnicki(at)gmail(dot)com>
To: "Gavin 'Beau' Baumanis" <gavinb(at)eclinic(dot)com(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Add a ROWCOUNT to the output of a select.
Date: 2008-05-14 08:34:12
Message-ID: 179149fe0805140134g5d2a4898ib8f87a9539d1b930@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Wed, May 14, 2008 at 1:54 AM, Gavin 'Beau' Baumanis
<gavinb(at)eclinic(dot)com(dot)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/

In response to

pgsql-sql by date

Next:From: Harald FuchsDate: 2008-05-14 08:40:17
Subject: Re: Add a ROWCOUNT to the output of a select.
Previous:From: Robins TharakanDate: 2008-05-14 01:18:08
Subject: Re: Add a ROWCOUNT to the output of a select.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group