Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
61.2. Built-in Operator Classes
Prev UpChapter 61. GiST IndexesHome Next

61.2. Built-in Operator Classes

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

Table 61.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
61.1. Introduction Home 61.3. Extensibility
pdfepub
Go to Postgres Pro Standard 13
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp