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