Fw: Error using cursors/fetch and execute
Started by Magnus Naeslund(f)about 23 years ago1 messages
I forgot to reply to the list aswell...
Magnus
----- Original Message -----
From: "Magnus Naeslund(f)" <mag@fbab.net>
To: "Jeroen T. Vermeulen" <jtv@xs4all.nl>
Sent: Tuesday, January 07, 2003 3:32 PM
Subject: Re: [HACKERS] Error using cursors/fetch and execute
Show quoted text
Jeroen T. Vermeulen <jtv@xs4all.nl> wrote:
begin;
declare berra cursor for select * from test where id = 1;
fetch 100 from berra;
[...]
end;Oh, i'm sorry, i'm unclear.
I mean: "is there a way of doing exactly the above using prepared
statements?".
We're doing the above currently, and that works ofcourse...Jeroen
Magnus