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 <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Support bacteria! They're the only culture some people have.
pgp00000.pgp
Description: PGP signature