Re: [GENERAL] number of rows returned by a query

2010-12-02 Thread Guillaume Lelarge
Le 03/12/2010 07:34, Konstantin Izmailov a écrit : > 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. > Actually, it does: http://www.postgresql.org/docs/9.0/inter

Re: [GENERAL] number of rows returned by a query

2010-12-02 Thread Konstantin Izmailov
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 wrote: > Hey Konstantin, > > Use MOVE ALL, then PQcmdTuples to

Re: [GENERAL] number of rows returned by a query

2010-12-02 Thread Dmitriy Igrishin
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 > Maybe this question was discussed previously, but I could not find an > answer: > > An application used PQntuples function to obtain

[GENERAL] number of rows returned by a query

2010-12-01 Thread Konstantin Izmailov
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 numb