PostgreSQL 9.4.1 Documentation | |||
---|---|---|---|
Prev | Up | Chapter 56. GiST Indexes | Next |
56.2. Built-in Operator Classes
The corePostgreSQL distribution includes theGiST operator classes shown inTable 56-1. (Some of the optional modules described inAppendix F provide additionalGiST operator classes.) Table 56-1. Built-inGiST Operator Classes 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 exampleName 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 @@ CREATE INDEX ON my_table USING gist (my_inet_column inet_ops);