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)