diff options
45 files changed, 275 insertions, 279 deletions
diff --git a/.gitattributes b/.gitattributes index f9868677fa2..4e4e26e34b0 100644 --- a/.gitattributes +++ b/.gitattributes @@ -1,8 +1,9 @@ * whitespace=space-before-tab,trailing-space *.[chly] whitespace=space-before-tab,trailing-space,indent-with-non-tab,tabwidth=4 *.pl whitespace=space-before-tab,trailing-space,tabwidth=4 +*.pm whitespace=space-before-tab,trailing-space,tabwidth=4 *.po whitespace=space-before-tab,trailing-space,tab-in-indent,-blank-at-eof -*.sgml whitespace=space-before-tab,trailing-space,tab-in-indent,-blank-at-eol +*.sgml whitespace=space-before-tab,trailing-space,tab-in-indent *.x[ms]l whitespace=space-before-tab,trailing-space,tab-in-indent # Avoid confusing ASCII underlines with leftover merge conflict markers @@ -17,9 +18,6 @@ src/backend/utils/Gen_dummy_probes.pl.prolog whitespace=-blank-at-eof # Test output files that contain extra whitespace *.out -whitespace -contrib/*/output/*.source -whitespace -src/pl/plpgsql/src/output/*.source -whitespace -src/test/regress/output/*.source -whitespace src/interfaces/ecpg/test/expected/* -whitespace src/interfaces/libpq/test/expected.out whitespace=-blank-at-eof @@ -27,7 +25,6 @@ src/interfaces/libpq/test/expected.out whitespace=-blank-at-eof configure -whitespace ppport.h -whitespace src/backend/regex/COPYRIGHT -whitespace -src/backend/regex/re_syntax.n -whitespace src/backend/snowball/libstemmer/*.c -whitespace src/backend/utils/mb/Unicode/*-std.txt -whitespace src/include/snowball/libstemmer/* -whitespace diff --git a/doc/src/sgml/advanced.sgml b/doc/src/sgml/advanced.sgml index 71ae423f631..755c9f14850 100644 --- a/doc/src/sgml/advanced.sgml +++ b/doc/src/sgml/advanced.sgml @@ -344,7 +344,7 @@ SELECT depname, empno, salary, avg(salary) OVER (PARTITION BY depname) FROM emps </programlisting> <screen> - depname | empno | salary | avg + depname | empno | salary | avg -----------+-------+--------+----------------------- develop | 11 | 5200 | 5020.0000000000000000 develop | 7 | 4200 | 5020.0000000000000000 @@ -394,7 +394,7 @@ FROM empsalary; </programlisting> <screen> - depname | empno | salary | rank + depname | empno | salary | rank -----------+-------+--------+------ develop | 8 | 6000 | 1 develop | 10 | 5200 | 2 @@ -458,7 +458,7 @@ SELECT salary, sum(salary) OVER () FROM empsalary; </programlisting> <screen> - salary | sum + salary | sum --------+------- 5200 | 47100 5000 | 47100 @@ -487,7 +487,7 @@ SELECT salary, sum(salary) OVER (ORDER BY salary) FROM empsalary; </programlisting> <screen> - salary | sum + salary | sum --------+------- 3500 | 3500 3900 | 7400 diff --git a/doc/src/sgml/backup.sgml b/doc/src/sgml/backup.sgml index 5b147a746de..73a774d3d7f 100644 --- a/doc/src/sgml/backup.sgml +++ b/doc/src/sgml/backup.sgml @@ -929,7 +929,7 @@ SELECT * FROM pg_backup_stop(wait_for_archive => true); <filename>backup_label</filename> in the root directory of the backup. The third field should be written to a file named <filename>tablespace_map</filename> unless the field is empty. These files are - vital to the backup working and must be written byte for byte without + vital to the backup working and must be written byte for byte without modification, which may require opening the file in binary mode. </para> </listitem> diff --git a/doc/src/sgml/bloom.sgml b/doc/src/sgml/bloom.sgml index d1cf9ac24a7..a3f51cfdc4b 100644 --- a/doc/src/sgml/bloom.sgml +++ b/doc/src/sgml/bloom.sgml @@ -116,7 +116,7 @@ SELECT 10000000 A sequential scan over this large table takes a long time: <programlisting> =# EXPLAIN ANALYZE SELECT * FROM tbloom WHERE i2 = 898732 AND i5 = 123451; - QUERY PLAN + QUERY PLAN -------------------------------------------------------------------&zwsp;----------------------------------- Seq Scan on tbloom (cost=0.00..2137.14 rows=3 width=24) (actual time=16.971..16.971 rows=0 loops=1) Filter: ((i2 = 898732) AND (i5 = 123451)) @@ -139,7 +139,7 @@ CREATE INDEX 3976 kB (1 row) =# EXPLAIN ANALYZE SELECT * FROM tbloom WHERE i2 = 898732 AND i5 = 123451; - QUERY PLAN + QUERY PLAN -------------------------------------------------------------------&zwsp;----------------------------------- Seq Scan on tbloom (cost=0.00..2137.00 rows=2 width=24) (actual time=12.805..12.805 rows=0 loops=1) Filter: ((i2 = 898732) AND (i5 = 123451)) @@ -162,7 +162,7 @@ CREATE INDEX 1584 kB (1 row) =# EXPLAIN ANALYZE SELECT * FROM tbloom WHERE i2 = 898732 AND i5 = 123451; - QUERY PLAN + QUERY PLAN -------------------------------------------------------------------&zwsp;-------------------------------------------------- Bitmap Heap Scan on tbloom (cost=1792.00..1799.69 rows=2 width=24) (actual time=0.388..0.388 rows=0 loops=1) Recheck Cond: ((i2 = 898732) AND (i5 = 123451)) @@ -195,7 +195,7 @@ CREATE INDEX =# CREATE INDEX btreeidx6 ON tbloom (i6); CREATE INDEX =# EXPLAIN ANALYZE SELECT * FROM tbloom WHERE i2 = 898732 AND i5 = 123451; - QUERY PLAN + QUERY PLAN -------------------------------------------------------------------&zwsp;-------------------------------------------------------- Bitmap Heap Scan on tbloom (cost=24.34..32.03 rows=2 width=24) (actual time=0.028..0.029 rows=0 loops=1) Recheck Cond: ((i5 = 123451) AND (i2 = 898732)) diff --git a/doc/src/sgml/charset.sgml b/doc/src/sgml/charset.sgml index b95303fb893..445fd175d8e 100644 --- a/doc/src/sgml/charset.sgml +++ b/doc/src/sgml/charset.sgml @@ -1574,13 +1574,13 @@ CREATE DATABASE korean WITH ENCODING 'EUC_KR' LC_COLLATE='ko_KR.euckr' LC_CTYPE= <screen> $ <userinput>psql -l</userinput> List of databases - Name | Owner | Encoding | Collation | Ctype | Access Privileges + Name | Owner | Encoding | Collation | Ctype | Access Privileges -----------+----------+-----------+-------------+-------------+------------------------------------- - clocaledb | hlinnaka | SQL_ASCII | C | C | - englishdb | hlinnaka | UTF8 | en_GB.UTF8 | en_GB.UTF8 | - japanese | hlinnaka | UTF8 | ja_JP.UTF8 | ja_JP.UTF8 | - korean | hlinnaka | EUC_KR | ko_KR.euckr | ko_KR.euckr | - postgres | hlinnaka | UTF8 | fi_FI.UTF8 | fi_FI.UTF8 | + clocaledb | hlinnaka | SQL_ASCII | C | C | + englishdb | hlinnaka | UTF8 | en_GB.UTF8 | en_GB.UTF8 | + japanese | hlinnaka | UTF8 | ja_JP.UTF8 | ja_JP.UTF8 | + korean | hlinnaka | EUC_KR | ko_KR.euckr | ko_KR.euckr | + postgres | hlinnaka | UTF8 | fi_FI.UTF8 | fi_FI.UTF8 | template0 | hlinnaka | UTF8 | fi_FI.UTF8 | fi_FI.UTF8 | {=c/hlinnaka,hlinnaka=CTc/hlinnaka} template1 | hlinnaka | UTF8 | fi_FI.UTF8 | fi_FI.UTF8 | {=c/hlinnaka,hlinnaka=CTc/hlinnaka} (7 rows) diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 0932c812da5..9b0c6c69266 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -3177,7 +3177,7 @@ CREATE TABLE person ( ); INSERT INTO person VALUES ('Moe', 'happy'); SELECT * FROM person WHERE current_mood = 'happy'; - name | current_mood + name | current_mood ------+-------------- Moe | happy (1 row) @@ -3198,14 +3198,14 @@ SELECT * FROM person WHERE current_mood = 'happy'; INSERT INTO person VALUES ('Larry', 'sad'); INSERT INTO person VALUES ('Curly', 'ok'); SELECT * FROM person WHERE current_mood > 'sad'; - name | current_mood + name | current_mood -------+-------------- Moe | happy Curly | ok (2 rows) SELECT * FROM person WHERE current_mood > 'sad' ORDER BY current_mood; - name | current_mood + name | current_mood -------+-------------- Curly | ok Moe | happy @@ -3214,7 +3214,7 @@ SELECT * FROM person WHERE current_mood > 'sad' ORDER BY current_mood; SELECT name FROM person WHERE current_mood = (SELECT MIN(current_mood) FROM person); - name + name ------- Larry (1 row) @@ -3253,7 +3253,7 @@ ERROR: operator does not exist: mood = happiness <programlisting> SELECT person.name, holidays.num_weeks FROM person, holidays WHERE person.current_mood::text = holidays.happiness::text; - name | num_weeks + name | num_weeks ------+----------- Moe | 4 (1 row) @@ -3982,7 +3982,7 @@ SELECT person.name, holidays.num_weeks FROM person, holidays <programlisting> SELECT macaddr8_set7bit('08:00:2b:01:02:03'); <computeroutput> - macaddr8_set7bit + macaddr8_set7bit ------------------------- 0a:00:2b:ff:fe:01:02:03 (1 row) @@ -4124,7 +4124,7 @@ SELECT 'a fat cat sat on a mat and ate a fat rat'::tsvector; <programlisting> SELECT $$the lexeme ' ' contains spaces$$::tsvector; - tsvector + tsvector ------------------------------------------- ' ' 'contains' 'lexeme' 'spaces' 'the' </programlisting> @@ -4135,7 +4135,7 @@ SELECT $$the lexeme ' ' contains spaces$$::tsvector; <programlisting> SELECT $$the lexeme 'Joe''s' contains a quote$$::tsvector; - tsvector + tsvector ------------------------------------------------ 'Joe''s' 'a' 'contains' 'lexeme' 'quote' 'the' </programlisting> @@ -4165,7 +4165,7 @@ SELECT 'a:1 fat:2 cat:3 sat:4 on:5 a:6 mat:7 and:8 ate:9 a:10 fat:11 rat:12'::ts <programlisting> SELECT 'a:1A fat:2B,4C cat:5D'::tsvector; - tsvector + tsvector ---------------------------- 'a':1A 'cat':5 'fat':2B,4C </programlisting> @@ -4184,7 +4184,7 @@ SELECT 'a:1A fat:2B,4C cat:5D'::tsvector; <programlisting> SELECT 'The Fat Rats'::tsvector; - tsvector + tsvector -------------------- 'Fat' 'Rats' 'The' </programlisting> @@ -4197,7 +4197,7 @@ SELECT 'The Fat Rats'::tsvector; <programlisting> SELECT to_tsvector('english', 'The Fat Rats'); - to_tsvector + to_tsvector ----------------- 'fat':2 'rat':3 </programlisting> @@ -4239,17 +4239,17 @@ SELECT to_tsvector('english', 'The Fat Rats'); <programlisting> SELECT 'fat & rat'::tsquery; - tsquery + tsquery --------------- 'fat' & 'rat' SELECT 'fat & (rat | cat)'::tsquery; - tsquery + tsquery --------------------------- 'fat' & ( 'rat' | 'cat' ) SELECT 'fat & rat & ! cat'::tsquery; - tsquery + tsquery ------------------------ 'fat' & 'rat' & !'cat' </programlisting> @@ -4273,7 +4273,7 @@ SELECT 'fat:ab & cat'::tsquery; to specify prefix matching: <programlisting> SELECT 'super:*'::tsquery; - tsquery + tsquery ----------- 'super':* </programlisting> @@ -4290,7 +4290,7 @@ SELECT 'super:*'::tsquery; <programlisting> SELECT to_tsquery('Fat:ab & Cats'); - to_tsquery + to_tsquery ------------------ 'fat':AB & 'cat' </programlisting> diff --git a/doc/src/sgml/dblink.sgml b/doc/src/sgml/dblink.sgml index 4ab38bcc999..50c49f533b3 100644 --- a/doc/src/sgml/dblink.sgml +++ b/doc/src/sgml/dblink.sgml @@ -161,13 +161,13 @@ GRANT SELECT ON TABLE foo TO regress_dblink_user; \set ORIGINAL_USER :USER \c - regress_dblink_user SELECT dblink_connect('myconn', 'fdtest'); - dblink_connect + dblink_connect ---------------- OK (1 row) SELECT * FROM dblink('myconn', 'SELECT * FROM foo') AS t(a int, b text, c text[]); - a | b | c + a | b | c ----+---+--------------- 0 | a | {a0,b0,c0} 1 | b | {a1,b1,c1} @@ -1397,7 +1397,7 @@ dblink_get_notify(text connname) returns setof (notify_name text, be_pid int, ex <screen> SELECT dblink_exec('LISTEN virtual'); - dblink_exec + dblink_exec ------------- LISTEN (1 row) diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 77ce39766c0..f2ac1ba0034 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -2619,13 +2619,13 @@ CREATE POLICY admin_local_only ON passwd AS RESTRICTIVE TO admin <programlisting> => SELECT current_user; - current_user + current_user -------------- admin (1 row) => select inet_client_addr(); - inet_client_addr + inet_client_addr ------------------ 127.0.0.1 (1 row) diff --git a/doc/src/sgml/fdwhandler.sgml b/doc/src/sgml/fdwhandler.sgml index dbf5dd3d15a..d0b5951019b 100644 --- a/doc/src/sgml/fdwhandler.sgml +++ b/doc/src/sgml/fdwhandler.sgml @@ -1089,7 +1089,7 @@ ExecForeignTruncate(List *rels, requested in the original <command>TRUNCATE</command> command, respectively. </para> - + <para> If <literal>restart_seqs</literal> is <literal>true</literal>, the original <command>TRUNCATE</command> command requested the diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 5804069e6a3..396359883d2 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -6011,44 +6011,44 @@ regexp_replace('A PostgreSQL function', 'a|e|i|o|u', 'X', 1, 3, 'i') Some examples: <programlisting> SELECT foo FROM regexp_split_to_table('the quick brown fox jumps over the lazy dog', '\s+') AS foo; - foo + foo ------- - the - quick - brown - fox - jumps - over - the - lazy - dog + the + quick + brown + fox + jumps + over + the + lazy + dog (9 rows) SELECT regexp_split_to_array('the quick brown fox jumps over the lazy dog', '\s+'); - regexp_split_to_array + regexp_split_to_array ----------------------------------------------- {the,quick,brown,fox,jumps,over,the,lazy,dog} (1 row) SELECT foo FROM regexp_split_to_table('the quick brown fox', '\s*') AS foo; - foo + foo ----- - t - h - e - q - u - i - c - k - b - r - o - w - n - f - o - x + t + h + e + q + u + i + c + k + b + r + o + w + n + f + o + x (16 rows) </programlisting> </para> @@ -14400,32 +14400,32 @@ SELECT xmlexists('//town[text() = ''Toronto'']' PASSING BY VALUE '<towns><town>T <screen><![CDATA[ SET xmloption TO DOCUMENT; SELECT xml_is_well_formed('<>'); - xml_is_well_formed + xml_is_well_formed -------------------- f (1 row) SELECT xml_is_well_formed('<abc/>'); - xml_is_well_formed + xml_is_well_formed -------------------- t (1 row) SET xmloption TO CONTENT; SELECT xml_is_well_formed('abc'); - xml_is_well_formed + xml_is_well_formed -------------------- t (1 row) SELECT xml_is_well_formed_document('<pg:foo xmlns:pg="http://postgresql.org/stuff">bar</pg:foo>'); - xml_is_well_formed_document + xml_is_well_formed_document ----------------------------- t (1 row) SELECT xml_is_well_formed_document('<pg:foo xmlns:pg="http://postgresql.org/stuff">bar</my:foo>'); - xml_is_well_formed_document + xml_is_well_formed_document ----------------------------- f (1 row) @@ -14492,7 +14492,7 @@ SELECT xml_is_well_formed_document('<pg:foo xmlns:pg="http://postgresql.org/stuf SELECT xpath('/my:a/text()', '<my:a xmlns:my="http://example.com">test</my:a>', ARRAY[ARRAY['my', 'http://example.com']]); - xpath + xpath -------- {test} (1 row) @@ -14540,7 +14540,7 @@ SELECT xpath('//mydefns:b/text()', '<a xmlns="http://example.com"><b>test</b></a SELECT xpath_exists('/my:a/text()', '<my:a xmlns:my="http://example.com">test</my:a>', ARRAY[ARRAY['my', 'http://example.com']]); - xpath_exists + xpath_exists -------------- t (1 row) @@ -14773,7 +14773,7 @@ SELECT xmltable.* 'concat(SIZE[@unit!="sq_km"], " ", SIZE[@unit!="sq_km"]/@unit)', premier_name text PATH 'PREMIER_NAME' DEFAULT 'not specified'); - id | ordinality | COUNTRY_NAME | country_id | size_sq_km | size_other | premier_name + id | ordinality | COUNTRY_NAME | country_id | size_sq_km | size_other | premier_name ----+------------+--------------+------------+------------+--------------+--------------- 1 | 1 | Australia | AU | | | not specified 5 | 2 | Japan | JP | | 145935 sq_mi | Shinzo Abe @@ -14794,9 +14794,9 @@ $$ AS data; SELECT xmltable.* FROM xmlelements, XMLTABLE('/root' PASSING data COLUMNS element text); - element + element ------------------------- - Hello2a2 bbbxxxCC + Hello2a2 bbbxxxCC ]]></screen> </para> @@ -17769,14 +17769,14 @@ $.* ? (@ like_regex "^\\d+$") </para> <screen> SELECT JSON('{ "a" : 123, "b": [ true, "foo" ], "a" : "bar" }'); - json + json -------------------------------------------------- { "a" : 123, "b": [ true, "foo" ], "a" : "bar" } (1 row) SELECT JSON('{"a": 123, "b": [true, "foo"], "a": "bar"}' RETURNING jsonb); - json + json ---------------------------------- {"a": "bar", "b": [true, "foo"]} (1 row) @@ -18097,7 +18097,7 @@ WHERE f.did = 103; <sect4 id="functions-jsonobjectagg"> <title><literal>JSON_OBJECTAGG</literal></title> <indexterm><primary>json_objectagg</primary></indexterm> - + <synopsis> <function>JSON_OBJECTAGG</function> ( <optional> { <parameter>key_expression</parameter> { VALUE | ':' } <parameter>value_expression</parameter> } </optional> @@ -18906,7 +18906,7 @@ SELECT JSON_VALUE('123.45', '$' RETURNING int ERROR ON ERROR); (1 row) SELECT JSON_VALUE('"03:04 2015-02-01"', '$.datetime("HH24:MI YYYY-MM-DD")' RETURNING date); - json_value + json_value ------------ 2015-02-01 (1 row) @@ -19222,7 +19222,7 @@ SELECT JSON_QUERY(jsonb '"aaa"', '$' RETURNING text OMIT QUOTES); </para> </listitem> </varlistentry> - + <varlistentry> <term> <literal>VALUE | SCALAR | ARRAY | OBJECT</literal> @@ -19875,7 +19875,7 @@ JSON_SERIALIZE ( </para> <screen> SELECT JSON_SERIALIZE(JSON_SCALAR('foo')); - json_serialize + json_serialize ---------------- "foo" (1 row) @@ -19890,7 +19890,7 @@ SELECT JSON_SERIALIZE('{"foo": "bar", "baz": [1, 2]}' RETURNING bytea); </sect4> </sect3> - + <sect3 id="sqljson-common-clauses"> <title>SQL/JSON Common Clauses</title> @@ -28114,7 +28114,7 @@ SELECT collation for ('foo' COLLATE "de_DE"); to log the memory contexts of a backend process. For example: <programlisting> postgres=# SELECT pg_log_backend_memory_contexts(pg_backend_pid()); - pg_log_backend_memory_contexts + pg_log_backend_memory_contexts -------------------------------- t (1 row) diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index db1bde47064..c7e402765fc 100644 --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -980,7 +980,7 @@ postgres=# SELECT * FROM pg_create_physical_replication_slot('node_a_slot'); node_a_slot | postgres=# SELECT slot_name, slot_type, active FROM pg_replication_slots; - slot_name | slot_type | active + slot_name | slot_type | active -------------+-----------+-------- node_a_slot | physical | f (1 row) diff --git a/doc/src/sgml/hstore.sgml b/doc/src/sgml/hstore.sgml index 679878b3afc..335d64641ba 100644 --- a/doc/src/sgml/hstore.sgml +++ b/doc/src/sgml/hstore.sgml @@ -817,7 +817,7 @@ CREATE TABLE test (col1 integer, col2 text, col3 text); INSERT INTO test VALUES (123, 'foo', 'bar'); SELECT hstore(t) FROM test AS t; - hstore + hstore --------------------------------------------- "col1"=>"123", "col2"=>"foo", "col3"=>"bar" (1 row) @@ -831,9 +831,9 @@ CREATE TABLE test (col1 integer, col2 text, col3 text); SELECT * FROM populate_record(null::test, '"col1"=>"456", "col2"=>"zzz"'); - col1 | col2 | col3 + col1 | col2 | col3 ------+------+------ - 456 | zzz | + 456 | zzz | (1 row) </programlisting> </para> @@ -845,7 +845,7 @@ CREATE TABLE test (col1 integer, col2 text, col3 text); INSERT INTO test VALUES (123, 'foo', 'bar'); SELECT (r).* FROM (SELECT t #= '"col3"=>"baz"' AS r FROM test t) s; - col1 | col2 | col3 + col1 | col2 | col3 ------+------+------ 123 | foo | baz (1 row) diff --git a/doc/src/sgml/json.sgml b/doc/src/sgml/json.sgml index c4223fafb60..0ffb5a708d9 100644 --- a/doc/src/sgml/json.sgml +++ b/doc/src/sgml/json.sgml @@ -200,13 +200,13 @@ SELECT '{"foo": [true, "bar"], "tags": {"a": 1, "b": null}}'::json; details such as whitespace. For example, note the differences here: <programlisting> SELECT '{"bar": "baz", "balance": 7.77, "active":false}'::json; - json + json ------------------------------------------------- {"bar": "baz", "balance": 7.77, "active":false} (1 row) SELECT '{"bar": "baz", "balance": 7.77, "active":false}'::jsonb; - jsonb + jsonb -------------------------------------------------- {"bar": "baz", "active": false, "balance": 7.77} (1 row) @@ -218,7 +218,7 @@ SELECT '{"bar": "baz", "balance": 7.77, "active":false}'::jsonb; example: <programlisting> SELECT '{"reading": 1.230e-5}'::json, '{"reading": 1.230e-5}'::jsonb; - json | jsonb + json | jsonb -----------------------+------------------------- {"reading": 1.230e-5} | {"reading": 0.00001230} (1 row) diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml index bc4d7004561..a0f9cecd01b 100644 --- a/doc/src/sgml/logical-replication.sgml +++ b/doc/src/sgml/logical-replication.sgml @@ -118,7 +118,7 @@ any combination of <command>INSERT</command>, <command>UPDATE</command>, <command>DELETE</command>, and <command>TRUNCATE</command>, similar to how triggers are fired by particular event types. By default, all operation types are replicated. - (Row filters have no effect for <command>TRUNCATE</command>. See + (Row filters have no effect for <command>TRUNCATE</command>. See <xref linkend="logical-replication-row-filter"/>). </para> @@ -324,7 +324,7 @@ <para> By default, all data from all published tables will be replicated to the - appropriate subscribers. The replicated data can be reduced by using a + appropriate subscribers. The replicated data can be reduced by using a <firstterm>row filter</firstterm>. A user might choose to use row filters for behavioral, security or performance reasons. If a published table sets a row filter, a row is replicated only if its data satisfies the row filter @@ -533,14 +533,14 @@ CREATE PUBLICATION <programlisting> test_pub=# \dRp+ Publication p1 - Owner | All tables | Inserts | Updates | Deletes | Truncates | Via root + Owner | All tables | Inserts | Updates | Deletes | Truncates | Via root ----------+------------+---------+---------+---------+-----------+---------- postgres | f | t | t | t | t | f Tables: "public.t1" WHERE ((a > 5) AND (c = 'NSW'::text)) Publication p2 - Owner | All tables | Inserts | Updates | Deletes | Truncates | Via root + Owner | All tables | Inserts | Updates | Deletes | Truncates | Via root ----------+------------+---------+---------+---------+-----------+---------- postgres | f | t | t | t | t | f Tables: @@ -548,7 +548,7 @@ Tables: "public.t2" WHERE (e = 99) Publication p3 - Owner | All tables | Inserts | Updates | Deletes | Truncates | Via root + Owner | All tables | Inserts | Updates | Deletes | Truncates | Via root ----------+------------+---------+---------+---------+-----------+---------- postgres | f | t | t | t | t | f Tables: @@ -565,11 +565,11 @@ Tables: <programlisting> test_pub=# \d t1 Table "public.t1" - Column | Type | Collation | Nullable | Default + Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- - a | integer | | not null | - b | integer | | | - c | text | | not null | + a | integer | | not null | + b | integer | | | + c | text | | not null | Indexes: "t1_pkey" PRIMARY KEY, btree (a, c) Publications: @@ -578,11 +578,11 @@ Publications: test_pub=# \d t2 Table "public.t2" - Column | Type | Collation | Nullable | Default + Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- - d | integer | | not null | - e | integer | | | - f | integer | | | + d | integer | | not null | + e | integer | | | + f | integer | | | Indexes: "t2_pkey" PRIMARY KEY, btree (d) Publications: @@ -591,11 +591,11 @@ Publications: test_pub=# \d t3 Table "public.t3" - Column | Type | Collation | Nullable | Default + Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- - g | integer | | not null | - h | integer | | | - i | integer | | | + g | integer | | not null | + h | integer | | | + i | integer | | | Indexes: "t3_pkey" PRIMARY KEY, btree (g) Publications: @@ -636,7 +636,7 @@ INSERT 0 1 test_pub=# INSERT INTO t1 VALUES (9, 109, 'NSW'); INSERT 0 1 -test_pub=# SELECT * FROM t1; +test_pub=# SELECT * FROM t1; a | b | c ---+-----+----- 2 | 102 | NSW @@ -651,7 +651,7 @@ test_pub=# SELECT * FROM t1; </programlisting> <programlisting> test_sub=# SELECT * FROM t1; - a | b | c + a | b | c ---+-----+----- 6 | 106 | NSW 9 | 109 | NSW @@ -668,7 +668,7 @@ test_pub=# UPDATE t1 SET b = 999 WHERE a = 6; UPDATE 1 test_pub=# SELECT * FROM t1; - a | b | c + a | b | c ---+-----+----- 2 | 102 | NSW 3 | 103 | QLD @@ -682,7 +682,7 @@ test_pub=# SELECT * FROM t1; </programlisting> <programlisting> test_sub=# SELECT * FROM t1; - a | b | c + a | b | c ---+-----+----- 9 | 109 | NSW 6 | 999 | NSW @@ -700,7 +700,7 @@ test_pub=# UPDATE t1 SET a = 555 WHERE a = 2; UPDATE 1 test_pub=# SELECT * FROM t1; - a | b | c + a | b | c -----+-----+----- 3 | 103 | QLD 4 | 104 | VIC @@ -714,7 +714,7 @@ test_pub=# SELECT * FROM t1; </programlisting> <programlisting> test_sub=# SELECT * FROM t1; - a | b | c + a | b | c -----+-----+----- 9 | 109 | NSW 6 | 999 | NSW @@ -733,7 +733,7 @@ test_pub=# UPDATE t1 SET c = 'VIC' WHERE a = 9; UPDATE 1 test_pub=# SELECT * FROM t1; - a | b | c + a | b | c -----+-----+----- 3 | 103 | QLD 4 | 104 | VIC @@ -747,7 +747,7 @@ test_pub=# SELECT * FROM t1; </programlisting> <programlisting> test_sub=# SELECT * FROM t1; - a | b | c + a | b | c -----+-----+----- 6 | 999 | NSW 555 | 102 | NSW @@ -806,7 +806,7 @@ test_pub=# INSERT INTO child VALUES (3), (5), (7); INSERT 0 3 test_pub=# SELECT * FROM parent ORDER BY a; - a + a --- 2 3 @@ -818,7 +818,7 @@ test_pub=# SELECT * FROM parent ORDER BY a; </programlisting> <programlisting> test_sub=# SELECT * FROM parent ORDER BY a; - a + a --- 2 3 @@ -855,7 +855,7 @@ test_pub=# INSERT INTO child VALUES (3), (5), (7); INSERT 0 3 test_pub=# SELECT * FROM parent ORDER BY a; - a + a --- 2 3 @@ -867,7 +867,7 @@ test_pub=# SELECT * FROM parent ORDER BY a; </programlisting> <programlisting> test_sub=# SELECT * FROM child ORDER BY a; - a + a --- 5 6 diff --git a/doc/src/sgml/logicaldecoding.sgml b/doc/src/sgml/logicaldecoding.sgml index 8b2c31a87fa..38ee69dcccc 100644 --- a/doc/src/sgml/logicaldecoding.sgml +++ b/doc/src/sgml/logicaldecoding.sgml @@ -69,7 +69,7 @@ postgres=# SELECT slot_name, plugin, slot_type, database, active, restart_lsn, c postgres=# -- There are no changes to see yet postgres=# SELECT * FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL); - lsn | xid | data + lsn | xid | data -----+-----+------ (0 rows) @@ -78,7 +78,7 @@ CREATE TABLE postgres=# -- DDL isn't replicated, so all you'll see is the transaction postgres=# SELECT * FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL); - lsn | xid | data + lsn | xid | data -----------+-------+-------------- 0/BA2DA58 | 10297 | BEGIN 10297 0/BA5A5A0 | 10297 | COMMIT 10297 @@ -87,7 +87,7 @@ postgres=# SELECT * FROM pg_logical_slot_get_changes('regression_slot', NULL, NU postgres=# -- Once changes are read, they're consumed and not emitted postgres=# -- in a subsequent call: postgres=# SELECT * FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL); - lsn | xid | data + lsn | xid | data -----+-----+------ (0 rows) @@ -97,7 +97,7 @@ postgres=*# INSERT INTO data(data) VALUES('2'); postgres=*# COMMIT; postgres=# SELECT * FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL); - lsn | xid | data + lsn | xid | data -----------+-------+--------------------------------------------------------- 0/BA5A688 | 10298 | BEGIN 10298 0/BA5A6F0 | 10298 | table public.data: INSERT: id[integer]:1 data[text]:'1' @@ -109,7 +109,7 @@ postgres=# INSERT INTO data(data) VALUES('3'); postgres=# -- You can also peek ahead in the change stream without consuming changes postgres=# SELECT * FROM pg_logical_slot_peek_changes('regression_slot', NULL, NULL); - lsn | xid | data + lsn | xid | data -----------+-------+--------------------------------------------------------- 0/BA5A8E0 | 10299 | BEGIN 10299 0/BA5A8E0 | 10299 | table public.data: INSERT: id[integer]:3 data[text]:'3' @@ -118,7 +118,7 @@ postgres=# SELECT * FROM pg_logical_slot_peek_changes('regression_slot', NULL, N postgres=# -- The next call to pg_logical_slot_peek_changes() returns the same changes again postgres=# SELECT * FROM pg_logical_slot_peek_changes('regression_slot', NULL, NULL); - lsn | xid | data + lsn | xid | data -----------+-------+--------------------------------------------------------- 0/BA5A8E0 | 10299 | BEGIN 10299 0/BA5A8E0 | 10299 | table public.data: INSERT: id[integer]:3 data[text]:'3' @@ -127,7 +127,7 @@ postgres=# SELECT * FROM pg_logical_slot_peek_changes('regression_slot', NULL, N postgres=# -- options can be passed to output plugin, to influence the formatting postgres=# SELECT * FROM pg_logical_slot_peek_changes('regression_slot', NULL, NULL, 'include-timestamp', 'on'); - lsn | xid | data + lsn | xid | data -----------+-------+--------------------------------------------------------- 0/BA5A8E0 | 10299 | BEGIN 10299 0/BA5A8E0 | 10299 | table public.data: INSERT: id[integer]:3 data[text]:'3' @@ -200,7 +200,7 @@ postgres=*# INSERT INTO data(data) VALUES('5'); postgres=*# PREPARE TRANSACTION 'test_prepared1'; postgres=# SELECT * FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL); - lsn | xid | data + lsn | xid | data -----------+-----+--------------------------------------------------------- 0/1689DC0 | 529 | BEGIN 529 0/1689DC0 | 529 | table public.data: INSERT: id[integer]:3 data[text]:'5' @@ -209,7 +209,7 @@ postgres=# SELECT * FROM pg_logical_slot_get_changes('regression_slot', NULL, NU postgres=# COMMIT PREPARED 'test_prepared1'; postgres=# select * from pg_logical_slot_get_changes('regression_slot', NULL, NULL); - lsn | xid | data + lsn | xid | data -----------+-----+-------------------------------------------- 0/168A060 | 529 | COMMIT PREPARED 'test_prepared1', txid 529 (4 row) @@ -219,7 +219,7 @@ postgres=# BEGIN; postgres=*# INSERT INTO data(data) VALUES('6'); postgres=*# PREPARE TRANSACTION 'test_prepared2'; postgres=# select * from pg_logical_slot_get_changes('regression_slot', NULL, NULL); - lsn | xid | data + lsn | xid | data -----------+-----+--------------------------------------------------------- 0/168A180 | 530 | BEGIN 530 0/168A1E8 | 530 | table public.data: INSERT: id[integer]:4 data[text]:'6' @@ -228,7 +228,7 @@ postgres=# select * from pg_logical_slot_get_changes('regression_slot', NULL, NU postgres=# ROLLBACK PREPARED 'test_prepared2'; postgres=# select * from pg_logical_slot_get_changes('regression_slot', NULL, NULL); - lsn | xid | data + lsn | xid | data -----------+-----+---------------------------------------------- 0/168A4B8 | 530 | ROLLBACK PREPARED 'test_prepared2', txid 530 (1 row) @@ -850,7 +850,7 @@ typedef bool (*LogicalDecodeFilterPrepareCB) (struct LogicalDecodingContext *ctx <parameter>gid</parameter> field, which is part of the <parameter>txn</parameter> parameter, can be used in this callback to check if the plugin has already received this <command>PREPARE</command> - in which case it can either error out or skip the remaining changes of + in which case it can either error out or skip the remaining changes of the transaction. <programlisting> typedef void (*LogicalDecodeBeginPrepareCB) (struct LogicalDecodingContext *ctx, @@ -978,7 +978,7 @@ typedef void (*LogicalDecodeStreamCommitCB) (struct LogicalDecodingContext *ctx, </programlisting> </para> </sect3> - + <sect3 id="logicaldecoding-output-plugin-stream-change"> <title>Stream Change Callback</title> <para> diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 180798a6b95..56d9b375ec6 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -2302,7 +2302,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser <programlisting> SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event is NOT NULL; - pid | wait_event_type | wait_event + pid | wait_event_type | wait_event ------+-----------------+------------ 2540 | Lock | relation 6644 | LWLock | ProcArray diff --git a/doc/src/sgml/pageinspect.sgml b/doc/src/sgml/pageinspect.sgml index 55513cf522a..d4ee34ee0fd 100644 --- a/doc/src/sgml/pageinspect.sgml +++ b/doc/src/sgml/pageinspect.sgml @@ -492,7 +492,7 @@ test=# SELECT itemoffset, ctid, itemlen, nulls, vars, data, dead, htid, tids[0:2 not a valid <acronym>BRIN</acronym> page. For example: <screen> test=# SELECT brin_page_type(get_raw_page('brinidx', 0)); - brin_page_type + brin_page_type ---------------- meta </screen> @@ -514,7 +514,7 @@ test=# SELECT brin_page_type(get_raw_page('brinidx', 0)); about a <acronym>BRIN</acronym> index metapage. For example: <screen> test=# SELECT * FROM brin_metapage_info(get_raw_page('brinidx', 0)); - magic | version | pagesperrange | lastrevmappage + magic | version | pagesperrange | lastrevmappage ------------+---------+---------------+---------------- 0xA8109CFA | 1 | 4 | 2 </screen> @@ -537,7 +537,7 @@ test=# SELECT * FROM brin_metapage_info(get_raw_page('brinidx', 0)); For example: <screen> test=# SELECT * FROM brin_revmap_data(get_raw_page('brinidx', 2)) LIMIT 5; - pages + pages --------- (6,137) (6,138) @@ -565,13 +565,13 @@ test=# SELECT * FROM brin_revmap_data(get_raw_page('brinidx', 2)) LIMIT 5; test=# SELECT * FROM brin_page_items(get_raw_page('brinidx', 5), 'brinidx') ORDER BY blknum, attnum LIMIT 6; - itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value + itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value ------------+--------+--------+----------+----------+-------------+-------------- - 137 | 0 | 1 | t | f | f | + 137 | 0 | 1 | t | f | f | 137 | 0 | 2 | f | f | f | {1 .. 88} - 138 | 4 | 1 | t | f | f | + 138 | 4 | 1 | t | f | f | 138 | 4 | 2 | f | f | f | {89 .. 176} - 139 | 8 | 1 | t | f | f | + 139 | 8 | 1 | t | f | f | 139 | 8 | 2 | f | f | f | {177 .. 264} </screen> The returned columns correspond to the fields in the @@ -693,7 +693,7 @@ test=# SELECT first_tid, nbytes, tids[0:5] AS some_tids For example: <screen> test=# SELECT * FROM gist_page_opaque_info(get_raw_page('test_gist_idx', 2)); - lsn | nsn | rightlink | flags + lsn | nsn | rightlink | flags -----+-----+-----------+-------- 0/1 | 0/0 | 1 | {leaf} (1 row) @@ -716,7 +716,7 @@ test=# SELECT * FROM gist_page_opaque_info(get_raw_page('test_gist_idx', 2)); the data stored in a page of a <acronym>GiST</acronym> index. For example: <screen> test=# SELECT * FROM gist_page_items(get_raw_page('test_gist_idx', 0), 'test_gist_idx'); - itemoffset | ctid | itemlen | dead | keys + itemoffset | ctid | itemlen | dead | keys ------------+-----------+---------+------+------------------- 1 | (1,65535) | 40 | f | (p)=((166,166)) 2 | (2,65535) | 40 | f | (p)=((332,332)) @@ -747,7 +747,7 @@ test=# SELECT * FROM gist_page_items(get_raw_page('test_gist_idx', 0), 'test_gis example: <screen> test=# SELECT * FROM gist_page_items_bytea(get_raw_page('test_gist_idx', 0)); - itemoffset | ctid | itemlen | dead | key_data + itemoffset | ctid | itemlen | dead | key_data ------------+-----------+---------+------+-----------------------------------------&zwsp;------------------------------------------- 1 | (1,65535) | 40 | f | \x00000100ffff28000000000000c0644000000000&zwsp;00c06440000000000000f03f000000000000f03f 2 | (2,65535) | 40 | f | \x00000200ffff28000000000000c0744000000000&zwsp;00c074400000000000e064400000000000e06440 @@ -782,7 +782,7 @@ test=# SELECT * FROM gist_page_items_bytea(get_raw_page('test_gist_idx', 0)); the given <acronym>HASH</acronym> index page. For example: <screen> test=# SELECT hash_page_type(get_raw_page('con_hash_index', 0)); - hash_page_type + hash_page_type ---------------- metapage </screen> @@ -835,7 +835,7 @@ hasho_page_id | 65408 index page. For example: <screen> test=# SELECT * FROM hash_page_items(get_raw_page('con_hash_index', 1)) LIMIT 5; - itemoffset | ctid | data + itemoffset | ctid | data ------------+-----------+------------ 1 | (899,77) | 1053474816 2 | (897,29) | 1053474816 @@ -862,7 +862,7 @@ test=# SELECT * FROM hash_page_items(get_raw_page('con_hash_index', 1)) LIMIT 5; index. For example: <screen> test=# SELECT * FROM hash_bitmap_info('con_hash_index', 2052); - bitmapblkno | bitmapbit | bitstatus + bitmapblkno | bitmapbit | bitstatus -------------+-----------+----------- 65 | 3 | t </screen> diff --git a/doc/src/sgml/parallel.sgml b/doc/src/sgml/parallel.sgml index 13479d7e5e3..c37fb67065c 100644 --- a/doc/src/sgml/parallel.sgml +++ b/doc/src/sgml/parallel.sgml @@ -33,7 +33,7 @@ <screen> EXPLAIN SELECT * FROM pgbench_accounts WHERE filler LIKE '%x%'; - QUERY PLAN + QUERY PLAN -------------------------------------------------------------------&zwsp;------------------ Gather (cost=1000.00..217018.43 rows=1 width=97) Workers Planned: 2 diff --git a/doc/src/sgml/perform.sgml b/doc/src/sgml/perform.sgml index 9cf8ebea808..8fd8e25c515 100644 --- a/doc/src/sgml/perform.sgml +++ b/doc/src/sgml/perform.sgml @@ -1221,7 +1221,7 @@ ANALYZE zipcodes; SELECT stxname, stxkeys, stxddependencies FROM pg_statistic_ext join pg_statistic_ext_data on (oid = stxoid) WHERE stxname = 'stts'; - stxname | stxkeys | stxddependencies + stxname | stxkeys | stxddependencies ---------+---------+------------------------------------------ stts | 1 5 | {"1 => 5": 1.000000, "5 => 1": 0.423130} (1 row) @@ -1367,7 +1367,7 @@ ANALYZE zipcodes; SELECT m.* FROM pg_statistic_ext join pg_statistic_ext_data on (oid = stxoid), pg_mcv_list_items(stxdmcv) m WHERE stxname = 'stts3'; - index | values | nulls | frequency | base_frequency + index | values | nulls | frequency | base_frequency -------+------------------------+-------+-----------+---------------- 0 | {Washington, DC} | {f,f} | 0.003467 | 2.7e-05 1 | {Apo, AE} | {f,f} | 0.003067 | 1.9e-05 diff --git a/doc/src/sgml/pgfreespacemap.sgml b/doc/src/sgml/pgfreespacemap.sgml index 3063885c2cb..4dd7a084b9c 100644 --- a/doc/src/sgml/pgfreespacemap.sgml +++ b/doc/src/sgml/pgfreespacemap.sgml @@ -76,7 +76,7 @@ <screen> postgres=# SELECT * FROM pg_freespace('foo'); - blkno | avail + blkno | avail -------+------- 0 | 0 1 | 0 @@ -101,7 +101,7 @@ postgres=# SELECT * FROM pg_freespace('foo'); (20 rows) postgres=# SELECT * FROM pg_freespace('foo', 7); - pg_freespace + pg_freespace -------------- 1216 (1 row) diff --git a/doc/src/sgml/pgstatstatements.sgml b/doc/src/sgml/pgstatstatements.sgml index 45e720e995d..215419f23c7 100644 --- a/doc/src/sgml/pgstatstatements.sgml +++ b/doc/src/sgml/pgstatstatements.sgml @@ -948,7 +948,7 @@ query | SELECT pg_stat_statements_reset(0,0,0) calls | 1 total_exec_time | 0.189497 rows | 1 -hit_percent | +hit_percent | -[ RECORD 2 ]---+--------------------------------------------------&zwsp;--------------------------- query | SELECT query, calls, total_exec_time, rows, $1 * shared_blks_hit / + | nullif(shared_blks_hit + shared_blks_read, $2) AS hit_percent+ @@ -956,7 +956,7 @@ query | SELECT query, calls, total_exec_time, rows, $1 * shared_blks_h calls | 0 total_exec_time | 0 rows | 0 -hit_percent | +hit_percent | </screen> </sect2> diff --git a/doc/src/sgml/pgsurgery.sgml b/doc/src/sgml/pgsurgery.sgml index 134be9bebde..4bba14f217b 100644 --- a/doc/src/sgml/pgsurgery.sgml +++ b/doc/src/sgml/pgsurgery.sgml @@ -39,9 +39,9 @@ ERROR: could not access status of transaction 4007513275 DETAIL: Could not open file "pg_xact/0EED": No such file or directory. test=# select heap_force_kill('t1'::regclass, ARRAY['(0, 1)']::tid[]); - heap_force_kill + heap_force_kill ----------------- - + (1 row) test=# select * from t1 where ctid = '(0, 1)'; @@ -71,15 +71,15 @@ ERROR: found xmin 507 from before relfrozenxid 515 CONTEXT: while scanning block 0 of relation "public.t1" test=# select ctid from t1 where xmin = 507; - ctid + ctid ------- (0,3) (1 row) test=# select heap_force_freeze('t1'::regclass, ARRAY['(0, 3)']::tid[]); - heap_force_freeze + heap_force_freeze ------------------- - + (1 row) test=# select ctid from t1 where xmin = 2; diff --git a/doc/src/sgml/pgwalinspect.sgml b/doc/src/sgml/pgwalinspect.sgml index c1d4fbc66cd..de63a709654 100644 --- a/doc/src/sgml/pgwalinspect.sgml +++ b/doc/src/sgml/pgwalinspect.sgml @@ -108,7 +108,7 @@ follows: <screen> postgres=# select start_lsn, end_lsn, prev_lsn, xid, resource_manager, record_type, record_length, main_data_length, fpi_length, description from pg_get_wal_records_info('0/14F9A30', '0/15011D7'); - start_lsn | end_lsn | prev_lsn | xid | resource_manager | record_type | record_length | main_data_length | fpi_length | description + start_lsn | end_lsn | prev_lsn | xid | resource_manager | record_type | record_length | main_data_length | fpi_length | description -----------+-----------+-----------+-----+------------------+--------------+---------------+------------------+------------+--------------------- 0/14FA118 | 0/14FB4B0 | 0/14F9958 | 725 | Btree | INSERT_LEAF | 5013 | 2 | 4960 | off 246 0/14FB4B0 | 0/14FD050 | 0/14FA118 | 725 | Btree | INSERT_LEAF | 7045 | 2 | 6992 | off 130 @@ -189,7 +189,7 @@ postgres=# select start_lsn, end_lsn, prev_lsn, xid, resource_manager, record_ty follows: <screen> postgres=# select * from pg_get_wal_stats('0/12FBA30', '0/15011D7') where count > 0; - resource_manager/record_type | count | count_percentage | record_size | record_size_percentage | fpi_size | fpi_size_percentage | combined_size | combined_size_percentage + resource_manager/record_type | count | count_percentage | record_size | record_size_percentage | fpi_size | fpi_size_percentage | combined_size | combined_size_percentage ------------------------------+-------+------------------+-------------+------------------------+----------+---------------------+---------------+-------------------------- XLOG | 10 | 0.10871929 | 796 | 0.052369177 | 352 | 0.061031006 | 1148 | 0.054751817 Transaction | 187 | 2.0330508 | 62773 | 4.1298623 | 0 | 0 | 62773 | 2.9938467 @@ -206,7 +206,7 @@ With <replaceable>per_record</replaceable> passed as <literal>true</literal>: <screen> postgres=# select * from pg_get_wal_stats('0/14AFC30', '0/15011D7', true) where count > 0; - resource_manager/record_type | count | count_percentage | record_size | record_size_percentage | fpi_size | fpi_size_percentage | combined_size | combined_size_percentage + resource_manager/record_type | count | count_percentage | record_size | record_size_percentage | fpi_size | fpi_size_percentage | combined_size | combined_size_percentage ------------------------------+-------+------------------+-------------+------------------------+----------+---------------------+---------------+-------------------------- XLOG/CHECKPOINT_SHUTDOWN | 1 | 0.32894737 | 114 | 0.22891566 | 0 | 0 | 114 | 0.03534489 XLOG/CHECKPOINT_ONLINE | 4 | 1.3157895 | 456 | 0.91566265 | 0 | 0 | 456 | 0.14137957 diff --git a/doc/src/sgml/planstats.sgml b/doc/src/sgml/planstats.sgml index 78053d7c49f..df85ea5eea4 100644 --- a/doc/src/sgml/planstats.sgml +++ b/doc/src/sgml/planstats.sgml @@ -490,7 +490,7 @@ SELECT relpages, reltuples FROM pg_class WHERE relname = 't'; <programlisting> EXPLAIN (ANALYZE, TIMING OFF) SELECT * FROM t WHERE a = 1; - QUERY PLAN + QUERY PLAN -------------------------------------------------------------------&zwsp;------------ Seq Scan on t (cost=0.00..170.00 rows=100 width=8) (actual rows=100 loops=1) Filter: (a = 1) @@ -507,7 +507,7 @@ EXPLAIN (ANALYZE, TIMING OFF) SELECT * FROM t WHERE a = 1; <programlisting> EXPLAIN (ANALYZE, TIMING OFF) SELECT * FROM t WHERE a = 1 AND b = 1; - QUERY PLAN + QUERY PLAN -------------------------------------------------------------------&zwsp;---------- Seq Scan on t (cost=0.00..195.00 rows=1 width=8) (actual rows=100 loops=1) Filter: ((a = 1) AND (b = 1)) @@ -531,7 +531,7 @@ EXPLAIN (ANALYZE, TIMING OFF) SELECT * FROM t WHERE a = 1 AND b = 1; CREATE STATISTICS stts (dependencies) ON a, b FROM t; ANALYZE t; EXPLAIN (ANALYZE, TIMING OFF) SELECT * FROM t WHERE a = 1 AND b = 1; - QUERY PLAN + QUERY PLAN -------------------------------------------------------------------&zwsp;------------ Seq Scan on t (cost=0.00..195.00 rows=100 width=8) (actual rows=100 loops=1) Filter: ((a = 1) AND (b = 1)) @@ -552,7 +552,7 @@ EXPLAIN (ANALYZE, TIMING OFF) SELECT * FROM t WHERE a = 1 AND b = 1; accurate: <programlisting> EXPLAIN (ANALYZE, TIMING OFF) SELECT COUNT(*) FROM t GROUP BY a; - QUERY PLAN + QUERY PLAN -------------------------------------------------------------------&zwsp;---------------------- HashAggregate (cost=195.00..196.00 rows=100 width=12) (actual rows=100 loops=1) Group Key: a @@ -563,7 +563,7 @@ EXPLAIN (ANALYZE, TIMING OFF) SELECT COUNT(*) FROM t GROUP BY a; in the following example, is off by an order of magnitude: <programlisting> EXPLAIN (ANALYZE, TIMING OFF) SELECT COUNT(*) FROM t GROUP BY a, b; - QUERY PLAN + QUERY PLAN -------------------------------------------------------------------&zwsp;------------------------- HashAggregate (cost=220.00..230.00 rows=1000 width=16) (actual rows=100 loops=1) Group Key: a, b @@ -576,7 +576,7 @@ DROP STATISTICS stts; CREATE STATISTICS stts (dependencies, ndistinct) ON a, b FROM t; ANALYZE t; EXPLAIN (ANALYZE, TIMING OFF) SELECT COUNT(*) FROM t GROUP BY a, b; - QUERY PLAN + QUERY PLAN -------------------------------------------------------------------&zwsp;------------------------- HashAggregate (cost=220.00..221.00 rows=100 width=16) (actual rows=100 loops=1) Group Key: a, b @@ -637,7 +637,7 @@ EXPLAIN (ANALYZE, TIMING OFF) SELECT * FROM t WHERE a = 1 AND b = 1; <programlisting> SELECT m.* FROM pg_statistic_ext join pg_statistic_ext_data on (oid = stxoid), pg_mcv_list_items(stxdmcv) m WHERE stxname = 'stts2'; - index | values | nulls | frequency | base_frequency + index | values | nulls | frequency | base_frequency -------+----------+-------+-----------+---------------- 0 | {0, 0} | {f,f} | 0.01 | 0.0001 1 | {1, 1} | {f,f} | 0.01 | 0.0001 diff --git a/doc/src/sgml/plperl.sgml b/doc/src/sgml/plperl.sgml index 01f9870773d..627c7936fc9 100644 --- a/doc/src/sgml/plperl.sgml +++ b/doc/src/sgml/plperl.sgml @@ -709,7 +709,7 @@ SELECT init_hosts_query(); SELECT query_hosts('192.168.1.0/30'); SELECT release_hosts_query(); - query_hosts + query_hosts ----------------- (1,192.168.1.1) (2,192.168.1.2) diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index 7ebc6593f10..d9a74896d5c 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -5352,9 +5352,9 @@ WARNING: number of source and target fields in assignment does not match DETAIL: strict_multi_assignment check of extra_warnings is active. HINT: Make sure the query returns the exact list of columns. - foo + foo ----- - + (1 row) </programlisting> </para> diff --git a/doc/src/sgml/postgres-fdw.sgml b/doc/src/sgml/postgres-fdw.sgml index 1901736e600..b43d0aecbac 100644 --- a/doc/src/sgml/postgres-fdw.sgml +++ b/doc/src/sgml/postgres-fdw.sgml @@ -729,7 +729,7 @@ OPTIONS (ADD password_required 'false'); Example usage of the function: <screen> postgres=# SELECT * FROM postgres_fdw_get_connections() ORDER BY 1; - server_name | valid + server_name | valid -------------+------- loopback1 | t loopback2 | f @@ -754,7 +754,7 @@ postgres=# SELECT * FROM postgres_fdw_get_connections() ORDER BY 1; Example usage of the function: <screen> postgres=# SELECT postgres_fdw_disconnect('loopback1'); - postgres_fdw_disconnect + postgres_fdw_disconnect ------------------------- t </screen> @@ -775,7 +775,7 @@ postgres=# SELECT postgres_fdw_disconnect('loopback1'); Example usage of the function: <screen> postgres=# SELECT postgres_fdw_disconnect_all(); - postgres_fdw_disconnect_all + postgres_fdw_disconnect_all ----------------------------- t </screen> diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index 91eaaabc90f..d3102a87d92 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -649,9 +649,9 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class= <programlisting> postgres=# \d tab Table "public.tab" - Column | Type | Collation | Nullable | Default + Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- - col | integer | | | + col | integer | | | Indexes: "idx" btree (col) INVALID </programlisting> diff --git a/doc/src/sgml/ref/explain.sgml b/doc/src/sgml/ref/explain.sgml index 857c4e6e867..d4895b9d7d4 100644 --- a/doc/src/sgml/ref/explain.sgml +++ b/doc/src/sgml/ref/explain.sgml @@ -395,7 +395,7 @@ EXPLAIN (FORMAT YAML) SELECT * FROM foo WHERE i='4'; Total Cost: 5.98 + Plan Rows: 1 + Plan Width: 4 + - Index Cond: "(i = 4)" + Index Cond: "(i = 4)" (1 row) </programlisting> @@ -442,7 +442,7 @@ PREPARE query(int, int) AS SELECT sum(bar) FROM test EXPLAIN ANALYZE EXECUTE query(100, 200); - QUERY PLAN + QUERY PLAN -------------------------------------------------------------------&zwsp;----------------------------------------------------- HashAggregate (cost=9.54..9.54 rows=1 width=8) (actual time=0.156..0.161 rows=11 loops=1) Group Key: foo diff --git a/doc/src/sgml/ref/pgarchivecleanup.sgml b/doc/src/sgml/ref/pgarchivecleanup.sgml index e27db3c0773..635e7c76854 100644 --- a/doc/src/sgml/ref/pgarchivecleanup.sgml +++ b/doc/src/sgml/ref/pgarchivecleanup.sgml @@ -160,8 +160,7 @@ pg_archivecleanup: removing file "archive/00000001000000370000000E" <literal>never</literal>. </para> </refsect1> - - + <refsect1> <title>Notes</title> diff --git a/doc/src/sgml/ref/pgtestfsync.sgml b/doc/src/sgml/ref/pgtestfsync.sgml index 95be7a16d24..e811f80bf40 100644 --- a/doc/src/sgml/ref/pgtestfsync.sgml +++ b/doc/src/sgml/ref/pgtestfsync.sgml @@ -116,7 +116,7 @@ PostgreSQL documentation <literal>never</literal>. </para> </refsect1> - + <refsect1> <title>See Also</title> diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 592356019b5..8fc78707332 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -4992,7 +4992,7 @@ testdb=> <userinput>\d my_table</userinput> Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- first | integer | | not null | 0 - second | text | | | + second | text | | | </programlisting> Now we change the prompt to something more interesting: <programlisting> @@ -5123,7 +5123,7 @@ testdb=> <userinput>\df int*pl * bigint</userinput> with the <command>\crosstabview</command> command: <programlisting> testdb=> <userinput>SELECT first, second, first > 2 AS gt2 FROM my_table;</userinput> - first | second | gt2 + first | second | gt2 -------+--------+----- 1 | one | f 2 | two | f @@ -5132,11 +5132,11 @@ testdb=> <userinput>SELECT first, second, first > 2 AS gt2 FROM my_table;< (4 rows) testdb=> <userinput>\crosstabview first second</userinput> - first | one | two | three | four + first | one | two | three | four -------+-----+-----+-------+------ - 1 | f | | | - 2 | | f | | - 3 | | | t | + 1 | f | | | + 2 | | f | | + 3 | | | t | 4 | | | | t (4 rows) </programlisting> @@ -5148,7 +5148,7 @@ testdb=> <userinput>SELECT t1.first as "A", t2.first+100 AS "B", t1.first*(t2 testdb(> <userinput>row_number() over(order by t2.first) AS ord</userinput> testdb(> <userinput>FROM my_table t1 CROSS JOIN my_table t2 ORDER BY 1 DESC</userinput> testdb(> <userinput>\crosstabview "A" "B" "AxB" ord</userinput> - A | 101 | 102 | 103 | 104 + A | 101 | 102 | 103 | 104 ---+-----+-----+-----+----- 4 | 404 | 408 | 412 | 416 3 | 303 | 306 | 309 | 312 diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml index 6a0eca8b9ac..36cb4a455b7 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -309,7 +309,7 @@ REINDEX [ ( <replaceable class="parameter">option</replaceable> [, ...] ) ] { IN reindexed in a separate transaction. Those commands cannot be used inside a transaction block when working on a partitioned table or index. </para> - + <para> When using the <literal>TABLESPACE</literal> clause with <command>REINDEX</command> on a partitioned index or table, only the @@ -329,7 +329,7 @@ REINDEX [ ( <replaceable class="parameter">option</replaceable> [, ...] ) ] { IN will be generated. Indexes on TOAST tables are rebuilt, but not moved to the new tablespace. </para> - + <refsect2 id="sql-reindex-concurrently" xreflabel="Rebuilding Indexes Concurrently"> <title>Rebuilding Indexes Concurrently</title> diff --git a/doc/src/sgml/ref/rollback_to.sgml b/doc/src/sgml/ref/rollback_to.sgml index 3d5a241e1aa..27fa95cd1bc 100644 --- a/doc/src/sgml/ref/rollback_to.sgml +++ b/doc/src/sgml/ref/rollback_to.sgml @@ -112,14 +112,14 @@ DECLARE foo CURSOR FOR SELECT 1 UNION SELECT 2; SAVEPOINT foo; FETCH 1 FROM foo; - ?column? + ?column? ---------- 1 ROLLBACK TO SAVEPOINT foo; FETCH 1 FROM foo; - ?column? + ?column? ---------- 2 diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 8e5b83dfded..80bb8adcacc 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -1915,7 +1915,7 @@ SELECT * FROM t UNION ALL SELECT * FROM t - x + x -------------------- 0.534150459803641 0.520092216785997 diff --git a/doc/src/sgml/ref/set_role.sgml b/doc/src/sgml/ref/set_role.sgml index f02babf3af3..4e02322158a 100644 --- a/doc/src/sgml/ref/set_role.sgml +++ b/doc/src/sgml/ref/set_role.sgml @@ -115,7 +115,7 @@ RESET ROLE <programlisting> SELECT SESSION_USER, CURRENT_USER; - session_user | current_user + session_user | current_user --------------+-------------- peter | peter @@ -123,7 +123,7 @@ SET ROLE 'paul'; SELECT SESSION_USER, CURRENT_USER; - session_user | current_user + session_user | current_user --------------+-------------- peter | paul </programlisting> diff --git a/doc/src/sgml/ref/set_session_auth.sgml b/doc/src/sgml/ref/set_session_auth.sgml index e44e78ed8d6..f8fcafc1946 100644 --- a/doc/src/sgml/ref/set_session_auth.sgml +++ b/doc/src/sgml/ref/set_session_auth.sgml @@ -84,7 +84,7 @@ RESET SESSION AUTHORIZATION <programlisting> SELECT SESSION_USER, CURRENT_USER; - session_user | current_user + session_user | current_user --------------+-------------- peter | peter @@ -92,7 +92,7 @@ SET SESSION AUTHORIZATION 'paul'; SELECT SESSION_USER, CURRENT_USER; - session_user | current_user + session_user | current_user --------------+-------------- paul | paul </programlisting> diff --git a/doc/src/sgml/ref/show.sgml b/doc/src/sgml/ref/show.sgml index 93789ee0be0..b3747b119f9 100644 --- a/doc/src/sgml/ref/show.sgml +++ b/doc/src/sgml/ref/show.sgml @@ -167,7 +167,7 @@ SHOW geqo; Show all settings: <programlisting> SHOW ALL; - name | setting | description + name | setting | description -------------------------+---------+------------------------------------------------- allow_system_table_mods | off | Allows modifications of the structure of ... . diff --git a/doc/src/sgml/release-15.sgml b/doc/src/sgml/release-15.sgml index 4b78f0be91e..bee24b236a6 100644 --- a/doc/src/sgml/release-15.sgml +++ b/doc/src/sgml/release-15.sgml @@ -8,9 +8,9 @@ <title>Release date:</title> <para>2022-??-??</para> </formalpara> - + <para> This is just a placeholder for now. </para> - + </sect1> diff --git a/doc/src/sgml/rules.sgml b/doc/src/sgml/rules.sgml index 4b2ba5a4e6e..be3d17c8525 100644 --- a/doc/src/sgml/rules.sgml +++ b/doc/src/sgml/rules.sgml @@ -1010,7 +1010,7 @@ VACUUM ANALYZE wrd; <programlisting> SELECT count(*) FROM words WHERE word = 'caterpiler'; - count + count ------- 0 (1 row) @@ -1047,7 +1047,7 @@ SELECT count(*) FROM words WHERE word = 'caterpiler'; <programlisting> SELECT word FROM words ORDER BY word <-> 'caterpiler' LIMIT 10; - word + word --------------- cater caterpillar @@ -1337,7 +1337,7 @@ UPDATE shoelace_data SET sl_avail = 6 WHERE sl_name = 'sl7'; <programlisting> SELECT * FROM shoelace_log; - sl_name | sl_avail | log_who | log_when + sl_name | sl_avail | log_who | log_when ---------+----------+---------+---------------------------------- sl7 | 6 | Al | Tue Oct 20 16:14:45 1998 MET DST (1 row) @@ -1718,7 +1718,7 @@ SELECT * FROM shoelace ORDER BY sl_name; SELECT * FROM shoelace_log; - sl_name | sl_avail | log_who| log_when + sl_name | sl_avail | log_who| log_when ---------+----------+--------+---------------------------------- sl7 | 6 | Al | Tue Oct 20 19:14:45 1998 MET DST sl3 | 10 | Al | Tue Oct 20 19:25:16 1998 MET DST diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index d66560b587c..487ea58d895 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -2625,7 +2625,7 @@ LANGUAGE SQL IMMUTABLE STRICT; to functions in <productname>PostgreSQL</productname>. An example is: <screen> SELECT concat_lower_or_upper('Hello', 'World', true); - concat_lower_or_upper + concat_lower_or_upper ----------------------- HELLO WORLD (1 row) @@ -2635,7 +2635,7 @@ SELECT concat_lower_or_upper('Hello', 'World', true); Another example is: <screen> SELECT concat_lower_or_upper('Hello', 'World'); - concat_lower_or_upper + concat_lower_or_upper ----------------------- hello world (1 row) @@ -2661,7 +2661,7 @@ SELECT concat_lower_or_upper('Hello', 'World'); For example: <screen> SELECT concat_lower_or_upper(a => 'Hello', b => 'World'); - concat_lower_or_upper + concat_lower_or_upper ----------------------- hello world (1 row) @@ -2672,13 +2672,13 @@ SELECT concat_lower_or_upper(a => 'Hello', b => 'World'); order, for example: <screen> SELECT concat_lower_or_upper(a => 'Hello', b => 'World', uppercase => true); - concat_lower_or_upper + concat_lower_or_upper ----------------------- HELLO WORLD (1 row) SELECT concat_lower_or_upper(a => 'Hello', uppercase => true, b => 'World'); - concat_lower_or_upper + concat_lower_or_upper ----------------------- HELLO WORLD (1 row) @@ -2689,7 +2689,7 @@ SELECT concat_lower_or_upper(a => 'Hello', uppercase => true, b => 'Wor An older syntax based on ":=" is supported for backward compatibility: <screen> SELECT concat_lower_or_upper(a := 'Hello', uppercase := true, b := 'World'); - concat_lower_or_upper + concat_lower_or_upper ----------------------- HELLO WORLD (1 row) @@ -2711,7 +2711,7 @@ SELECT concat_lower_or_upper(a := 'Hello', uppercase := true, b := 'World'); For example: <screen> SELECT concat_lower_or_upper('Hello', 'World', uppercase => true); - concat_lower_or_upper + concat_lower_or_upper ----------------------- HELLO WORLD (1 row) diff --git a/doc/src/sgml/test-decoding.sgml b/doc/src/sgml/test-decoding.sgml index cf736bd41af..9b071954278 100644 --- a/doc/src/sgml/test-decoding.sgml +++ b/doc/src/sgml/test-decoding.sgml @@ -45,7 +45,7 @@ postgres=# SELECT * FROM pg_logical_slot_get_changes('test_slot', NULL, NULL, 'i <programlisting> postgres[33712]=#* SELECT * FROM pg_logical_slot_get_changes('test_slot', NULL, NULL, 'stream-changes', '1'); - lsn | xid | data + lsn | xid | data -----------+-----+-------------------------------------------------- 0/16B21F8 | 503 | opening a streamed block for transaction TXN 503 0/16B21F8 | 503 | streaming change for TXN 503 diff --git a/doc/src/sgml/textsearch.sgml b/doc/src/sgml/textsearch.sgml index 6afaf9e62c4..2cbf7e7d429 100644 --- a/doc/src/sgml/textsearch.sgml +++ b/doc/src/sgml/textsearch.sgml @@ -275,7 +275,7 @@ SELECT 'fat & cow'::tsquery @@ 'a fat cat sat on a mat and ate a fat rat'::t <programlisting> SELECT to_tsvector('fat cats ate fat rats') @@ to_tsquery('fat & rat'); - ?column? + ?column? ---------- t </programlisting> @@ -284,7 +284,7 @@ SELECT to_tsvector('fat cats ate fat rats') @@ to_tsquery('fat & rat'); <programlisting> SELECT 'fat cats ate fat rats'::tsvector @@ to_tsquery('fat & rat'); - ?column? + ?column? ---------- f </programlisting> @@ -335,12 +335,12 @@ text @@ text <programlisting> SELECT to_tsvector('fatal error') @@ to_tsquery('fatal <-> error'); - ?column? + ?column? ---------- t SELECT to_tsvector('error is not fatal') @@ to_tsquery('fatal <-> error'); - ?column? + ?column? ---------- f </programlisting> @@ -357,12 +357,12 @@ SELECT to_tsvector('error is not fatal') @@ to_tsquery('fatal <-> error'); <programlisting> SELECT phraseto_tsquery('cats ate rats'); - phraseto_tsquery + phraseto_tsquery ------------------------------- 'cat' <-> 'ate' <-> 'rat' SELECT phraseto_tsquery('the cats ate the rats'); - phraseto_tsquery + phraseto_tsquery ------------------------------- 'cat' <-> 'ate' <2> 'rat' </programlisting> @@ -828,7 +828,7 @@ to_tsquery(<optional> <replaceable class="parameter">config</replaceable> <type> <screen> SELECT to_tsquery('english', 'The & Fat & Rats'); - to_tsquery + to_tsquery --------------- 'fat' & 'rat' </screen> @@ -839,7 +839,7 @@ SELECT to_tsquery('english', 'The & Fat & Rats'); <screen> SELECT to_tsquery('english', 'Fat | Rats:AB'); - to_tsquery + to_tsquery ------------------ 'fat' | 'rat':AB </screen> @@ -848,7 +848,7 @@ SELECT to_tsquery('english', 'Fat | Rats:AB'); <screen> SELECT to_tsquery('supern:*A & star:A*B'); - to_tsquery + to_tsquery -------------------------- 'supern':*A & 'star':*AB </screen> @@ -897,7 +897,7 @@ plainto_tsquery(<optional> <replaceable class="parameter">config</replaceable> < <screen> SELECT plainto_tsquery('english', 'The Fat Rats'); - plainto_tsquery + plainto_tsquery ----------------- 'fat' & 'rat' </screen> @@ -908,7 +908,7 @@ SELECT plainto_tsquery('english', 'The Fat Rats'); <screen> SELECT plainto_tsquery('english', 'The Fat & Rats:C'); - plainto_tsquery + plainto_tsquery --------------------- 'fat' & 'rat' & 'c' </screen> @@ -1827,7 +1827,7 @@ CREATE TABLE aliases (t tsquery primary key, s tsquery); INSERT INTO aliases VALUES(to_tsquery('supernovae'), to_tsquery('supernovae|sn')); SELECT ts_rewrite(to_tsquery('supernovae & crab'), 'SELECT * FROM aliases'); - ts_rewrite + ts_rewrite --------------------------------- 'crab' & ( 'supernova' | 'sn' ) </screen> @@ -1840,7 +1840,7 @@ SET s = to_tsquery('supernovae|sn & !nebulae') WHERE t = to_tsquery('supernovae'); SELECT ts_rewrite(to_tsquery('supernovae & crab'), 'SELECT * FROM aliases'); - ts_rewrite + ts_rewrite --------------------------------------------- 'crab' & ( 'supernova' | 'sn' & !'nebula' ) </screen> @@ -1915,12 +1915,12 @@ tsvector_update_trigger(tsv, 'pg_catalog.english', title, body); INSERT INTO messages VALUES('title here', 'the body text is here'); SELECT * FROM messages; - title | body | tsv + title | body | tsv ------------+-----------------------+---------------------------- title here | the body text is here | 'bodi':4 'text':5 'titl':1 SELECT title, body FROM messages WHERE tsv @@ to_tsquery('title & body'); - title | body + title | body ------------+----------------------- title here | the body text is here </screen> @@ -2231,7 +2231,7 @@ LIMIT 10; <screen> SELECT alias, description, token FROM ts_debug('foo-bar-beta1'); - alias | description | token + alias | description | token -----------------+------------------------------------------+--------------- numhword | Hyphenated word, letters and digits | foo-bar-beta1 hword_asciipart | Hyphenated word part, all ASCII | foo @@ -2247,7 +2247,7 @@ SELECT alias, description, token FROM ts_debug('foo-bar-beta1'); <screen> SELECT alias, description, token FROM ts_debug('http://example.com/stuff/index.html'); - alias | description | token + alias | description | token ----------+---------------+------------------------------ protocol | Protocol head | http:// url | URL | example.com/stuff/index.html @@ -2571,7 +2571,7 @@ SELECT ts_lexize('public.simple_dict', 'The'); <screen> SELECT * FROM ts_debug('english', 'Paris'); - alias | description | token | dictionaries | dictionary | lexemes + alias | description | token | dictionaries | dictionary | lexemes -----------+-----------------+-------+----------------+--------------+--------- asciiword | Word, all ASCII | Paris | {english_stem} | english_stem | {pari} @@ -2585,7 +2585,7 @@ ALTER TEXT SEARCH CONFIGURATION english WITH my_synonym, english_stem; SELECT * FROM ts_debug('english', 'Paris'); - alias | description | token | dictionaries | dictionary | lexemes + alias | description | token | dictionaries | dictionary | lexemes -----------+-----------------+-------+---------------------------+------------+--------- asciiword | Word, all ASCII | Paris | {my_synonym,english_stem} | my_synonym | {paris} </screen> @@ -2654,7 +2654,7 @@ mydb=# SELECT to_tsquery('tst', 'indices'); (1 row) mydb=# SELECT 'indexes are very useful'::tsvector; - tsvector + tsvector --------------------------------- 'are' 'indexes' 'useful' 'very' (1 row) @@ -3355,31 +3355,31 @@ ts_debug(<optional> <replaceable class="parameter">config</replaceable> <type>re <screen> SELECT * FROM ts_debug('english', 'a fat cat sat on a mat - it ate a fat rats'); - alias | description | token | dictionaries | dictionary | lexemes + alias | description | token | dictionaries | dictionary | lexemes -----------+-----------------+-------+----------------+--------------+--------- asciiword | Word, all ASCII | a | {english_stem} | english_stem | {} - blank | Space symbols | | {} | | + blank | Space symbols | | {} | | asciiword | Word, all ASCII | fat | {english_stem} | english_stem | {fat} - blank | Space symbols | | {} | | + blank | Space symbols | | {} | | asciiword | Word, all ASCII | cat | {english_stem} | english_stem | {cat} - blank | Space symbols | | {} | | + blank | Space symbols | | {} | | asciiword | Word, all ASCII | sat | {english_stem} | english_stem | {sat} - blank | Space symbols | | {} | | + blank | Space symbols | | {} | | asciiword | Word, all ASCII | on | {english_stem} | english_stem | {} - blank | Space symbols | | {} | | + blank | Space symbols | | {} | | asciiword | Word, all ASCII | a | {english_stem} | english_stem | {} - blank | Space symbols | | {} | | + blank | Space symbols | | {} | | asciiword | Word, all ASCII | mat | {english_stem} | english_stem | {mat} - blank | Space symbols | | {} | | - blank | Space symbols | - | {} | | + blank | Space symbols | | {} | | + blank | Space symbols | - | {} | | asciiword | Word, all ASCII | it | {english_stem} | english_stem | {} - blank | Space symbols | | {} | | + blank | Space symbols | | {} | | asciiword | Word, all ASCII | ate | {english_stem} | english_stem | {ate} - blank | Space symbols | | {} | | + blank | Space symbols | | {} | | asciiword | Word, all ASCII | a | {english_stem} | english_stem | {} - blank | Space symbols | | {} | | + blank | Space symbols | | {} | | asciiword | Word, all ASCII | fat | {english_stem} | english_stem | {fat} - blank | Space symbols | | {} | | + blank | Space symbols | | {} | | asciiword | Word, all ASCII | rats | {english_stem} | english_stem | {rat} </screen> </para> @@ -3406,12 +3406,12 @@ ALTER TEXT SEARCH CONFIGURATION public.english <screen> SELECT * FROM ts_debug('public.english', 'The Brightest supernovaes'); - alias | description | token | dictionaries | dictionary | lexemes + alias | description | token | dictionaries | dictionary | lexemes -----------+-----------------+-------------+-------------------------------+----------------+------------- asciiword | Word, all ASCII | The | {english_ispell,english_stem} | english_ispell | {} - blank | Space symbols | | {} | | + blank | Space symbols | | {} | | asciiword | Word, all ASCII | Brightest | {english_ispell,english_stem} | english_ispell | {bright} - blank | Space symbols | | {} | | + blank | Space symbols | | {} | | asciiword | Word, all ASCII | supernovaes | {english_ispell,english_stem} | english_stem | {supernova} </screen> @@ -3445,12 +3445,12 @@ SELECT * FROM ts_debug('public.english', 'The Brightest supernovaes'); <screen> SELECT alias, token, dictionary, lexemes FROM ts_debug('public.english', 'The Brightest supernovaes'); - alias | token | dictionary | lexemes + alias | token | dictionary | lexemes -----------+-------------+----------------+------------- asciiword | The | english_ispell | {} - blank | | | + blank | | | asciiword | Brightest | english_ispell | {bright} - blank | | | + blank | | | asciiword | supernovaes | english_stem | {supernova} </screen> </para> @@ -3516,7 +3516,7 @@ ts_token_type(<replaceable class="parameter">parser_oid</replaceable> <type>oid< <screen> SELECT * FROM ts_token_type('default'); - tokid | alias | description + tokid | alias | description -------+-----------------+------------------------------------------ 1 | asciiword | Word, all ASCII 2 | word | Word, all letters @@ -3799,14 +3799,14 @@ SELECT plainto_tsquery('supernovae stars'); <screen> => \dF russian List of text search configurations - Schema | Name | Description + Schema | Name | Description ------------+---------+------------------------------------ pg_catalog | russian | configuration for russian language => \dF+ russian Text search configuration "pg_catalog.russian" Parser: "pg_catalog.default" - Token | Dictionaries + Token | Dictionaries -----------------+-------------- asciihword | english_stem asciiword | english_stem @@ -3884,21 +3884,21 @@ Parser: "pg_catalog.default" <screen> => \dFp List of text search parsers - Schema | Name | Description + Schema | Name | Description ------------+---------+--------------------- pg_catalog | default | default word parser => \dFp+ Text search parser "pg_catalog.default" - Method | Function | Description + Method | Function | Description -----------------+----------------+------------- - Start parse | prsd_start | - Get next token | prsd_nexttoken | - End parse | prsd_end | - Get headline | prsd_headline | - Get token types | prsd_lextype | + Start parse | prsd_start | + Get next token | prsd_nexttoken | + End parse | prsd_end | + Get headline | prsd_headline | + Get token types | prsd_lextype | Token types for parser "pg_catalog.default" - Token name | Description + Token name | Description -----------------+------------------------------------------ asciihword | Hyphenated word, all ASCII asciiword | Word, all ASCII @@ -3937,7 +3937,7 @@ Parser: "pg_catalog.default" <screen> => \dFt List of text search templates - Schema | Name | Description + Schema | Name | Description ------------+-----------+----------------------------------------------------------- pg_catalog | ispell | ispell dictionary pg_catalog | simple | simple dictionary: just lower case and check for stopword diff --git a/doc/src/sgml/xaggr.sgml b/doc/src/sgml/xaggr.sgml index 93f1155ab97..bdad8d3dc2b 100644 --- a/doc/src/sgml/xaggr.sgml +++ b/doc/src/sgml/xaggr.sgml @@ -322,7 +322,7 @@ SELECT attrelid::regclass, array_accum(attname) WHERE attnum > 0 AND attrelid = 'pg_tablespace'::regclass GROUP BY attrelid; - attrelid | array_accum + attrelid | array_accum ---------------+--------------------------------------- pg_tablespace | {spcname,spcowner,spcacl,spcoptions} (1 row) @@ -332,7 +332,7 @@ SELECT attrelid::regclass, array_accum(atttypid::regtype) WHERE attnum > 0 AND attrelid = 'pg_tablespace'::regclass GROUP BY attrelid; - attrelid | array_accum + attrelid | array_accum ---------------+--------------------------- pg_tablespace | {name,oid,aclitem[],text[]} (1 row) diff --git a/doc/src/sgml/xfunc.sgml b/doc/src/sgml/xfunc.sgml index fb8255f136e..07c5fd198b2 100644 --- a/doc/src/sgml/xfunc.sgml +++ b/doc/src/sgml/xfunc.sgml @@ -836,7 +836,7 @@ CREATE FUNCTION mleast(VARIADIC arr numeric[]) RETURNS numeric AS $$ $$ LANGUAGE SQL; SELECT mleast(10, -1, 5, 4.4); - mleast + mleast -------- -1 (1 row) @@ -942,19 +942,19 @@ AS $$ $$; SELECT foo(10, 20, 30); - foo + foo ----- 60 (1 row) SELECT foo(10, 20); - foo + foo ----- 33 (1 row) SELECT foo(10); - foo + foo ----- 15 (1 row) @@ -1387,7 +1387,7 @@ SELECT make_array2(1, 2.5) AS numericarray; also works: <screen> SELECT make_array2('a', 'b') AS textarray; - textarray + textarray ----------- {a,b} (1 row) @@ -1440,13 +1440,13 @@ CREATE FUNCTION anyleast (VARIADIC anyarray) RETURNS anyelement AS $$ $$ LANGUAGE SQL; SELECT anyleast(10, -1, 5, 4); - anyleast + anyleast ---------- -1 (1 row) SELECT anyleast('abc'::text, 'def'); - anyleast + anyleast ---------- abc (1 row) @@ -1456,7 +1456,7 @@ CREATE FUNCTION concat_values(text, VARIADIC anyarray) RETURNS text AS $$ $$ LANGUAGE SQL; SELECT concat_values('|', 1, 4, 2); - concat_values + concat_values --------------- 1|4|2 (1 row) |