Received: from comptechnews.com (root@cc993546-b.srst1.fl.home.com [24.3.77.52]) by hub.org (8.10.1/8.10.1) with ESMTP id e6GM93023362 for ; Sun, 16 Jul 2000 18:09:03 -0400 (EDT) Received: from comptechnews (reaster@localhost [127.0.0.1]) by comptechnews.com (8.9.3/8.9.3) with SMTP id SAA08718 for ; Sun, 16 Jul 2000 18:10:57 -0400 From: "Robert B. Easter" To: pgsql-sql@postgresql.org Subject: How to get count of rows in cursor Date: Sun, 16 Jul 2000 18:02:51 -0400 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <00071618105700.02819@comptechnews> Content-Transfer-Encoding: 8bit X-Archive-Number: 200007/160 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