I am wondering If I am missing something obvious. If not, I have a suggestion for plpgsql.
Stored procedures can accept rows.
Libpq can receive rows (PQResult).
Wouldn’t it be a great interface if PQResult was “bi-directional”? Create a result set on the client then call the database with a command.
Perhaps…
PQinsert(PQResult,”schema.table”); //iterate thru rows inserting
PQupdate(PQResult,”schema.table”); //iterate thru rows updateing
PQexec(connection,”scheme.function”,PQResult) //iterate thru rows passing row as arg to stored procedure.
