getting result information of DECLARE CURSOR statement - Mailing list pgsql-general

From Yusron Hilmy
Subject getting result information of DECLARE CURSOR statement
Date
Msg-id 022501c12079$6a1aafb0$3c0aa8c0@yusron
Whole thread Raw
List pgsql-general
Hi,

I am a new member of this list. I have some problem with postgres CURSOR
(related to libpq).
I have created a CURSOR with :
    PQexec(conn, "DECLARE mycursor CURSOR FOR SELECT * from test");

How I can get how many tuples the result are without I have to fetch all its
result (I use FETCH NEXT instead of FETCH ALL) ?

Thank you for your help

Yusron




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: createdb confusion
Next
From: Tom Lane
Date:
Subject: Re: Re: First Saturday and Last Saturday of a month