Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group