Обсуждение: How to get count of rows in cursor

Поиск
Список
Период
Сортировка

How to get count of rows in cursor

От
"Robert B. Easter"
Дата:
Is there some fast way to get the count of rows in a cursor?

FETCH count(*) FROM mycursor; -- expresses what I want

I know I could always just do a SELECT count(*) in a separate query, but I'm
asking in case a cursor has this information already and I just don't know how
to get it.

--         - Robert