Commit0d428b6

committed

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 datatype can be determined, but not for "($1 is null) or ($1 = col)". Thischange documents this.Reported-by: Morgan OwensDiscussion:https://postgr.es/m/153233728858.1404.15268121695358514937@wrigleys.postgresql.orgBackpatch-through: 9.3

1 parent8e4e783 commit0d428b6Copy full SHA for 0d428b6

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -52,7 +52,7 @@ PREPARE <replaceable class="PARAMETER">name</replaceable> [ ( <replaceable class`
`52`	`52`	`parameter data types can optionally be specified. When a`
`53`	`53`	`parameter's data type is not specified or is declared as`
`54`	`54`	`<literal>unknown</literal>, the type is inferred from the context`
`55`		`- in which the parameter is used (if possible). When executing the`
	`55`	`+ in which the parameter isfirstused (if possible). When executing the`
`56`	`56`	`statement, specify the actual values for these parameters in the`
`57`	`57`	`<command>EXECUTE</command> statement. Refer to <xref`
`58`	`58`	`linkend="sql-execute"> for more`
`@@ -104,7 +104,7 @@ PREPARE <replaceable class="PARAMETER">name</replaceable> [ ( <replaceable class`
`104`	`104`	`The data type of a parameter to the prepared statement. If the`
`105`	`105`	`data type of a particular parameter is unspecified or is`
`106`	`106`	`specified as <literal>unknown</literal>, it will be inferred`
`107`		`- from the context in which the parameter is used. To refer to the`
	`107`	`+ from the context in which the parameter isfirstused. To refer to the`
`108`	`108`	`parameters in the prepared statement itself, use`
`109`	`109`	`<literal>$1</literal>, <literal>$2</literal>, etc.`
`110`	`110`	`</para>`

Comments

(0)