diff options
| author | Bruce Momjian <bruce@momjian.us> | 2016-06-28 16:16:06 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2016-06-28 16:16:06 -0400 |
| commit | 8a395e0b9a2118453df3d9c31ddb43f811315ddd (patch) | |
| tree | 7a48f5e238d48d5a1b7232ed32dc1d7ab695152b /doc/src | |
| parent | 46eafc8855d7c21e2c1a45faa77a3d5a2fc2c8b2 (diff) | |
doc: add link for list-of-scalars mention
Reported-by: Manlio Perillo
Bug: 14016
Discussion: 20160311163928.6674.94707@wrigleys.postgresql.org
Reviewed-by: David G. Johnston
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 2 | ||||
| -rw-r--r-- | doc/src/sgml/ref/values.sgml | 3 |
2 files changed, 3 insertions, 2 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 052b8f5ba05..baef80db5bd 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -14609,7 +14609,7 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2); Boolean (true/false) results. </para> - <sect2> + <sect2 id="functions-comparisons-in-scalar"> <title><literal>IN</literal></title> <synopsis> diff --git a/doc/src/sgml/ref/values.sgml b/doc/src/sgml/ref/values.sgml index 0fb3cd7bc2d..9b0d8fa4a16 100644 --- a/doc/src/sgml/ref/values.sgml +++ b/doc/src/sgml/ref/values.sgml @@ -219,7 +219,8 @@ WHERE ip_address IN (VALUES('192.168.0.1'::inet), ('192.168.0.10'), ('192.168.1. <tip> <para> For simple <literal>IN</> tests, it's better to rely on the - list-of-scalars form of <literal>IN</> than to write a <command>VALUES</> + <link linkend="functions-comparisons-in-scalar">list-of-scalars</link> + form of <literal>IN</> than to write a <command>VALUES</> query as shown above. The list of scalars method requires less writing and is often more efficient. </para> |