I forgot to reply to the list aswell...
Magnus
- Original Message -
From: "Magnus Naeslund(f)" <[EMAIL PROTECTED]>
To: "Jeroen T. Vermeulen" <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 3:32 PM
Subject: Re: [HACKERS] Error using cursors/fetch and
On Tue, Jan 07, 2003 at 02:29:30PM +0100, Magnus Naeslund(f) wrote:
>
> mag=# create table test (id serial unique primary key, txt text);
> mag=# insert into test(txt) values('hoho1');
> mag=# prepare berra (integer) as select * from test where id = $1;
> mag=# declare berra_c cursor for execute b
I have a problem...
We're using cursors to be able to fetch X tuples from the server.
If we would take 'em all our app would blow up because of memory
constraints.
What i would like to is something like this:
mag=# create table test (id serial unique primary key, txt text);
mag=# insert into test(
