Rows count in the cursor ?

From: "Ivanmara" <aesthete2005(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Rows count in the cursor ?
Date: 2008-12-17 03:55:43
Message-ID: gi9t7r$11d7$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello. how can i get count of the rows in cursor ?

this code always return 0, but table is not empty:

open curs for select * from classif order by id;
GET DIAGNOSTICS i = ROW_COUNT;

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2008-12-17 04:02:37 Re: Maximum reasonable free space map
Previous Message Grzegorz Jaśkiewicz 2008-12-17 02:52:44 Re: Maximum reasonable free space map