Postgres Pro
Downloads
Home   >   mailing lists

Re: get row count from a "cursor resultset" - Mailing list pgsql-jdbc

From Maik Wiege
Subject Re: get row count from a "cursor resultset"
Date
Msg-id 42CD1202.8030705@gmx.de
Whole thread Raw
In response to get row count from a "cursor resultset"  (Maik Wiege <mswiege@gmx.de>)
Responses Re: get row count from a "cursor resultset"  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Tree view 
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?

pgsql-jdbc by date:

Previous
From: Maik Wiege
Date:
Subject: Re: get row count from a "cursor resultset"
Next
From: Dave Cramer
Date:
Subject: Re: get row count from a "cursor resultset"