number of rows returned by a query - Mailing list pgsql-general

From Konstantin Izmailov
Subject number of rows returned by a query
Date
Msg-id AANLkTim-VAvZif4WELKVA2zc_JfxrP39ZdHzpj6gDq4L@mail.gmail.com
Whole thread Raw
Responses Re: number of rows returned by a query  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-general
Maybe this question was discussed previously, but I could not find an answer:

An application used PQntuples function to obtain number of tuples after executing each query. Since number of rows increased we decided to use DECLARE CURSOR/FETCH commands to retrieve tuples. However, it seems that number of the tuples is not available after DECLARE CURSOR command. We want to minimize the changes in the app. Is it possible to obtain number of rows that a cursor will return?

Thank you
Konstantin


pgsql-general by date:

Previous
From: Konstantin Izmailov
Date:
Subject: Re: Does Postgres support bookmarks (tuples ids)?
Next
From: Craig Ringer
Date:
Subject: Re: [JDBC] ResultSet problem in JDBC