Thread: How to get count of rows in cursor

How to get count of rows in cursor

From
"Robert B. Easter"
Date:
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