From: | "Magnus Naeslund(f)" <mag(at)fbab(dot)net> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Error using cursors/fetch and execute |
Date: | 2003-01-07 13:29:30 |
Message-ID: | 044701c2b650$cef55a20$f80c0a0a@mnd |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Michel POURE | 2003-01-07 13:38:39 | UTF-8 encoding question regarding PhpPgAdmin development |
Previous Message | Jean-Michel POURE | 2003-01-07 13:15:16 | UTF-8 psql support |