Re: [HACKERS] Multiple statements in one prepare

2004-04-24 Thread Neil Conway
On 15-Apr-04, at 9:26 AM, Robert Turnbull wrote: How can multiple SQL statements be included in one prepare command? The goal is to reduce chatter between the client and server by submitting an atomic tranasaction set. You can submit multiple PREPARE commands in one query string (separated by se

Re: [HACKERS] Multiple statements in one prepare

2004-04-20 Thread Tom Lane
"Robert Turnbull" <[EMAIL PROTECTED]> writes: > How can multiple SQL statements be included in one prepare command? They can't. Consider using a plpgsql function, instead. regards, tom lane ---(end of broadcast)--- TIP 6: H

[HACKERS] Multiple statements in one prepare

2004-04-20 Thread Robert Turnbull
How can multiple SQL statements be included in one prepare command? The goal is to reduce chatter between the client and server by submitting an atomic tranasaction set. My interface is libpq.