diff options
| author | Bruce Momjian <bruce@momjian.us> | 2018-08-09 10:13:15 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2018-08-09 10:13:15 -0400 |
| commit | 0d428b6553bcedf8faf51ed9947c3a59238f8da8 (patch) | |
| tree | 0e1ec95dd5b33e96b12d3267d99902addecddff2 | |
| parent | 8e4e783ee4f1cb64a46798989e5fd04c7c0a2f53 (diff) | |
| download | postgresql-0d428b6553bcedf8faf51ed9947c3a59238f8da8.tar.gz postgresql-0d428b6553bcedf8faf51ed9947c3a59238f8da8.zip | |
docs: Only first instance of a PREPARE parameter sets data type
If the first reference to $1 is "($1 = col) or ($1 is null)", the data
type can be determined, but not for "($1 is null) or ($1 = col)". This
change documents this.
Reported-by: Morgan Owens
Discussion: https://postgr.es/m/153233728858.1404.15268121695358514937@wrigleys.postgresql.org
Backpatch-through: 9.3
| -rw-r--r-- | doc/src/sgml/ref/prepare.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/prepare.sgml b/doc/src/sgml/ref/prepare.sgml index 8efd51aaec9..8dd5aa00fad 100644 --- a/doc/src/sgml/ref/prepare.sgml +++ b/doc/src/sgml/ref/prepare.sgml @@ -52,7 +52,7 @@ PREPARE <replaceable class="PARAMETER">name</replaceable> [ ( <replaceable class parameter data types can optionally be specified. When a parameter's data type is not specified or is declared as <literal>unknown</literal>, the type is inferred from the context - in which the parameter is used (if possible). When executing the + in which the parameter is first used (if possible). When executing the statement, specify the actual values for these parameters in the <command>EXECUTE</command> statement. Refer to <xref linkend="sql-execute"> for more @@ -104,7 +104,7 @@ PREPARE <replaceable class="PARAMETER">name</replaceable> [ ( <replaceable class The data type of a parameter to the prepared statement. If the data type of a particular parameter is unspecified or is specified as <literal>unknown</literal>, it will be inferred - from the context in which the parameter is used. To refer to the + from the context in which the parameter is first used. To refer to the parameters in the prepared statement itself, use <literal>$1</literal>, <literal>$2</literal>, etc. </para> |