Re: [HACKERS] Prepared select

There are several production issues related to the proposed solution. For example, what happens when the result set exceeds the swap space of the server or client machine? My original question is how to get a cursor from a prepared select so a subset of the result can be returned to the client for

[HACKERS] Multiple statements in one prepare

How canmultiple SQL statements be included in one prepare command? The goal is toreduce chatter between the client and serverby submitting an atomictranasaction set.My interface is libpq.

[HACKERS] Preparing select statements

How can I execute a prepared queryusing the libpq interface? The SQL Prepare documentation talks aboutselect statements, but where is thedocumentation on SQL OPEN or some functionally equivalent libpq API?That is to say howis a cursor generated from a plan? Thanks

[HACKERS] Prepared select

How can I use a prepared select statement asmentioned in the documentation on SQL PREPARE.Preparing the statement is easy, the problem is using the plan to get a cursor.My assumption is the SQL OPEN command is not documented or there is some otherlibpq API to make this happen. Thanks