Re: number of rows returned by a query
| От | Dmitriy Igrishin |
|---|---|
| Тема | Re: number of rows returned by a query |
| Дата | |
| Msg-id | AANLkTim53H1s+Sf=O7wxuTE8FETgoj8xt=X_WJa5T5uN@mail.gmail.com обсуждение исходный текст |
| Ответ на | number of rows returned by a query (Konstantin Izmailov <pgfizm@gmail.com>) |
| Ответы |
Re: number of rows returned by a query
|
| Список | pgsql-general |
Hey Konstantin,
Use MOVE ALL, then PQcmdTuples to get number of rows,
then MOVE BACKWARD ALL to point cursor at initial position.
--
// Dmitriy.
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@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.
В списке pgsql-general по дате отправления: