From 8a395e0b9a2118453df3d9c31ddb43f811315ddd Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 28 Jun 2016 16:16:06 -0400 Subject: [PATCH] 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 --- doc/src/sgml/func.sgml | 2 +- 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 052b8f5ba0..baef80db5b 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. - + <literal>IN</literal> diff --git a/doc/src/sgml/ref/values.sgml b/doc/src/sgml/ref/values.sgml index 0fb3cd7bc2..9b0d8fa4a1 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. For simple IN tests, it's better to rely on the - list-of-scalars form of IN than to write a VALUES + list-of-scalars + form of IN than to write a VALUES query as shown above. The list of scalars method requires less writing and is often more efficient. -- 2.40.0