Re: Libpq enhancement

On Sun, Jun 19, 2011 at 11:04 AM, Jeff Shanab <jshanab@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