Skip site navigation (1) Skip section navigation (2)

Re: I cant find it or I'm just lazy ?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr>
Cc: hackers <pgsql-hackers(at)postgresql(dot)org>,pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: I cant find it or I'm just lazy ?
Date: 2003-02-24 23:24:59
Message-ID: 20030224232458.GA23996@svana.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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 MomjianDate: 2003-02-24 23:49:37
Subject: Intel drops 64-bit Itanium
Previous:From: Hannu KrosingDate: 2003-02-24 22:20:37
Subject: Re: ILIKE

pgsql-general by date

Next:From: Medi MontaseriDate: 2003-02-24 23:28:30
Subject: Re: 7.4?
Previous:From: Carlos MorenoDate: 2003-02-24 22:31:10
Subject: Re: Strange error (Socket command option unknown)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group