Movatterモバイル変換

68.2. Built-in Operator Classes
Prev	Up	Chapter 68. GiST Indexes	Home	Next

68.2. Built-in Operator Classes

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

Table 68.1. Built-inGiST Operator Classes

Name	Indexable Operators	Ordering Operators
`box_ops`	`<< (box, box)`	`<-> (box, point)`
	`&< (box, box)`
	`&& (box, box)`
	`&> (box, box)`
	`>> (box, box)`
	`~= (box, box)`
	`@> (box, box)`
	`<@ (box, box)`
	`&<\| (box, box)`
	`<<\| (box, box)`
	`\|>> (box, box)`
	`\|&> (box, box)`
`circle_ops`	`<< (circle, circle)`	`<-> (circle, point)`
	`&< (circle, circle)`
	`&> (circle, circle)`
	`>> (circle, circle)`
	`<@ (circle, circle)`
	`@> (circle, circle)`
	`~= (circle, circle)`
	`&& (circle, circle)`
	`\|>> (circle, circle)`
	`<<\| (circle, circle)`
	`&<\| (circle, circle)`
	`\|&> (circle, circle)`
`inet_ops`	`<< (inet, inet)`
	`<<= (inet, inet)`
	`>> (inet, inet)`
	`>>= (inet, inet)`
	`= (inet, inet)`
	`<> (inet, inet)`
	`< (inet, inet)`
	`<= (inet, inet)`
	`> (inet, inet)`
	`>= (inet, inet)`
	`&& (inet, inet)`
`multirange_ops`	`= (anymultirange, anymultirange)`
	`&& (anymultirange, anymultirange)`
	`&& (anymultirange, anyrange)`
	`@> (anymultirange, anyelement)`
	`@> (anymultirange, anymultirange)`
	`@> (anymultirange, anyrange)`
	`<@ (anymultirange, anymultirange)`
	`<@ (anymultirange, anyrange)`
	`<< (anymultirange, anymultirange)`
	`<< (anymultirange, anyrange)`
	`>> (anymultirange, anymultirange)`
	`>> (anymultirange, anyrange)`
	`&< (anymultirange, anymultirange)`
	`&< (anymultirange, anyrange)`
	`&> (anymultirange, anymultirange)`
	`&> (anymultirange, anyrange)`
	`-\|- (anymultirange, anymultirange)`
	`-\|- (anymultirange, anyrange)`
`point_ops`	`\|>> (point, point)`	`<-> (point, point)`
	`<< (point, point)`
	`>> (point, point)`
	`<<\| (point, point)`
	`~= (point, point)`
	`<@ (point, box)`
	`<@ (point, polygon)`
	`<@ (point, circle)`
`poly_ops`	`<< (polygon, polygon)`	`<-> (polygon, point)`
	`&< (polygon, polygon)`
	`&> (polygon, polygon)`
	`>> (polygon, polygon)`
	`<@ (polygon, polygon)`
	`@> (polygon, polygon)`
	`~= (polygon, polygon)`
	`&& (polygon, polygon)`
	`<<\| (polygon, polygon)`
	`&<\| (polygon, polygon)`
	`\|&> (polygon, polygon)`
	`\|>> (polygon, polygon)`
`range_ops`	`= (anyrange, anyrange)`
	`&& (anyrange, anyrange)`
	`&& (anyrange, anymultirange)`
	`@> (anyrange, anyelement)`
	`@> (anyrange, anyrange)`
	`@> (anyrange, anymultirange)`
	`<@ (anyrange, anyrange)`
	`<@ (anyrange, anymultirange)`
	`<< (anyrange, anyrange)`
	`<< (anyrange, anymultirange)`
	`>> (anyrange, anyrange)`
	`>> (anyrange, anymultirange)`
	`&< (anyrange, anyrange)`
	`&< (anyrange, anymultirange)`
	`&> (anyrange, anyrange)`
	`&> (anyrange, anymultirange)`
	`-\|- (anyrange, anyrange)`
	`-\|- (anyrange, anymultirange)`
`tsquery_ops`	`<@ (tsquery, tsquery)`
`tsquery_ops`	`@> (tsquery, tsquery)`
`tsvector_ops`	`@@ (tsvector, tsquery)`

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
68.1. Introduction	Home	68.3. Extensibility

epub pdf