PostgreSQL：文件：16：68.2. 內建運算子類別

文件 → PostgreSQL 16

支援的版本：目前 (16) / 15 / 14 / 13 / 12

不支援的版本：11 / 10 / 9.6 / 9.5 / 9.4

68.2. 內建運算子類別
上一個	向上	第 68 章 GiST 索引	首頁	下一個

68.2. 內建運算子類別 #

核心 PostgreSQL 發行版包含表 68.1 中顯示的 GiST 運算子類別。（附錄 F 中描述的一些選用模組提供其他 GiST 運算子類別。）

表 68.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)`
	`~ (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)`
	`@ (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)`
	`&> (多邊形, 多邊形)`
	`>> (多邊形, 多邊形)`
	`<@ (多邊形, 多邊形)`
	`@> (多邊形, 多邊形)`
	`~= (多邊形, 多邊形)`
	`&& (多邊形, 多邊形)`
	`<<\| (多邊形, 多邊形)`
	`&<\| (多邊形, 多邊形)`
	`\|&> (多邊形, 多邊形)`
	`\|>> (多邊形, 多邊形)`
	`@ (多邊形, 多邊形)`
	`~ (多邊形, 多邊形)`
`range_ops`	`= (任意範圍, 任意範圍)`
	`&& (任意範圍, 任意範圍)`
	`&& (任意範圍, 任意多重範圍)`
	`@> (任意範圍, 任意元素)`
	`@> (任意範圍, 任意範圍)`
	`@> (任意範圍, 任意多重範圍)`
	`<@ (任意範圍, 任意範圍)`
	`<@ (任意範圍, 任意多重範圍)`
	`<< (任意範圍, 任意範圍)`
	`<< (任意範圍, 任意多重範圍)`
	`>> (任意範圍, 任意範圍)`
	`>> (任意範圍, 任意多重範圍)`
	`&< (任意範圍, 任意範圍)`
	`&< (任意範圍, 任意多重範圍)`
	`&> (任意範圍, 任意範圍)`
	`&> (任意範圍, 任意多重範圍)`
	`-\|- (任意範圍, 任意範圍)`
	`-\|- (任意範圍, 任意多重範圍)`
`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);

上一個	向上	下一個
68.1. 簡介	首頁	68.3. 可擴充性

提交更正

如果您在文件中看到任何不正確、與您對特定功能的體驗不符或需要進一步說明的地方，請使用此表單報告文件問題。