← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/btree-gin.html

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
Import upstream version 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/src/sgml/html/btree-gin.html
 
1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 
2
<HTML
 
3
><HEAD
 
4
><TITLE
 
5
>btree_gin</TITLE
 
6
><META
 
7
NAME="GENERATOR"
 
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
 
9
REV="MADE"
 
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
 
11
REL="HOME"
 
12
TITLE="PostgreSQL 9.1beta1 Documentation"
 
13
HREF="index.html"><LINK
 
14
REL="UP"
 
15
TITLE="Additional Supplied Modules"
 
16
HREF="contrib.html"><LINK
 
17
REL="PREVIOUS"
 
18
TITLE="auto_explain"
 
19
HREF="auto-explain.html"><LINK
 
20
REL="NEXT"
 
21
TITLE="btree_gist"
 
22
HREF="btree-gist.html"><LINK
 
23
REL="STYLESHEET"
 
24
TYPE="text/css"
 
25
HREF="stylesheet.css"><META
 
26
HTTP-EQUIV="Content-Type"
 
27
CONTENT="text/html; charset=ISO-8859-1"><META
 
28
NAME="creation"
 
29
CONTENT="2011-04-27T21:20:33"></HEAD
 
30
><BODY
 
31
CLASS="SECT1"
 
32
><DIV
 
33
CLASS="NAVHEADER"
 
34
><TABLE
 
35
SUMMARY="Header navigation table"
 
36
WIDTH="100%"
 
37
BORDER="0"
 
38
CELLPADDING="0"
 
39
CELLSPACING="0"
 
40
><TR
 
41
><TH
 
42
COLSPAN="5"
 
43
ALIGN="center"
 
44
VALIGN="bottom"
 
45
><A
 
46
HREF="index.html"
 
47
>PostgreSQL 9.1beta1 Documentation</A
 
48
></TH
 
49
></TR
 
50
><TR
 
51
><TD
 
52
WIDTH="10%"
 
53
ALIGN="left"
 
54
VALIGN="top"
 
55
><A
 
56
TITLE="auto_explain"
 
57
HREF="auto-explain.html"
 
58
ACCESSKEY="P"
 
59
>Prev</A
 
60
></TD
 
61
><TD
 
62
WIDTH="10%"
 
63
ALIGN="left"
 
64
VALIGN="top"
 
65
><A
 
66
TITLE="Additional Supplied Modules"
 
67
HREF="contrib.html"
 
68
>Fast Backward</A
 
69
></TD
 
70
><TD
 
71
WIDTH="60%"
 
72
ALIGN="center"
 
73
VALIGN="bottom"
 
74
>Appendix F. Additional Supplied Modules</TD
 
75
><TD
 
76
WIDTH="10%"
 
77
ALIGN="right"
 
78
VALIGN="top"
 
79
><A
 
80
TITLE="Additional Supplied Modules"
 
81
HREF="contrib.html"
 
82
>Fast Forward</A
 
83
></TD
 
84
><TD
 
85
WIDTH="10%"
 
86
ALIGN="right"
 
87
VALIGN="top"
 
88
><A
 
89
TITLE="btree_gist"
 
90
HREF="btree-gist.html"
 
91
ACCESSKEY="N"
 
92
>Next</A
 
93
></TD
 
94
></TR
 
95
></TABLE
 
96
><HR
 
97
ALIGN="LEFT"
 
98
WIDTH="100%"></DIV
 
99
><DIV
 
100
CLASS="SECT1"
 
101
><H1
 
102
CLASS="SECT1"
 
103
><A
 
104
NAME="BTREE-GIN"
 
105
>F.4. btree_gin</A
 
106
></H1
 
107
><P
 
108
>  <TT
 
109
CLASS="FILENAME"
 
110
>btree_gin</TT
 
111
> provides sample GIN operator classes that
 
112
  implement B-tree equivalent behavior for the data types
 
113
  <TT
 
114
CLASS="TYPE"
 
115
>int2</TT
 
116
>, <TT
 
117
CLASS="TYPE"
 
118
>int4</TT
 
119
>, <TT
 
120
CLASS="TYPE"
 
121
>int8</TT
 
122
>, <TT
 
123
CLASS="TYPE"
 
124
>float4</TT
 
125
>,
 
126
  <TT
 
127
CLASS="TYPE"
 
128
>float8</TT
 
129
>, <TT
 
130
CLASS="TYPE"
 
131
>timestamp with time zone</TT
 
132
>,
 
133
  <TT
 
134
CLASS="TYPE"
 
135
>timestamp without time zone</TT
 
136
>, <TT
 
137
CLASS="TYPE"
 
138
>time with time zone</TT
 
139
>,
 
140
  <TT
 
141
CLASS="TYPE"
 
142
>time without time zone</TT
 
143
>, <TT
 
144
CLASS="TYPE"
 
145
>date</TT
 
146
>, <TT
 
147
CLASS="TYPE"
 
148
>interval</TT
 
149
>,
 
150
  <TT
 
151
CLASS="TYPE"
 
152
>oid</TT
 
153
>, <TT
 
154
CLASS="TYPE"
 
155
>money</TT
 
156
>, <TT
 
157
CLASS="TYPE"
 
158
>"char"</TT
 
159
>,
 
160
  <TT
 
161
CLASS="TYPE"
 
162
>varchar</TT
 
163
>, <TT
 
164
CLASS="TYPE"
 
165
>text</TT
 
166
>, <TT
 
167
CLASS="TYPE"
 
168
>bytea</TT
 
169
>, <TT
 
170
CLASS="TYPE"
 
171
>bit</TT
 
172
>,
 
173
  <TT
 
174
CLASS="TYPE"
 
175
>varbit</TT
 
176
>, <TT
 
177
CLASS="TYPE"
 
178
>macaddr</TT
 
179
>, <TT
 
180
CLASS="TYPE"
 
181
>inet</TT
 
182
>, and <TT
 
183
CLASS="TYPE"
 
184
>cidr</TT
 
185
>.
 
186
 </P
 
187
><P
 
188
>  In general, these operator classes will not outperform the equivalent
 
189
  standard B-tree index methods, and they lack one major feature of the
 
190
  standard B-tree code: the ability to enforce uniqueness.  However,
 
191
  they are useful for GIN testing and as a base for developing other
 
192
  GIN operator classes.  Also, for queries that test both a GIN-indexable
 
193
  column and a B-tree-indexable column, it might be more efficient to create
 
194
  a multicolumn GIN index that uses one of these operator classes than to create
 
195
  two separate indexes that would have to be combined via bitmap ANDing.
 
196
 </P
 
197
><DIV
 
198
CLASS="SECT2"
 
199
><H2
 
200
CLASS="SECT2"
 
201
><A
 
202
NAME="AEN128509"
 
203
>F.4.1. Example Usage</A
 
204
></H2
 
205
><PRE
 
206
CLASS="PROGRAMLISTING"
 
207
>CREATE TABLE test (a int4);
 
208
-- create index
 
209
CREATE INDEX testidx ON test USING gin (a);
 
210
-- query
 
211
SELECT * FROM test WHERE a &lt; 10;</PRE
 
212
></DIV
 
213
><DIV
 
214
CLASS="SECT2"
 
215
><H2
 
216
CLASS="SECT2"
 
217
><A
 
218
NAME="AEN128512"
 
219
>F.4.2. Authors</A
 
220
></H2
 
221
><P
 
222
>   Teodor Sigaev (<CODE
 
223
CLASS="EMAIL"
 
224
>&#60;<A
 
225
HREF="mailto:teodor@stack.net"
 
226
>teodor@stack.net</A
 
227
>&#62;</CODE
 
228
>) and
 
229
   Oleg Bartunov (<CODE
 
230
CLASS="EMAIL"
 
231
>&#60;<A
 
232
HREF="mailto:oleg@sai.msu.su"
 
233
>oleg@sai.msu.su</A
 
234
>&#62;</CODE
 
235
>).  See
 
236
   <A
 
237
HREF="http://www.sai.msu.su/~megera/oddmuse/index.cgi/Gin"
 
238
TARGET="_top"
 
239
>http://www.sai.msu.su/~megera/oddmuse/index.cgi/Gin</A
 
240
>
 
241
   for additional information.
 
242
  </P
 
243
></DIV
 
244
></DIV
 
245
><DIV
 
246
CLASS="NAVFOOTER"
 
247
><HR
 
248
ALIGN="LEFT"
 
249
WIDTH="100%"><TABLE
 
250
SUMMARY="Footer navigation table"
 
251
WIDTH="100%"
 
252
BORDER="0"
 
253
CELLPADDING="0"
 
254
CELLSPACING="0"
 
255
><TR
 
256
><TD
 
257
WIDTH="33%"
 
258
ALIGN="left"
 
259
VALIGN="top"
 
260
><A
 
261
HREF="auto-explain.html"
 
262
ACCESSKEY="P"
 
263
>Prev</A
 
264
></TD
 
265
><TD
 
266
WIDTH="34%"
 
267
ALIGN="center"
 
268
VALIGN="top"
 
269
><A
 
270
HREF="index.html"
 
271
ACCESSKEY="H"
 
272
>Home</A
 
273
></TD
 
274
><TD
 
275
WIDTH="33%"
 
276
ALIGN="right"
 
277
VALIGN="top"
 
278
><A
 
279
HREF="btree-gist.html"
 
280
ACCESSKEY="N"
 
281
>Next</A
 
282
></TD
 
283
></TR
 
284
><TR
 
285
><TD
 
286
WIDTH="33%"
 
287
ALIGN="left"
 
288
VALIGN="top"
 
289
>auto_explain</TD
 
290
><TD
 
291
WIDTH="34%"
 
292
ALIGN="center"
 
293
VALIGN="top"
 
294
><A
 
295
HREF="contrib.html"
 
296
ACCESSKEY="U"
 
297
>Up</A
 
298
></TD
 
299
><TD
 
300
WIDTH="33%"
 
301
ALIGN="right"
 
302
VALIGN="top"
 
303
>btree_gist</TD
 
304
></TR
 
305
></TABLE
 
306
></DIV
 
307
></BODY
 
308
></HTML
 
309
>
 
 
b'\\ No newline at end of file'