-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathbrin-builtin-opclasses.html
More file actions
215 lines (215 loc) · 14.3 KB
/
brin-builtin-opclasses.html
File metadata and controls
215 lines (215 loc) · 14.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>67.2. 組み込み演算子クラス</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets V1.79.1" /><link rel="prev" href="brin-intro.html" title="67.1. はじめに" /><link rel="next" href="brin-extensibility.html" title="67.3. 拡張性" /><meta name="viewport" content="width=device-width,initial-scale=1.0" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="4" align="center"><a accesskey="h" href="index.html">PostgreSQL 12.4文書</a></th></tr><tr><td width="10%" align="left"></td><td width="10%" align="left"></td><td width="60%" align="center"><a href="brin.html" title="第67章 BRINインデックス">第67章 BRINインデックス</a></td><td width="20%" align="right"><div class="actions"><a class="issue" title="github" href="https://github.com/pgsql-jp/jpug-doc/issues/new?title=version 12.4 brin-builtin-opclasses.html">誤訳等の報告
</a></div></td></tr><tr><td width="10%" align="left"><a accesskey="p" href="brin-intro.html" title="67.1. はじめに">前へ</a> </td><td width="10%" align="left"><a accesskey="u" href="brin.html" title="第67章 BRINインデックス">上へ</a></td><td width="60%" align="center">67.2. 組み込み演算子クラス</td><td width="20%" align="right"> <a accesskey="n" href="brin-extensibility.html" title="67.3. 拡張性">次へ</a></td></tr></table><hr /></div><div class="sect1" id="BRIN-BUILTIN-OPCLASSES"><div class="titlepage"><div><div><h2 class="title" style="clear: both">67.2. 組み込み演算子クラス</h2></div></div></div><span class="original">
<title>Built-in Operator Classes</title>
</span><p>
<span class="original">
The core <productname>PostgreSQL</productname> distribution
includes the <acronym>BRIN</acronym> operator classes shown in
<xref linkend="brin-builtin-opclasses-table"/>.
</span>
<span class="productname">PostgreSQL</span>のコア配布物には、<a class="xref" href="brin-builtin-opclasses.html#BRIN-BUILTIN-OPCLASSES-TABLE" title="表67.1 組み込みBRIN演算子クラス">表 67.1</a>で示される<acronym class="acronym">BRIN</acronym>演算子クラスが含まれます。
</p><p>
<span class="original">
The <firstterm>minmax</firstterm>
operator classes store the minimum and the maximum values appearing
in the indexed column within the range. The <firstterm>inclusion</firstterm>
operator classes store a value which includes the values in the indexed
column within the range.
</span>
<em class="firstterm">minmax</em>演算子クラスは、インデックスが貼られた列の範囲内に現れる最小値と最大値を格納します。
<em class="firstterm">inclusion</em>演算子クラスは、インデックスが貼られた列の範囲内に含まれる値を格納します。
</p><div class="table" id="BRIN-BUILTIN-OPCLASSES-TABLE"><p class="title"><strong>表67.1 組み込み<acronym class="acronym">BRIN</acronym>演算子クラス</strong></p><div class="table-contents"><span class="original">
<title>Built-in <acronym>BRIN</acronym> Operator Classes</title>
</span><table class="table" summary="組み込みBRIN演算子クラス" border="1"><colgroup><col /><col /><col /></colgroup><thead><tr><th>名前</th><th>インデックスされるデータ型</th><th>インデックス可能な演算子</th></tr></thead><tbody><tr><td><code class="literal">int8_minmax_ops</code></td><td><code class="type">bigint</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">bit_minmax_ops</code></td><td><code class="type">bit</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">varbit_minmax_ops</code></td><td><code class="type">bit varying</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">box_inclusion_ops</code></td><td><code class="type">box</code></td><td>
<code class="literal"><<</code>
<code class="literal">&<</code>
<code class="literal">&&</code>
<code class="literal">&></code>
<code class="literal">>></code>
<code class="literal">~=</code>
<code class="literal">@></code>
<code class="literal"><@</code>
<code class="literal">&<|</code>
<code class="literal"><<|</code>
<code class="literal">|>></code>
<code class="literal">|&></code>
</td></tr><tr><td><code class="literal">bytea_minmax_ops</code></td><td><code class="type">bytea</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">bpchar_minmax_ops</code></td><td><code class="type">character</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">char_minmax_ops</code></td><td><code class="type">"char"</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">date_minmax_ops</code></td><td><code class="type">date</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">float8_minmax_ops</code></td><td><code class="type">double precision</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">inet_minmax_ops</code></td><td><code class="type">inet</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">network_inclusion_ops</code></td><td><code class="type">inet</code></td><td>
<code class="literal">&&</code>
<code class="literal">>>=</code>
<code class="literal"><<=</code>
<code class="literal">=</code>
<code class="literal">>></code>
<code class="literal"><<</code>
</td></tr><tr><td><code class="literal">int4_minmax_ops</code></td><td><code class="type">integer</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">interval_minmax_ops</code></td><td><code class="type">interval</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">macaddr_minmax_ops</code></td><td><code class="type">macaddr</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">macaddr8_minmax_ops</code></td><td><code class="type">macaddr8</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">name_minmax_ops</code></td><td><code class="type">name</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">numeric_minmax_ops</code></td><td><code class="type">numeric</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">pg_lsn_minmax_ops</code></td><td><code class="type">pg_lsn</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">oid_minmax_ops</code></td><td><code class="type">oid</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">range_inclusion_ops</code></td><td><code class="type">any range type</code></td><td>
<code class="literal"><<</code>
<code class="literal">&<</code>
<code class="literal">&&</code>
<code class="literal">&></code>
<code class="literal">>></code>
<code class="literal">@></code>
<code class="literal"><@</code>
<code class="literal">-|-</code>
<code class="literal">=</code>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">></code>
<code class="literal">>=</code>
</td></tr><tr><td><code class="literal">float4_minmax_ops</code></td><td><code class="type">real</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">int2_minmax_ops</code></td><td><code class="type">smallint</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">text_minmax_ops</code></td><td><code class="type">text</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">tid_minmax_ops</code></td><td><code class="type">tid</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">timestamp_minmax_ops</code></td><td><code class="type">timestamp without time zone</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">timestamptz_minmax_ops</code></td><td><code class="type">timestamp with time zone</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">time_minmax_ops</code></td><td><code class="type">time without time zone</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">timetz_minmax_ops</code></td><td><code class="type">time with time zone</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr><tr><td><code class="literal">uuid_minmax_ops</code></td><td><code class="type">uuid</code></td><td>
<code class="literal"><</code>
<code class="literal"><=</code>
<code class="literal">=</code>
<code class="literal">>=</code>
<code class="literal">></code>
</td></tr></tbody></table></div></div><br class="table-break" /></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="brin-intro.html">前へ</a> </td><td width="20%" align="center"><a accesskey="u" href="brin.html">上へ</a></td><td width="40%" align="right"> <a accesskey="n" href="brin-extensibility.html">次へ</a></td></tr><tr><td width="40%" align="left" valign="top">67.1. はじめに </td><td width="20%" align="center"><a accesskey="h" href="index.html">ホーム</a></td><td width="40%" align="right" valign="top"> 67.3. 拡張性</td></tr></table></div></body></html>