Re: get row count from a "cursor resultset"

Maik,

Your only choice may be to do two separate queries. This isn't quite
as bad as you think, as the count will load the buffers with your query
If you need exactly the right amount, make sure you do this in a
transaction.

Dave
On 7-Jul-05, at 7:29 AM, Maik Wiege wrote:

> Oliver Jowett schrieb:
>
>> Try COUNT(distinct REGISTER.pd.pdkz) perhaps
>>
> Hi!
> SELECT COUNT(DISTINCT REGISTER.pd.pdkz)
> FROM REGISTER.pd JOIN
> REGISTER.vornamen ON REGISTER.vornamen.pdkz = REGISTER.pd.pdkz
>
> works, but with that of cource I don't get the data, just the
> amount of rows, so I would have to call it another time without
> COUNT to get the data.
>
> A query like that
> SELECT COUNT(DISTINCT REGISTER.pd.pdkz), DISTINCT REGISTER.pd.pdkz
> FROM REGISTER.pd JOIN
> REGISTER.vornamen ON REGISTER.vornamen.pdkz = REGISTER.pd.pdkz
> gives the same mentioned error: column "pd.pdkz" must appear in the
> GROUP BY clause or be used in an aggregate function
>
> Any ideas anyone?
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>