Prepared query ? - Mailing list pgsql-sql

How can I

1. Write a prepared query and
2. Set values at run time and
3. Execute that query for different values.

LOOP

     …..

     …..

sql := INSERT INTO MYTABLE VALUES(?, ?);

……

--EXECUTE (sql);

END LOOP;

Regards
Dinesh Pandey


----------------------------------------------------------------------------------
Dinesh Pandey 
Sr. Software Engineer

Second Foundation (India) Pvt. Ltd.
Plot# 52
Industrial Area, Phase II
Chandigarh. (India)
PH: (O) 0172-2639202, Extn: 233