How to get count of rows in cursor

From: "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to get count of rows in cursor
Date: 2000-07-16 22:02:51
Message-ID: 00071618105700.02819@comptechnews
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Browse pgsql-sql by date

  From Date Subject
Next Message Carolyn Lu Wong 2000-07-17 02:07:25 SQL question
Previous Message Peter Eisentraut 2000-07-16 14:45:54 Re: Select by priority