Commitf30d39e

Neil Conway

committed

Add usage examples for PREPARE and EXECUTE. Original patch from Gavin

Sherry, editorializing by Neil Conway.

1 parent146aab4 commitf30d39eCopy full SHA for f30d39e

File tree

+34

-2

lines changed

+34

-2

lines changed

Lines changed: 10 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/ref/execute.sgml,v 1.7 2003/11/29 19:51:38 pgsql Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/ref/execute.sgml,v 1.8 2004/01/26 17:26:30 neilc Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -78,6 +78,15 @@ EXECUTE <replaceable class="PARAMETER">plan_name</replaceable> [ (<replaceable c`
`78`	`78`	`</variablelist>`
`79`	`79`	`</refsect1>`
`80`	`80`
	`81`	`+ <refsect1>`
	`82`	`+ <title>Examples</>`
	`83`	`+ <para>`
	`84`	`+ Examples are given in the <xref linkend="sql-prepare-examples"`
	`85`	`+ endterm="sql-prepare-examples-title"> section of the <xref`
	`86`	`+ linkend="sql-prepare" endterm="sql-prepare-title"> documentation.`
	`87`	`+ </para>`
	`88`	`+ </refsect1>`
	`89`	`+`
`81`	`90`	`<refsect1>`
`82`	`91`	`<title>Compatibility</title>`
`83`	`92`

Lines changed: 24 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$PostgreSQL: pgsql/doc/src/sgml/ref/prepare.sgml,v 1.10 2003/12/14 00:55:46 neilc Exp $`
	`2`	`+$PostgreSQL: pgsql/doc/src/sgml/ref/prepare.sgml,v 1.11 2004/01/26 17:26:31 neilc Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -139,6 +139,29 @@ PREPARE <replaceable class="PARAMETER">plan_name</replaceable> [ (<replaceable c`
`139`	`139`	`</para>`
`140`	`140`	`</refsect1>`
`141`	`141`
	`142`	`+ <refsect1 id="sql-prepare-examples">`
	`143`	`+ <title id="sql-prepare-examples-title">Examples</title>`
	`144`	`+ <para>`
	`145`	`+ Create a prepared query for an <command>INSERT</command> statement,`
	`146`	`+ and then execute it:`
	`147`	`+<programlisting>`
	`148`	`+PREPARE fooplan (int, text, bool, numeric(8,2)) AS`
	`149`	`+ INSERT INTO foo VALUES($1, '$2', '$3', '$4');`
	`150`	`+EXECUTE fooplan(1, 'Hunter Valley', 't', '200.00');`
	`151`	`+</programlisting>`
	`152`	`+ </para>`
	`153`	`+`
	`154`	`+ <para>`
	`155`	`+ Create a prepared query for a <command>SELECT</command> statement,`
	`156`	`+ and then execute it:`
	`157`	`+<programlisting>`
	`158`	`+PREPARE usrrptplan (int, date) AS`
	`159`	`+ SELECT * FROM users u, logs l WHERE u.usrid=$1 AND u.usrid=l.usrid`
	`160`	`+ AND l.date = $2;`
	`161`	`+EXECUTE usrrptplan(1, current_date);`
	`162`	`+</programlisting>`
	`163`	`+ </para>`
	`164`	`+ </refsect1>`
`142`	`165`	`<refsect1>`
`143`	`166`	`<title>Compatibility</title>`
`144`	`167`

Comments

(0)