Re: number of rows returned by a query

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