Postgres Pro
Downloads
Home   >   mailing lists

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

From Oliver Jowett
Subject Re: get row count from a "cursor resultset"
Date
Msg-id 42CC6ADF.5040504@opencloud.com
Whole thread Raw
In response to Re: get row count from a "cursor resultset"  (Maik Wiege <mswiege@gmx.de>)
Responses Re: get row count from a "cursor resultset"  (Maik Wiege <mswiege@gmx.de>)
List pgsql-jdbc
Tree view 
Maik Wiege wrote:

> But what can I do about my problem? Isn't this a very
> common problem? Can't imagine any user querying a database and does not
> want to be informed how many results he got...

Well, as I suggested before, use DECLARE CURSOR / MOVE / FETCH, or
include a COUNT(*) column in your original query.

-O

pgsql-jdbc by date:

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