postgres.git / summary / log / commit / refs
commit 23d29cef93ea8d060ceae42146154e45c5a4f862
Author: Bruce Momjian <bruce@momjian.us>
Date: Wed Oct 07 13:42:26 2015 +0000
docs: Map operator @> to the proper SGML escape for '>'
Backpatch through 9.5
doc/src/sgml/json.sgml | 20 ++++++++++----------
doc/src/sgml/rangetypes.sgml | 2 +-
2 files changed, 11 insertions(+), 11 deletions(-)
diff --git a/doc/src/sgml/json.sgml b/doc/src/sgml/json.sgml
index b4b390b23eb..47146b4c221 100644
--- a/doc/src/sgml/json.sgml
+++ b/doc/src/sgml/json.sgml
@@ -267,30 +267,30 @@ SELECT '{"reading": 1.230e-5}'::json, '{"reading": 1.230e-5}'::jsonb;
</para>
<programlisting>
-- Simple scalar/primitive values contain only the identical value:
-SELECT '"foo"'::jsonb @> '"foo"'::jsonb;
+SELECT '"foo"'::jsonb @> '"foo"'::jsonb;
-- The array on the right side is contained within the one on the left:
-SELECT '[1, 2, 3]'::jsonb @> '[1, 3]'::jsonb;
+SELECT '[1, 2, 3]'::jsonb @> '[1, 3]'::jsonb;
-- Order of array elements is not significant, so this is also true:
-SELECT '[1, 2, 3]'::jsonb @> '[3, 1]'::jsonb;
+SELECT '[1, 2, 3]'::jsonb @> '[3, 1]'::jsonb;
-- Duplicate array elements don't matter either:
-SELECT '[1, 2, 3]'::jsonb @> '[1, 2, 2]'::jsonb;
+SELECT '[1, 2, 3]'::jsonb @> '[1, 2, 2]'::jsonb;
-- The object with a single pair on the right side is contained
-- within the object on the left side:
-SELECT '{"product": "PostgreSQL", "version": 9.4, "jsonb":true}'::jsonb @> '{"version":9.4}'::jsonb;
+SELECT '{"product": "PostgreSQL", "version": 9.4, "jsonb":true}'::jsonb @> '{"version":9.4}'::jsonb;
-- The array on the right side is <emphasis>not</> considered contained within the
-- array on the left, even though a similar array is nested within it:
-SELECT '[1, 2, [1, 3]]'::jsonb @> '[1, 3]'::jsonb; -- yields false
+SELECT '[1, 2, [1, 3]]'::jsonb @> '[1, 3]'::jsonb; -- yields false
-- But with a layer of nesting, it is contained:
-SELECT '[1, 2, [1, 3]]'::jsonb @> '[[1, 3]]'::jsonb;
+SELECT '[1, 2, [1, 3]]'::jsonb @> '[[1, 3]]'::jsonb;
-- Similarly, containment is not reported here:
-SELECT '{"foo": {"bar": "baz"}}'::jsonb @> '{"bar": "baz"}'::jsonb; -- yields false
+SELECT '{"foo": {"bar": "baz"}}'::jsonb @> '{"bar": "baz"}'::jsonb; -- yields false
</programlisting>
<para>
@@ -309,10 +309,10 @@ SELECT '{"foo": {"bar": "baz"}}'::jsonb @> '{"bar": "baz"}'::jsonb; -- yields f
</para>
<programlisting>
-- This array contains the primitive string value:
-SELECT '["foo", "bar"]'::jsonb @> '"bar"'::jsonb;
+SELECT '["foo", "bar"]'::jsonb @> '"bar"'::jsonb;
-- This exception is not reciprocal -- non-containment is reported here:
-SELECT '"bar"'::jsonb @> '["bar"]'::jsonb; -- yields false
+SELECT '"bar"'::jsonb @> '["bar"]'::jsonb; -- yields false
</programlisting>
<para>
diff --git a/doc/src/sgml/rangetypes.sgml b/doc/src/sgml/rangetypes.sgml
index 784f18eb483..9557c16a4db 100644
--- a/doc/src/sgml/rangetypes.sgml
+++ b/doc/src/sgml/rangetypes.sgml
@@ -79,7 +79,7 @@ INSERT INTO reservation VALUES
(1108, '[2010-01-01 14:30, 2010-01-01 15:30)');
-- Containment
-SELECT int4range(10, 20) @> 3;
+SELECT int4range(10, 20) @> 3;
-- Overlaps
SELECT numrange(11.1, 22.2) && numrange(20.0, 30.0);
[parent: b852dc4cbd09]