Hi,
I am reading code about cursor and fetch ...
Here is a test:
create table t (a int);
insert into t values (1),(3),(5),(7),(9);
insert into t select a+1 from t;
begin;
declare c cursor for select * from t order by a;
fetch 3 in c;
fetch 3 in c;
fetch 3 in c;
In func "PortalRun", FillPortalStore(portal, isTopLevel) will create a
tuplestore for each query...
Why create tuplestore for each fetch?
--
GaoZengqi
pgf00a(at)gmail(dot)com
zengqigao(at)gmail(dot)com