Commit8a395e0

committed

doc: add link for list-of-scalars mention

Reported-by: Manlio PerilloBug: 14016Discussion: 20160311163928.6674.94707@wrigleys.postgresql.orgReviewed-by: David G. Johnston

1 parent46eafc8 commit8a395e0Copy full SHA for 8a395e0

File tree

-2

lines changed

-2

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -14609,7 +14609,7 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2);`
`14609`	`14609`	`Boolean (true/false) results.`
`14610`	`14610`	`</para>`
`14611`	`14611`
`14612`		`- <sect2>`
	`14612`	`+ <sect2 id="functions-comparisons-in-scalar">`
`14613`	`14613`	`<title><literal>IN</literal></title>`
`14614`	`14614`
`14615`	`14615`	`<synopsis>`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -219,7 +219,8 @@ WHERE ip_address IN (VALUES('192.168.0.1'::inet), ('192.168.0.10'), ('192.168.1.`
`219`	`219`	`<tip>`
`220`	`220`	`<para>`
`221`	`221`	`For simple <literal>IN</> tests, it's better to rely on the`
`222`		`- list-of-scalars form of <literal>IN</> than to write a <command>VALUES</>`
	`222`	`+ <link linkend="functions-comparisons-in-scalar">list-of-scalars</link>`
	`223`	`+ form of <literal>IN</> than to write a <command>VALUES</>`
`223`	`224`	`query as shown above. The list of scalars method requires less writing`
`224`	`225`	`and is often more efficient.`
`225`	`226`	`</para>`

Comments

(0)