8000 pageinspect/BRIN: minor tweaks · postgrespro/postgres@b52cb46 · GitHub
[go: up one dir, main page]
Skip to content

Commit b52cb46

Browse files
alvherrealvherre
committed
pageinspect/BRIN: minor tweaks
Michael Paquier Double-dash additions suggested by Peter Geoghegan
1 parent 3325624 commit b52cb46

File tree

3 files changed

+8
-6
lines changed

3 files changed

+8
-6
lines changed

‎contrib/pageinspect/pageinspect--1.2--1.3.sql

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -21,6 +21,7 @@ LANGUAGE C STRICT;
2121

2222
--
2323
-- brin_revmap_data()
24+
--
2425
CREATE FUNCTION brin_revmap_data(IN page bytea,
2526
OUT pages tid)
2627
RETURNS SETOF tid

‎contrib/pageinspect/pageinspect--1.3.sql

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -116,6 +116,7 @@ LANGUAGE C STRICT;
116116

117117
--
118118
-- brin_revmap_data()
119+
--
119120
CREATE FUNCTION brin_revmap_data(IN page bytea,
120121
OUT pages tid)
121122
RETURNS SETOF tid

‎doc/src/sgml/pageinspect.sgml

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -210,7 +210,7 @@ test=# SELECT * FROM bt_page_items('pg_cast_oid_index', 1);
210210
<acronym>BRIN</acronym> index page, or throws an error if the page is
211211
not a valid <acronym>BRIN</acronym> page. For example:
212212
<screen>
213-
brintest=# select brin_page_type(get_raw_page('brinidx', 0));
213+
test=# SELECT brin_page_type(get_raw_page('brinidx', 0));
214214
brin_page_type
215215
----------------
216216
meta
@@ -232,7 +232,7 @@ brintest=# select brin_page_type(get_raw_page('brinidx', 0));
232232
<function>brin_metapage_info</function> returns assorted information
233233
about a <acronym>BRIN</acronym> index metapage. For example:
234234
<screen>
235-
brintest=# select * from brin_metapage_info(get_raw_page(&# 8000 39;brinidx', 0));
235+
test=# SELECT * FROM brin_metapage_info(get_raw_page('brinidx', 0));
236236
magic | version | pagesperrange | lastrevmappage
237237
------------+---------+---------------+----------------
238238
0xA8109CFA | 1 | 4 | 2
@@ -255,7 +255,7 @@ brintest=# select * from brin_metapage_info(get_raw_page('brinidx', 0));
255255
identifiers in a <acronym>BRIN</acronym> index range map page.
256256
For example:
257257
<screen>
258-
brintest=# select * from brin_revmap_data(get_raw_page('brinidx', 2)) limit 5;
258+
test=# SELECT * FROM brin_revmap_data(get_raw_page('brinidx', 2)) limit 5;
259259
pages
260260
---------
261261
(6,137)
@@ -281,9 +281,9 @@ brintest=# select * from brin_revmap_data(get_raw_page('brinidx', 2)) limit 5;
281281
<function>brin_page_items</function> returns the data stored in the
282282
<acronym>BRIN</acronym> data page. For example:
283283
<screen>
284-
brintest=# select * from brin_page_items(get_raw_page('brinidx', 5),
285-
brintest(# 'brinidx')
286-
brintest-# order by blknum, attnum limit 6;
284+
test=# SELECT * FROM brin_page_items(get_raw_page('brinidx', 5),
285+
'brinidx')
286+
ORDER BY blknum, attnum LIMIT 6;
287287
itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
288288
------------+--------+--------+----------+----------+-------------+--------------
289289
137 | 0 | 1 | t | f | f |

0 commit comments

Comments
 (0)
0