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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-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

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-02-24 23:49:37 Intel drops 64-bit Itanium
Previous Message Hannu Krosing 2003-02-24 22:20:37 Re: ILIKE

Browse pgsql-general by date

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