On Sun, Jun 19, 2011 at 11:04 AM, Jeff Shanab <jsha...@smartwire.com> wrote: > 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.
For insert, we have something like this already - this is what "copy" is for. For update, it's a bit more complex - we don't have a "replace into" operator... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers