Search Postgresql Archives

Re: number of rows returned by a query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx>
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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux