It worked like a charm! Bol'shoe spasibo!
I'm curious what are the Postgres versions that support MOVE ALL. The documentation does not even mention "ALL" option.
Konstantin
On Thu, Dec 2, 2010 at 3:49 AM, Dmitriy Igrishin <dmitigr@xxxxxxxxx> wrote:
Hey Konstantin,
Use MOVE ALL, then PQcmdTuples to get number of rows,
then MOVE BACKWARD ALL to point cursor at initial position.2010/12/2 Konstantin Izmailov <pgfizm@xxxxxxxxx>
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
--
// Dmitriy.
