Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitb52cb46

Browse files
committed
pageinspect/BRIN: minor tweaks
Michael PaquierDouble-dash additions suggested by Peter Geoghegan
1 parent3325624 commitb52cb46

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
CREATEFUNCTIONbrin_revmap_data(IN pagebytea,
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
CREATEFUNCTIONbrin_revmap_data(IN pagebytea,
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('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 byblknum, attnumlimit 6;
284+
test=#SELECT *FROM brin_page_items(get_raw_page('brinidx', 5),
285+
'brinidx')
286+
ORDER BYblknum, attnumLIMIT 6;
287287
itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | value
288288
------------+--------+--------+----------+----------+-------------+--------------
289289
137 | 0 | 1 | t | f | f |

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp