diff options
| author | Bruce Momjian <bruce@momjian.us> | 2007-02-18 01:47:40 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2007-02-18 01:47:40 +0000 |
| commit | aa728d5f4b18e23eeb27f12acc9c44b441fc5986 (patch) | |
| tree | 297b4f6738c6dcf285eafb19b7b902dbf0335c9c | |
| parent | 9f6ed2f47fa3db011d16a3800bf416a72e76e683 (diff) | |
| download | postgresql-aa728d5f4b18e23eeb27f12acc9c44b441fc5986.tar.gz postgresql-aa728d5f4b18e23eeb27f12acc9c44b441fc5986.zip | |
Document limitation of SPI_execute() using multiple queries in a single
string.
| -rw-r--r-- | doc/src/sgml/spi.sgml | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/doc/src/sgml/spi.sgml b/doc/src/sgml/spi.sgml index 88461e71ba7..90a68a5d01b 100644 --- a/doc/src/sgml/spi.sgml +++ b/doc/src/sgml/spi.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/spi.sgml,v 1.52 2007/02/01 19:10:24 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/spi.sgml,v 1.53 2007/02/18 01:47:40 momjian Exp $ --> <chapter id="spi"> <title>Server Programming Interface</title> @@ -321,7 +321,8 @@ SPI_execute("INSERT INTO foo SELECT * FROM bar", false, 5); </para> <para> - You can pass multiple commands in one string. + You can pass multiple commands in one string, but later commands cannot + depend on the creation of objects earlier in the string. <function>SPI_execute</function> returns the result for the command executed last. The <parameter>count</parameter> limit applies to each command separately, but it is not applied to |