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 <pgf...@gmail.com> > 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.