<div class="WordSection1"><p class="MsoNormal">I am wondering If I am missing something obvious. If not, I have a
suggestionfor plpgsql.<p class="MsoNormal"> <p class="MsoNormal">Stored procedures can accept rows.<p
class="MsoNormal">Libpqcan receive rows (PQResult).<p class="MsoNormal"> <p class="MsoNormal">Wouldn’t it be a great
interfaceif PQResult was “bi-directional”? Create a result set on the client then call the database with a command. <p
class="MsoNormal"> <pclass="MsoNormal">Perhaps…<p class="MsoNormal"> PQinsert(PQResult,”schema.table”); //iterate thru
rowsinserting<p class="MsoNormal"> PQupdate(PQResult,”schema.table”); //iterate thru rows updateing<p
class="MsoNormal"> <pclass="MsoNormal"> PQexec(connection,”scheme.function”,PQResult) //iterate thru rows passing row
asarg to stored procedure.<p class="MsoNormal"> </div>