Skip to content

Commit 338a862

Browse files
peterepetere
committed
doc: Whitespace and formatting fixes
1 parent f17e247 commit 338a862

File tree

9 files changed

+45
-43
lines changed

9 files changed

+45
-43
lines changed

‎doc/src/sgml/brin.sgml

+2-2
Original file line numberDiff line numberDiff line change
@@ -48,7 +48,7 @@
4848
geometrical types might store the bounding box for all the objects
4949
in the block range.
5050
</para>
51-
51+
5252
<para>
5353
The size of the block range is determined at index creation time by
5454
the <literal>pages_per_range</> storage parameter. The number of index
@@ -65,7 +65,7 @@
6565

6666
<para>
6767
The core <productname>PostgreSQL</productname> distribution
68-
includes the <acronym>BRIN</acronym> operator classes shown in
68+
includes the <acronym>BRIN</acronym> operator classes shown in
6969
<xref linkend="brin-builtin-opclasses-table">.
7070
</para>
7171

‎doc/src/sgml/config.sgml

+1-1
Original file line numberDiff line numberDiff line change
@@ -2518,7 +2518,7 @@ include_dir 'conf.d'
25182518
mode. In <literal>always</> mode, all files restored from the archive
25192519
or streamed with streaming replication will be archived (again). See
25202520
<xref linkend="continuous-archiving-in-standby"> for details.
2521-
</para>
2521+
</para>
25222522
<para>
25232523
<varname>archive_mode</> and <varname>archive_command</> are
25242524
separate variables so that <varname>archive_command</> can be

‎doc/src/sgml/func.sgml

+10-10
Original file line numberDiff line numberDiff line change
@@ -10911,16 +10911,16 @@ table2-mapping
1091110911
</entry>
1091210912
<entry><literal>jsonb_pretty('[{"f1":1,"f2":null},2,null,3]')</literal></entry>
1091310913
<entry>
10914-
<programlisting>
10915-
[
10916-
{
10917-
"f1": 1,
10918-
"f2": null
10919-
},
10920-
2,
10921-
null,
10922-
3
10923-
]
10914+
<programlisting>
10915+
[
10916+
{
10917+
"f1": 1,
10918+
"f2": null
10919+
},
10920+
2,
10921+
null,
10922+
3
10923+
]
1092410924
</programlisting>
1092510925
</entry>
1092610926
</row>

‎doc/src/sgml/libpq.sgml

+6-4
Original file line numberDiff line numberDiff line change
@@ -1906,8 +1906,10 @@ const char *PQsslAttribute(const PGconn *conn, const char *attribute_name);
19061906
<term><literal>protocol</literal></term>
19071907
<listitem>
19081908
<para>
1909-
SSL/TLS version in use. Common values are "SSLv2", "SSLv3",
1910-
"TLSv1", "TLSv1.1" and "TLSv1.2", but an implementation may
1909+
SSL/TLS version in use. Common values
1910+
are <literal>"SSLv2"</literal>, <literal>"SSLv3"</literal>,
1911+
<literal>"TLSv1"</literal>, <literal>"TLSv1.1"</literal>
1912+
and <literal>"TLSv1.2"</literal>, but an implementation may
19111913
return other strings if some other protocol is used.
19121914
</para>
19131915
</listitem>
@@ -1924,7 +1926,7 @@ const char *PQsslAttribute(const PGconn *conn, const char *attribute_name);
19241926
<term><literal>cipher</literal></term>
19251927
<listitem>
19261928
<para>
1927-
A short name of the ciphersuite used, e.g.
1929+
A short name of the ciphersuite used, e.g.
19281930
<literal>"DHE-RSA-DES-CBC3-SHA"</literal>. The names are specific
19291931
to each SSL implementation.
19301932
</para>
@@ -5149,7 +5151,7 @@ int PQputCopyEnd(PGconn *conn,
51495151
connections.)
51505152
</para>
51515153

5152-
<para>
5154+
<para>
51535155
The result is 1 if the termination message was sent; or in
51545156
nonblocking mode, this may only indicate that the termination
51555157
message was successfully queued. (In nonblocking mode, to be

‎doc/src/sgml/pageinspect.sgml

+1-1
Original file line numberDiff line numberDiff line change
@@ -382,7 +382,7 @@ test=# SELECT * FROM gin_page_opaque_info(get_raw_page('gin_index', 2));
382382
<function>gin_leafpage_items</function> returns information about
383383
the data stored in a <acronym>GIN</acronym> leaf page. For example:
384384
<screen>
385-
test=# SELECT first_tid, nbytes, tids[0:5] as some_tids
385+
test=# SELECT first_tid, nbytes, tids[0:5] as some_tids
386386
FROM gin_leafpage_items(get_raw_page('gin_test_idx', 2));
387387
first_tid | nbytes | some_tids
388388
-----------+--------+----------------------------------------------------------

‎doc/src/sgml/ref/drop_policy.sgml

+3-3
Original file line numberDiff line numberDiff line change
@@ -83,9 +83,9 @@ DROP POLICY [ IF EXISTS ] <replaceable class="parameter">name</replaceable> ON <
8383
To drop the policy called <literal>p1</literal> on the table named
8484
<literal>my_table</literal>:
8585

86-
<programlisting>
87-
DROP POLICY p1 ON my_table;
88-
</programlisting>
86+
<programlisting>
87+
DROP POLICY p1 ON my_table;
88+
</programlisting>
8989
</para>
9090
</refsect1>
9191

‎doc/src/sgml/ref/insert.sgml

+20-20
Original file line numberDiff line numberDiff line change
@@ -621,9 +621,9 @@ INSERT INTO employees_log SELECT *, current_timestamp FROM upd;
621621
expression is used to reference values originally proposed for
622622
insertion:
623623
<programlisting>
624-
INSERT INTO distributors (did, dname)
625-
VALUES (5, 'Gizmo transglobal'), (6, 'Associated Computing, inc')
626-
ON CONFLICT (did) DO UPDATE SET dname = EXCLUDED.dname;
624+
INSERT INTO distributors (did, dname)
625+
VALUES (5, 'Gizmo transglobal'), (6, 'Associated Computing, inc')
626+
ON CONFLICT (did) DO UPDATE SET dname = EXCLUDED.dname;
627627
</programlisting>
628628
</para>
629629
<para>
@@ -633,8 +633,8 @@ INSERT INTO employees_log SELECT *, current_timestamp FROM upd;
633633
Example assumes a unique index has been defined that constrains
634634
values appearing in the <literal>did</literal> column:
635635
<programlisting>
636-
INSERT INTO distributors (did, dname) VALUES (7, 'Redline GmbH')
637-
ON CONFLICT (did) DO NOTHING;
636+
INSERT INTO distributors (did, dname) VALUES (7, 'Redline GmbH')
637+
ON CONFLICT (did) DO NOTHING;
638638
</programlisting>
639639
</para>
640640
<para>
@@ -644,16 +644,16 @@ INSERT INTO employees_log SELECT *, current_timestamp FROM upd;
644644
used to limit the rows actually updated (any existing row not
645645
updated will still be locked, though):
646646
<programlisting>
647-
-- Don't update existing distributors based in a certain ZIP code
648-
INSERT INTO distributors AS d (did, dname) VALUES (8, 'Anvil Distribution')
649-
ON CONFLICT (did) DO UPDATE
650-
SET dname = EXCLUDED.dname || ' (formerly ' || d.dname || ')'
651-
WHERE d.zipcode != '21201';
652-
653-
-- Name a constraint directly in the statement (uses associated
654-
-- index to arbitrate taking the DO NOTHING action)
655-
INSERT INTO distributors (did, dname) VALUES (9, 'Antwerp Design')
656-
ON CONFLICT ON CONSTRAINT distributors_pkey DO NOTHING;
647+
-- Don't update existing distributors based in a certain ZIP code
648+
INSERT INTO distributors AS d (did, dname) VALUES (8, 'Anvil Distribution')
649+
ON CONFLICT (did) DO UPDATE
650+
SET dname = EXCLUDED.dname || ' (formerly ' || d.dname || ')'
651+
WHERE d.zipcode &lt;&gt; '21201';
652+
653+
-- Name a constraint directly in the statement (uses associated
654+
-- index to arbitrate taking the DO NOTHING action)
655+
INSERT INTO distributors (did, dname) VALUES (9, 'Antwerp Design')
656+
ON CONFLICT ON CONSTRAINT distributors_pkey DO NOTHING;
657657
</programlisting>
658658
</para>
659659
<para>
@@ -664,11 +664,11 @@ INSERT INTO employees_log SELECT *, current_timestamp FROM upd;
664664
<literal>is_active</literal> boolean column evaluates to
665665
<literal>true</literal>:
666666
<programlisting>
667-
-- This statement could infer a partial unique index on "did"
668-
-- with a predicate of "WHERE is_active", but it could also
669-
-- just use a regular unique constraint on "did"
670-
INSERT INTO distributors (did, dname) VALUES (10, 'Conrad International')
671-
ON CONFLICT (did) WHERE is_active DO NOTHING;
667+
-- This statement could infer a partial unique index on "did"
668+
-- with a predicate of "WHERE is_active", but it could also
669+
-- just use a regular unique constraint on "did"
670+
INSERT INTO distributors (did, dname) VALUES (10, 'Conrad International')
671+
ON CONFLICT (did) WHERE is_active DO NOTHING;
672672
</programlisting>
673673
</para>
674674
</refsect1>

‎doc/src/sgml/ref/pgupgrade.sgml

+1-1
Original file line numberDiff line numberDiff line change
@@ -487,7 +487,7 @@ pg_upgrade.exe
487487
directories, run this for each slave:
488488

489489
<programlisting>
490-
rsync --archive --delete --hard-links --size-only old_pgdata new_pgdata remote_dir
490+
rsync --archive --delete --hard-links --size-only old_pgdata new_pgdata remote_dir
491491
</programlisting>
492492

493493
where <option>old_pgdata</> and <option>new_pgdata</> are relative

‎doc/src/sgml/syntax.sgml

+1-1
Original file line numberDiff line numberDiff line change
@@ -2617,7 +2617,7 @@ SELECT concat_lower_or_upper(a => 'Hello', uppercase => true, b => 'World');
26172617
<para>
26182618
An older syntax based on ":=" is supported for backward compatibility:
26192619
<screen>
2620-
SELECT concat_lower_or_upper(a := 'Hello', uppercase := true, b := 'World');
2620+
SELECT concat_lower_or_upper(a := 'Hello', uppercase := true, b := 'World');
26212621
concat_lower_or_upper
26222622
-----------------------
26232623
HELLO WORLD

0 commit comments

Comments
 (0)