number of rows returned by a query

From: Konstantin Izmailov <pgfizm(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: number of rows returned by a query
Date: 2010-12-02 06:15:07
Message-ID: AANLkTim-VAvZif4WELKVA2zc_JfxrP39ZdHzpj6gDq4L@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-12-02 06:44:33 Re: [JDBC] ResultSet problem in JDBC
Previous Message Konstantin Izmailov 2010-12-02 06:02:44 Re: Does Postgres support bookmarks (tuples ids)?