Libpq enhancement
От
Jeff Shanab
Тема
Libpq enhancement
Дата
Msg-id
615FD77639372542BF647F5EBAA2DBC20B11C251@IL-BOL-EXCH01.smartwire.com
Список
Дерево обсуждения
Libpq enhancement Jeff Shanab <jshanab@smartwire.com>
Re: Libpq enhancement Andrew Chernow <ac@esilo.com>
Re: Libpq enhancement Robert Haas <robertmhaas@gmail.com>
Re: Libpq enhancement Merlin Moncure <mmoncure@gmail.com>
Re: Libpq enhancement Robert Haas <robertmhaas@gmail.com>
Re: Libpq enhancement Dmitriy Igrishin <dmitigr@gmail.com>
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.
В списке pgsql-hackers по дате отправления
