PostgreSQL: 文档：14：63.2. 内置操作符类

文档 → PostgreSQL 14

受支持版本： 16 / 15 / 14

63.2. 内置操作符类
Prev	Up	Chapter 63. GiST 索引	Home	Next

63.2. 内置操作符类 #

PostgreSQL核心发行版包含Table 63.1中所示的GiST操作符类。（Appendix F中描述的一些可选模块还提供了额外的GiST操作符类。）

Table 63.1. 内置 GiST 操作符类

名称	可索引操作符	排序操作符
`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)`

出于历史原因，inet_ops操作符类不是类型inet和cidr的默认类。要使用它，请在CREATE INDEX中写出该类名，例如

CREATE INDEX ON my_table USING GIST (my_inet_column inet_ops);

Prev	Up	Next
Chapter 63. GiST 索引	Home	63.3. 可扩展性

提交更正

如果您发现文档中有不正确的内容、与您使用特定功能的经验不符或需要进一步说明，请使用此表单来报告文档问题。