Thread: Error using cursors/fetch and execute

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(txt) values('hoho1');
mag=# prepare berra (integer) as select * from test where id = $1;
mag=# declare berra_c cursor for execute berra(1);
ERROR:  parser: parse error at or near "execute" at character 28

Is there any other way of fetching less than all rows at once, similar
to that of using cursors. I don't use it for any other purpose than
that.

Magnus

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Programmer/Networker [|] Magnus Naeslund
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

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 berra(1);
> ERROR:  parser: parse error at or near "execute" at character 28
> 
> Is there any other way of fetching less than all rows at once, similar
> to that of using cursors. I don't use it for any other purpose than
> that.

Just

begin;
declare berra cursor for select * from test where id = 1;
fetch 100 from berra;
[...]
end;


Jeroen