Postgres Pro
Downloads
Home   >   mailing lists

Thread: Multiple statements in one prepare

Multiple statements in one prepare

From
"Robert Turnbull"
Date:
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.  

Re: Multiple statements in one prepare

From
Tom Lane
Date:
"Robert Turnbull" <rturnbull@strategicmind.com> writes:
> How can multiple SQL statements be included in one prepare command?

They can't.  Consider using a plpgsql function, instead.
        regards, tom lane

Re: Multiple statements in one prepare

From
Neil Conway
Date:
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 semi-colons), so the difference in FE/BE traffic should be
negligible.

-Neil