From: | "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl> |
---|---|
To: | "Magnus Naeslund(f)" <mag(at)fbab(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Error using cursors/fetch and execute |
Date: | 2003-01-07 14:21:39 |
Message-ID: | 20030107142139.GA78363@xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-01-07 14:55:53 | Re: Next platform query: Alphaservers under VMS? |
Previous Message | Jean-Michel POURE | 2003-01-07 13:38:39 | UTF-8 encoding question regarding PhpPgAdmin development |