Libpq enhancement
От | Jeff Shanab |
---|---|
Тема | Libpq enhancement |
Дата | |
Msg-id | 615FD77639372542BF647F5EBAA2DBC20B11C251@IL-BOL-EXCH01.smartwire.com обсуждение исходный текст |
Ответы |
Re: Libpq enhancement
Re: Libpq enhancement Re: Libpq enhancement |
Список | pgsql-hackers |
<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>
В списке pgsql-hackers по дате отправления: