Postgres Pro
Downloads
Home   >   mailing lists

How to get count of rows in cursor - Mailing list pgsql-sql

From Robert B. Easter
Subject How to get count of rows in cursor
Date
Msg-id 00071618105700.02819@comptechnews
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Select by priority
Next
From: Carolyn Lu Wong
Date:
Subject: SQL question