Hi!
Thanks!
How do I create "cursor" or "for select" in PGSQL with dynamic way?
For example
:tbl = GenTempTableName()
insert into :tbl...
for select :part_id from :tbl begin
exec 'select count(*) from subitems where id = ?' using :part_id into :sumof
update :tbl set sumof = :sumof where part_id=:part_id
end;
Can you show me same example?
Thanks: