GiST Indexes: Built-in Operator Classes

59.2. Built-in Operator Classes

The core PostgreSQL distribution includes the GiST operator classes shown in Table 59-1. (Some of the optional modules described in Appendix F provide additional GiST operator classes.)

Table 59-1. Built-in GiST Operator Classes

Name Indexed Data Type Indexable Operators Ordering Operators
box_ops box && &> &< &<| >> << <<| <@ @> @ |&> |>> ~ ~=
circle_ops circle && &> &< &<| >> << <<| <@ @> @ |&> |>> ~ ~= <->
inet_ops inet, cidr && >> >>= > >= <> << <<= < <= =
point_ops point >> >^ << <@ <@ <@ <^ ~= <->
poly_ops polygon && &> &< &<| >> << <<| <@ @> @ |&> |>> ~ ~= <->
range_ops any range type && &> &< >> << <@ -|- = @> @>
tsquery_ops tsquery <@ @>
tsvector_ops tsvector @@

For historical reasons, the inet_ops operator class is not the default class for types inet and cidr. To use it, mention the class name in CREATE INDEX, for example

CREATE INDEX ON my_table USING GIST (my_inet_column inet_ops);

© 1996–2017 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/9.5/static/gist-builtin-opclasses.html

在线笔记
App下载
App下载

扫描二维码

下载编程狮App

公众号
微信公众号

编程狮公众号

意见反馈
返回顶部