@@ -17758,7 +17758,7 @@ $.* ? (@ like_regex "^\\d+$")
17758
17758
<title>Notes</title>
17759
17759
<para>
17760
17760
Alternatively, you can construct <acronym>JSON</acronym> values simply
17761
- using <productname>PostgreSQL</productname>-specific casts to
17761
+ using <productname>PostgreSQL</productname>-specific casts to
17762
17762
<type>json</type> and <type>jsonb</type> types.
17763
17763
</para>
17764
17764
</sect5>
@@ -19127,7 +19127,7 @@ FROM my_films;
19127
19127
SELECT
19128
19128
JSON_QUERY(js, '$.favorites[*].kind' ERROR ON ERROR)
19129
19129
FROM my_films;
19130
- ERROR: more than one SQL/JSON item
19130
+ ERROR: more than one SQL/JSON item
19131
19131
</screen>
19132
19132
19133
19133
<para>
@@ -19175,7 +19175,7 @@ SELECT JSON_QUERY(jsonb '"aaa"', '$' RETURNING text OMIT QUOTES);
19175
19175
19176
19176
<synopsis>
19177
19177
<replaceable class="parameter">expression</replaceable>
19178
- IS <optional> NOT </optional> JSON
19178
+ IS <optional> NOT </optional> JSON
19179
19179
<optional> { VALUE | SCALAR | ARRAY | OBJECT } </optional>
19180
19180
<optional> { WITH | WITHOUT } UNIQUE <optional> KEYS </optional> </optional>
19181
19181
</synopsis>
@@ -19294,16 +19294,16 @@ SELECT JSON_QUERY(jsonb '"aaa"', '$' RETURNING text OMIT QUOTES);
19294
19294
</para>
19295
19295
<screen>
19296
19296
SELECT
19297
- js,
19298
- js IS JSON "is json",
19297
+ js,
19298
+ js IS JSON "is json",
19299
19299
js IS NOT JSON "is not json",
19300
19300
js IS JSON SCALAR "is scalar",
19301
19301
js IS JSON OBJECT "is object",
19302
19302
js IS JSON ARRAY "is array"
19303
- FROM
19303
+ FROM
19304
19304
(VALUES ('123'), ('"abc"'), ('{"a": "b"}'), ('[1,2]'), ('abc')) foo(js);
19305
19305
19306
- js | is json | is not json | is scalar | is object | is array
19306
+ js | is json | is not json | is scalar | is object | is array
19307
19307
------------+---------+-------------+-----------+-----------|-------------
19308
19308
123 | t | f | t | f | f
19309
19309
"abc" | t | f | t | f | f
@@ -19704,7 +19704,7 @@ where <replaceable class="parameter">json_table_column</replaceable> is:
19704
19704
<listitem>
19705
19705
19706
19706
<para>
19707
- Use <literal>CROSS JOIN</literal>, so that the output includes
19707
+ Use <literal>CROSS JOIN</literal>, so that the output includes
19708
19708
a row for every possible combination of rows from the left-hand
19709
19709
and the right-hand columns.
19710
19710
</para>
@@ -19743,7 +19743,7 @@ where <replaceable class="parameter">json_table_column</replaceable> is:
19743
19743
some JSON data about the films and create a view that
19744
19744
distributes the film genre, title, and director between separate columns:
19745
19745
<screen>
19746
- SELECT jt.* FROM
19746
+ SELECT jt.* FROM
19747
19747
my_films,
19748
19748
JSON_TABLE ( js, '$.favorites[*]' COLUMNS (
19749
19749
id FOR ORDINALITY,
@@ -19864,7 +19864,7 @@ JSON_SERIALIZE (
19864
19864
<title>Notes</title>
19865
19865
<para>
19866
19866
Alternatively, you can construct <acronym>JSON</acronym> values simply
19867
- using <productname>PostgreSQL</productname>-specific casts to
19867
+ using <productname>PostgreSQL</productname>-specific casts to
19868
19868
<type>json</type> and <type>jsonb</type> types.
19869
19869
</para>
19870
19870
</sect5>
0 commit comments