Re: counting rows of grouped query (problem with views) - Mailing 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)
>
> P.S.: I use 7.0.3


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)