	I need two answers I did not find in documentation :

How can I get exact number of rows in DECLARED CURSOR ?
OK, I can FETCH until NULL, but this does not fits my needs !

How can I get information is TRANSACTION already started ?
(TRANSACTION LEVEL)

The interface I'm using is libpq. 

	Regards !

Mon, 24 Feb 2003 19:53:05 +0000
Darko Prenosil <darko.prenosil@finteh.hr>
I cant find it or I'm just lazy ?
On Mon, Feb 24, 2003 at 07:53:05PM +0000, Darko Prenosil wrote:
> 	I need two answers I did not find in documentation :
> 
> How can I get exact number of rows in DECLARED CURSOR ?
> OK, I can FETCH until NULL, but this does not fits my needs !

You need to move to the end of the cursor. When you declare a cursor it
doesn't run the query yet. You have to tell it to run the query before it
can tell you how many rows it is. I think the command is MOVE.

-- 
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.
Tue, 25 Feb 2003 10:24:59 +1100
Martijn van Oosterhout <kleptog@svana.org>
Re: I cant find it or I'm just lazy ?