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

From: Nabil Sayegh <nsmail(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 22:43:32
Message-ID: 20010312223522.0B46B3EDA@plserver.of.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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)
>
> 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)

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-03-12 23:45:52 Re: counting rows of grouped query (problem with views)
Previous Message brew 2001-03-12 22:04:44 pg_dump & BLOBs ?