Re: number of rows returned by a query

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(at)gmail(dot)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.