FAQ
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.

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 6 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedJun 19, '11 at 3:11p
activeJul 5, '11 at 2:09p
posts6
users5
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase