Re: length of recordset read through a cursor

Поиск
Список
Период
Сортировка
От Christoph Haller
Тема Re: length of recordset read through a cursor
Дата
Msg-id 3F2A4E0C.AB433D8@rodos.fzk.de
обсуждение исходный текст
Ответ на length of recordset read through a cursor  ("Knut P. Lehre" <k.p.lehre@tiscali.no>)
Список pgsql-sql
>
> After declaring a cursor, one way of obtaining the length of the
resultset
> is to perform a "MOVE 0" and read the PQcmdStatus which returns a
"MOVE nn"
> where nn is the length of the resultset. (A negative MOVE can then be
used
> to allow starting to fetch records from the beginning of the
resultset.)
>
> Is there another, possibly faster way?
>
Looks like you're using libpq (because you mention PQcmdStatus),
then after declaring a cursor and FETCH ALL, try

1.3.4. Retrieving SELECT Result Information
   PQntuples Returns the number of tuples (rows) in the query result.
   int PQntuples(const PGresult *res);

I'm not exactly sure what you're trying to achieve or going to do,
so if I misunderstood you, ask again.

Regards, Christoph




В списке pgsql-sql по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: Does a the block of code within a stored procedure constitute a transaction?
Следующее
От: Mike Rylander
Дата:
Сообщение: Re: converting interval to timestamp