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

Re: counting rows of grouped query (problem with views)

From: Nabil Sayegh <evolution(at)sayegh(dot)de>
To: Nabil Sayegh <nsmail(at)sayegh(dot)de>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: counting rows of grouped query (problem with views)
Date: 2001-03-12 18:18:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On 09 Mar 2001 19:08:12 +0100, Nabil Sayegh wrote:
> Hi all,
> (short)
> is there any possibility to count the number of rows resulting from a
> grouped query (from a view containing a grouped query) ?


> I dont want the aggregate function to be used on each group, I want it
> to count all the rows.
> IMHO the view should act as a table (and therefor should UNGROUP the
> result)

Nobody ? Come on.
Am I the only one who finds this behaviour of VIEWs strange ?


 Nabil Sayegh
 GPG-Key available at 
 (see for details)

In response to

pgsql-novice by date

Next:From: Mark, TerryDate: 2001-03-12 20:46:28
Subject: pg_dump & BLOBs ?
Previous:From: Dax DuskinDate: 2001-03-12 17:06:30
Subject: array column problem

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