Postgres Pro
Downloads
Home   >   mailing lists

Re: Multiple statements in one prepare - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Multiple statements in one prepare
Date
Msg-id 22679.1082498597@sss.pgh.pa.us
Whole thread Raw
In response to Multiple statements in one prepare  ("Robert Turnbull" <rturnbull@strategicmind.com>)
List pgsql-hackers
Tree view 
"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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: pg_autovacuum crashes when query fails for temp tables
Next
From: Andrew Dunstan
Date:
Subject: Re: pg_encoding not needed anymore