Hi! Thanks!
How do I create "cursor" or "for select" in PGSQL with dynamic way? For example :tbl = GenTempTableName() insert into :tbl... insert into :tbl... 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: dd 2011/3/7 Adrian Klaver <adrian.kla...@gmail.com> > On Monday, March 07, 2011 6:32:44 am Durumdara wrote: > > Hi! > > > > In other RDBMS I found a way to make dynamic statements. > > I can use variables, or concat the SQL segments, and execute it all. > > > > :tablename = call CreateTempTable; > > > > insert into :tablename .... > > drop table :tablename > > > > or (FireBird like cursor handling): > > > > sql = "select * from " || :tablename || " where..." > > for select :sql .... > > ... > > > > Can I do same thing in PGSQL too? > > > > Thanks: > > dd > > > http://www.postgresql.org/docs/9.0/interactive/plpgsql-statements.html#PLPGSQL- > STATEMENTS-EXECUTING-DYN > -- > Adrian Klaver > adrian.kla...@gmail.com >