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.
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) |
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 |