Yes here the TABLE NAME is also coming at runtime.
Like In Oracle I have done in this way:
-------------------------------------------
LOOP
v_sql := 'INSERT INTO ' || mytable || ' VALUES(:in_sentryid_id,
:in_node_id)';
EXECUTE IMMEDIATE v_sql USING v_sentryid, v_nodeid;
END LOOP;
How to convert this into Postgres?????
Thanks
Dinesh Pandey
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
