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(at)svana(dot)org> http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2003-02-24 23:49:37|
|Subject: Intel drops 64-bit Itanium|
|Previous:||From: Hannu Krosing||Date: 2003-02-24 22:20:37|
|Subject: Re: ILIKE|
pgsql-general by date
|Next:||From: Medi Montaseri||Date: 2003-02-24 23:28:30|
|Subject: Re: 7.4?|
|Previous:||From: Carlos Moreno||Date: 2003-02-24 22:31:10|
|Subject: Re: Strange error (Socket command option unknown)|