Re: counting rows of grouped query (problem with views) - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: counting rows of grouped query (problem with views)
Date
Msg-id 20010312180642.0EE7214EE67@gerstung3.net-lab.net
Whole thread Raw
In response to counting rows of grouped query (problem with views)  (Nabil Sayegh <nsmail@sayegh.de>)
List 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 ?

TIA
cu

--
 Nabil Sayegh
 GPG-Key available at http://www.sayegh.de
 (see http://www.gnupg.org for details)


pgsql-novice by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: Fwd: Silly question about numbering of rows?
Next
From: "Dax Duskin"
Date:
Subject: perl installation problem