Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
62.2. Built-in Operator Classes
Prev UpChapter 62. GiST IndexesHome Next

62.2. Built-in Operator Classes

The corePostgreSQL distribution includes theGiST operator classes shown inTable 62.1. (Some of the optional modules described inAppendix F provide additionalGiST operator classes.)

Table 62.1. Built-inGiST Operator Classes

NameIndexed Data TypeIndexable OperatorsOrdering Operators
box_opsbox&&&>&<&<|>><<<<|<@@>@|&>|>>~~=
circle_opscircle&&&>&<&<|>><<<<|<@@>@|&>|>>~~=<->
inet_opsinet,cidr&&>>>>=>>=<><<<<=<<==
point_opspoint>>>^<<<@<@<@<^~=<->
poly_opspolygon&&&>&<&<|>><<<<|<@@>@|&>|>>~~=<->
range_opsany range type&&&>&<>><<<@-|-=@>@>
tsquery_opstsquery<@@>
tsvector_opstsvector@@

For historical reasons, theinet_ops operator class is not the default class for typesinet andcidr. To use it, mention the class name inCREATE INDEX, for example

CREATE INDEX ON my_table USING GIST (my_inet_column inet_ops);


Prev Up Next
62.1. Introduction Home 62.3. Extensibility
epubpdf
Go to PostgreSQL 10
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp