Libpq enhancement - Mailing list pgsql-hackers

From Jeff Shanab
Subject Libpq enhancement
Date
Msg-id 615FD77639372542BF647F5EBAA2DBC20B11C251@IL-BOL-EXCH01.smartwire.com
Whole thread Raw
Responses Re: Libpq enhancement
Re: Libpq enhancement
Re: Libpq enhancement
List 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 by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: SSI tuning points
Next
From: Cédric Villemain
Date:
Subject: Re: the big picture for index-only scans