Re: get row count from a "cursor resultset"

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Maik Wiege <mswiege(at)gmx(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: get row count from a "cursor resultset"
Date: 2005-07-06 23:35:59
Message-ID: 42CC6ADF.5040504@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Maik Wiege 2005-07-07 08:27:55 Re: get row count from a "cursor resultset"
Previous Message Maik Wiege 2005-07-06 23:33:46 Re: get row count from a "cursor resultset"