{"kind": "operator", "major": "18", "item": {"slug": "op-403e-anyarray-anyarray", "name": "@>(anyarray,anyarray)", "name_zh": "", "category": "\u4f2a\u7c7b\u578b", "summary": "\u5305\u542b", "aliases": ["@>", "@>(anyarray,anyarray)"], "content_hash": "03288e7babb5943f7d34f12bfcad5fdedc3a79ad32656076144df06b267e565d", "versions": {"10": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "bool"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "arraycontains(anyarray,anyarray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gin-array_ops/?v=10", "text": "array_ops"}, "method": {"url": "/wiki/indexam/gin/?v=10", "text": "GIN"}, "purpose": "\u641c\u7d22", "strategy": "2", "sort_family": ""}], "title": "\u58f0\u660e\u7684\u64cd\u4f5c\u7b26\u5bb6\u65cf\u6210\u5458\u5173\u7cfb", "columns": [{"key": "method", "label": "\u7d22\u5f15\u8bbf\u95ee\u65b9\u6cd5"}, {"key": "family", "label": "\u64cd\u4f5c\u7b26\u5bb6\u65cf"}, {"key": "strategy", "label": "\u7b56\u7565"}, {"key": "purpose", "label": "\u7528\u9014"}, {"key": "sort_family", "label": "\u6392\u5e8f\u5bb6\u65cf"}]}], "aliases": ["@>", "@>(anyarray,anyarray)"], "related": [{"url": "/wiki/type/anyarray/?v=10", "label": "anyarray \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/type/bool/?v=10", "label": "bool \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/operator/op-3c40-anyarray-anyarray/?v=10", "label": "\u4ea4\u6362\u64cd\u4f5c\u7b26\uff1a<@(anyarray,anyarray)"}, {"url": "/wiki/opclass/family-gin-array_ops/?v=10", "label": "gin/array_ops \u5bb6\u65cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "label": "10.23", "major": "10", "channel": "historical", "revision": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9", "source_sha256": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9", "manual_fingerprint": "113b870e3ff4b52320f34750da5e740800f3f6e4ed6f2fc00a0891944d1be7c2", "catalog_fingerprint": "dd2d5fd5e17d29184db5f6625f9f0f9b9d40ae7aa34b6ccf28ddbc8684bd4992"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9"}, {"url": "https://pg.center/docs/10/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 10 English manual: catalog-pg-operator.html", "sha256": "1264240e312e88b54064702e9716b8d21fec2f06d1e3a9568f88a01f19f722df", "language": "en", "original_url": "/docs/10/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/10/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 10 English manual: catalog-pg-amop.html", "sha256": "d5ce5a3be599e5506edbe3ff615674beb013720953f4979a44b6ecfd4cc24090", "language": "en", "original_url": "/docs/10/catalog-pg-amop.html"}], "operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "sections": [{"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 37.12 \u8282 \u3002", "\u672a\u4f7f\u7528\u7684\u5217\u5305\u542b\u96f6\u3002\u4f8b\u5982\uff0c\u524d\u7f00\u64cd\u4f5c\u7b26\u7684 oprleft \u4e3a\u96f6\u3002"]}], "signature": "@>(anyarray,anyarray) \u2192 bool", "source_oid": "2751", "description": ["\u5305\u542b"], "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "description": "contains", "family_slug": "family-gin-array_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-403e-anyarray-anyarray", "sort_family_slug": ""}], "localization": {"status": "complete", "sources": [{"url": "/docs/10/catalog-pg-amop.html", "method": "same-major semantic node", "sha256": "f2ee5e4386a45a176aa7c61ff8d752aee0ce3aaea06553965bee526ab799f223", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMOP/p[2]/em[1]"]}, {"url": "/docs/10/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "3740bedec8ec7057a4675ce56725731bbf5f224a99576be65691ff91e66c9e5b", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]", "#CATALOG-PG-OPERATOR/p[5]"]}], "language": "zh", "original_text": {"/versions/10/description/0": "contains", "/versions/10/facts/0/label": "Left operand", "/versions/10/facts/1/label": "Right operand", "/versions/10/facts/2/label": "Result type", "/versions/10/facts/3/label": "Implementing function", "/versions/10/facts/4/label": "Operator kind", "/versions/10/facts/5/label": "Hash join candidate", "/versions/10/facts/5/value": "no", "/versions/10/facts/6/label": "Merge join candidate", "/versions/10/facts/6/value": "no", "/versions/10/tables/0/title": "Declared operator-family membership", "/versions/10/related/0/label": "anyarray data type", "/versions/10/related/1/label": "bool data type", "/versions/10/related/2/label": "Commutator: <@(anyarray,anyarray)", "/versions/10/related/3/label": "gin/array_ops family", "/versions/10/sections/0/title": "Catalog interpretation", "/versions/10/sections/0/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 37.12 for more information.", "/versions/10/sections/0/paragraphs/1": "Unused columns contain zeroes. For example, oprleft is zero for a prefix operator.", "/versions/10/tables/0/rows/0/purpose": "search", "/versions/10/tables/0/columns/0/label": "Index AM", "/versions/10/tables/0/columns/1/label": "Family", "/versions/10/tables/0/columns/2/label": "Strategy", "/versions/10/tables/0/columns/3/label": "Purpose", "/versions/10/tables/0/columns/4/label": "Ordering family"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "a7a43c29328f28ed998e087288625b58c628a4cddc5a9db8684b7de3c711bdce"}, "comparison_data": {"operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "sort_family": ""}]}, "comparison_hash": "061bd581a5f986bbe6db0c78cde77e07d35618bbbfb76260faf66cd228a9846c", "manual_semantics": "Source catalog description; no additional matching manual operator definition claimed"}, "11": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "bool"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "arraycontains(anyarray,anyarray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gin-array_ops/?v=11", "text": "array_ops"}, "method": {"url": "/wiki/indexam/gin/?v=11", "text": "GIN"}, "purpose": "\u641c\u7d22", "strategy": "2", "sort_family": ""}], "title": "\u58f0\u660e\u7684\u64cd\u4f5c\u7b26\u5bb6\u65cf\u6210\u5458\u5173\u7cfb", "columns": [{"key": "method", "label": "\u7d22\u5f15\u8bbf\u95ee\u65b9\u6cd5"}, {"key": "family", "label": "\u64cd\u4f5c\u7b26\u5bb6\u65cf"}, {"key": "strategy", "label": "\u7b56\u7565"}, {"key": "purpose", "label": "\u7528\u9014"}, {"key": "sort_family", "label": "\u6392\u5e8f\u5bb6\u65cf"}]}], "aliases": ["@>", "@>(anyarray,anyarray)"], "related": [{"url": "/wiki/type/anyarray/?v=11", "label": "anyarray \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/type/bool/?v=11", "label": "bool \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/operator/op-3c40-anyarray-anyarray/?v=11", "label": "\u4ea4\u6362\u64cd\u4f5c\u7b26\uff1a<@(anyarray,anyarray)"}, {"url": "/wiki/opclass/family-gin-array_ops/?v=11", "label": "gin/array_ops \u5bb6\u65cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "label": "11.22", "major": "11", "channel": "historical", "revision": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0", "source_sha256": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0", "manual_fingerprint": "99c9e45d34555f000789cb4e019492e838041c1f2f31d840f3051ff9d7ed9118", "catalog_fingerprint": "4f08eb8c7ac7d09abfbb29a172148a44b8fb72026616bb55a5f8f84db7a38785"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, {"url": "https://pg.center/docs/11/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 11 English manual: catalog-pg-operator.html", "sha256": "3de94bb7f17052a69cf35056c95cac18bf74de96ea2c7b243165f1eeb6a3d587", "language": "en", "original_url": "/docs/11/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/11/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 11 English manual: catalog-pg-amop.html", "sha256": "c17d050a6f2d093de2c343242bcc4d446b936de1d2902727d3fa3b0697b44fd3", "language": "en", "original_url": "/docs/11/catalog-pg-amop.html"}], "operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "sections": [{"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 38.13 \u8282 \u3002", "\u672a\u4f7f\u7528\u7684\u5217\u5305\u542b\u96f6\u3002\u4f8b\u5982\uff0c\u524d\u7f00\u64cd\u4f5c\u7b26\u7684 oprleft \u4e3a\u96f6\u3002"]}], "signature": "@>(anyarray,anyarray) \u2192 bool", "source_oid": "2751", "description": ["\u5305\u542b"], "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "description": "contains", "family_slug": "family-gin-array_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-403e-anyarray-anyarray", "sort_family_slug": ""}], "localization": {"status": "complete", "sources": [{"url": "/docs/11/catalog-pg-amop.html", "method": "same-major semantic node", "sha256": "d4e01ba05c1f00188e2353ef6816dbe175140ae359defc71e20f92fb0e69299a", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMOP/p[2]/em[1]"]}, {"url": "/docs/11/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "f82a79efdee09289202a35db03a983767f4fc93fe523141f530180cd56c9dd23", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]", "#CATALOG-PG-OPERATOR/p[5]"]}], "language": "zh", "original_text": {"/versions/11/description/0": "contains", "/versions/11/facts/0/label": "Left operand", "/versions/11/facts/1/label": "Right operand", "/versions/11/facts/2/label": "Result type", "/versions/11/facts/3/label": "Implementing function", "/versions/11/facts/4/label": "Operator kind", "/versions/11/facts/5/label": "Hash join candidate", "/versions/11/facts/5/value": "no", "/versions/11/facts/6/label": "Merge join candidate", "/versions/11/facts/6/value": "no", "/versions/11/tables/0/title": "Declared operator-family membership", "/versions/11/related/0/label": "anyarray data type", "/versions/11/related/1/label": "bool data type", "/versions/11/related/2/label": "Commutator: <@(anyarray,anyarray)", "/versions/11/related/3/label": "gin/array_ops family", "/versions/11/sections/0/title": "Catalog interpretation", "/versions/11/sections/0/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 38.13 for more information.", "/versions/11/sections/0/paragraphs/1": "Unused columns contain zeroes. For example, oprleft is zero for a prefix operator.", "/versions/11/tables/0/rows/0/purpose": "search", "/versions/11/tables/0/columns/0/label": "Index AM", "/versions/11/tables/0/columns/1/label": "Family", "/versions/11/tables/0/columns/2/label": "Strategy", "/versions/11/tables/0/columns/3/label": "Purpose", "/versions/11/tables/0/columns/4/label": "Ordering family"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "c2aec06ac62dfc1fa1ce34ee941249e86519285820468d9c452318fa1d49eccf"}, "comparison_data": {"operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "sort_family": ""}]}, "comparison_hash": "061bd581a5f986bbe6db0c78cde77e07d35618bbbfb76260faf66cd228a9846c", "manual_semantics": "Source catalog description; no additional matching manual operator definition claimed"}, "12": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "bool"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "arraycontains(anyarray,anyarray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gin-array_ops/?v=12", "text": "array_ops"}, "method": {"url": "/wiki/indexam/gin/?v=12", "text": "GIN"}, "purpose": "\u641c\u7d22", "strategy": "2", "sort_family": ""}], "title": "\u58f0\u660e\u7684\u64cd\u4f5c\u7b26\u5bb6\u65cf\u6210\u5458\u5173\u7cfb", "columns": [{"key": "method", "label": "\u7d22\u5f15\u8bbf\u95ee\u65b9\u6cd5"}, {"key": "family", "label": "\u64cd\u4f5c\u7b26\u5bb6\u65cf"}, {"key": "strategy", "label": "\u7b56\u7565"}, {"key": "purpose", "label": "\u7528\u9014"}, {"key": "sort_family", "label": "\u6392\u5e8f\u5bb6\u65cf"}]}], "aliases": ["@>", "@>(anyarray,anyarray)"], "related": [{"url": "/wiki/type/anyarray/?v=12", "label": "anyarray \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/type/bool/?v=12", "label": "bool \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/operator/op-3c40-anyarray-anyarray/?v=12", "label": "\u4ea4\u6362\u64cd\u4f5c\u7b26\uff1a<@(anyarray,anyarray)"}, {"url": "/wiki/opclass/family-gin-array_ops/?v=12", "label": "gin/array_ops \u5bb6\u65cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "label": "12.22", "major": "12", "channel": "historical", "revision": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b", "source_sha256": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b", "manual_fingerprint": "535df36baec2140f211303631c0a3f64e02d2673b9d34cb050d247997c94bd1e", "catalog_fingerprint": "1f423fd3c5fb61c039f8814116ce19dedbb2804bc864599818e88cbc4f5f284a"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, {"url": "https://pg.center/docs/12/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 12 English manual: catalog-pg-operator.html", "sha256": "e3f4410bbe926fcc950323b3358f3be85a42e2552afd5938562f725df6675cdb", "language": "en", "original_url": "/docs/12/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/12/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 12 English manual: catalog-pg-amop.html", "sha256": "84b91a9d763b1fb2968cc8be226a0369d31a6acb2468eb56cfd0b8d2030d1b45", "language": "en", "original_url": "/docs/12/catalog-pg-amop.html"}], "operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "sections": [{"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 37.14 \u8282 \u3002", "\u672a\u4f7f\u7528\u7684\u5217\u5305\u542b\u96f6\u3002\u4f8b\u5982\uff0c\u524d\u7f00\u64cd\u4f5c\u7b26\u7684 oprleft \u4e3a\u96f6\u3002"]}], "signature": "@>(anyarray,anyarray) \u2192 bool", "source_oid": "2751", "description": ["\u5305\u542b"], "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "description": "contains", "family_slug": "family-gin-array_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-403e-anyarray-anyarray", "sort_family_slug": ""}], "localization": {"status": "complete", "sources": [{"url": "/docs/12/catalog-pg-amop.html", "method": "same-major semantic node", "sha256": "fb1485d72baa6293bbb9db509168fcb9e29aeb84d9eaa463046dffc10c6689ab", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMOP/p[2]/em[1]"]}, {"url": "/docs/12/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "4a79b5202e1196d421bb3e2618f56796ef0b5c8fc2303cae3f9889c405e5236f", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]", "#CATALOG-PG-OPERATOR/p[5]"]}], "language": "zh", "original_text": {"/versions/12/description/0": "contains", "/versions/12/facts/0/label": "Left operand", "/versions/12/facts/1/label": "Right operand", "/versions/12/facts/2/label": "Result type", "/versions/12/facts/3/label": "Implementing function", "/versions/12/facts/4/label": "Operator kind", "/versions/12/facts/5/label": "Hash join candidate", "/versions/12/facts/5/value": "no", "/versions/12/facts/6/label": "Merge join candidate", "/versions/12/facts/6/value": "no", "/versions/12/tables/0/title": "Declared operator-family membership", "/versions/12/related/0/label": "anyarray data type", "/versions/12/related/1/label": "bool data type", "/versions/12/related/2/label": "Commutator: <@(anyarray,anyarray)", "/versions/12/related/3/label": "gin/array_ops family", "/versions/12/sections/0/title": "Catalog interpretation", "/versions/12/sections/0/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 37.14 for more information.", "/versions/12/sections/0/paragraphs/1": "Unused columns contain zeroes. For example, oprleft is zero for a prefix operator.", "/versions/12/tables/0/rows/0/purpose": "search", "/versions/12/tables/0/columns/0/label": "Index AM", "/versions/12/tables/0/columns/1/label": "Family", "/versions/12/tables/0/columns/2/label": "Strategy", "/versions/12/tables/0/columns/3/label": "Purpose", "/versions/12/tables/0/columns/4/label": "Ordering family"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "7e28335aa4972f4412d6fc33304f3be12a0389313c6be8ae01ee834475586bda"}, "comparison_data": {"operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "sort_family": ""}]}, "comparison_hash": "061bd581a5f986bbe6db0c78cde77e07d35618bbbfb76260faf66cd228a9846c", "manual_semantics": "Source catalog description; no additional matching manual operator definition claimed"}, "13": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "bool"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "arraycontains(anyarray,anyarray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gin-array_ops/?v=13", "text": "array_ops"}, "method": {"url": "/wiki/indexam/gin/?v=13", "text": "GIN"}, "purpose": "\u641c\u7d22", "strategy": "2", "sort_family": ""}], "title": "\u58f0\u660e\u7684\u64cd\u4f5c\u7b26\u5bb6\u65cf\u6210\u5458\u5173\u7cfb", "columns": [{"key": "method", "label": "\u7d22\u5f15\u8bbf\u95ee\u65b9\u6cd5"}, {"key": "family", "label": "\u64cd\u4f5c\u7b26\u5bb6\u65cf"}, {"key": "strategy", "label": "\u7b56\u7565"}, {"key": "purpose", "label": "\u7528\u9014"}, {"key": "sort_family", "label": "\u6392\u5e8f\u5bb6\u65cf"}]}], "aliases": ["@>", "@>(anyarray,anyarray)"], "related": [{"url": "/wiki/type/anyarray/?v=13", "label": "anyarray \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/type/bool/?v=13", "label": "bool \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/operator/op-3c40-anyarray-anyarray/?v=13", "label": "\u4ea4\u6362\u64cd\u4f5c\u7b26\uff1a<@(anyarray,anyarray)"}, {"url": "/wiki/opclass/family-gin-array_ops/?v=13", "label": "gin/array_ops \u5bb6\u65cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "label": "13.23", "major": "13", "channel": "historical", "revision": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6", "source_sha256": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6", "manual_fingerprint": "2bbea71f4723fc9e4e58cfdb28368763f999de2800d45ade748f7c7546dfb9d3", "catalog_fingerprint": "df58d29b226fbb90326087233d7970032abdec1352373270449eeee324f84a35"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, {"url": "https://pg.center/docs/13/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 13 English manual: catalog-pg-operator.html", "sha256": "1a325d2fa41f711c0a7fa6b57e37e8e98a59f218e01112e0767c455c1b5818a1", "language": "en", "original_url": "/docs/13/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/13/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 13 English manual: catalog-pg-amop.html", "sha256": "7a8e67f8dc59c305612c6d029fc8760c092f27203d5338c6db6c6d9b8aabc561", "language": "en", "original_url": "/docs/13/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/13/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 13 English manual: functions-array.html", "sha256": "e59b1b962a8068b4e7cd41addcb4f2f114f6dd84623b59249076c6d1c2036221", "language": "en", "original_url": "/docs/13/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u7b2c\u4e00\u4e2a\u6570\u7ec4\u662f\u5426\u5305\u542b\u7b2c\u4e8c\u4e2a\u6570\u7ec4\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u51fa\u73b0\u5728\u7b2c\u4e8c\u4e2a\u6570\u7ec4\u4e2d\u7684\u6bcf\u4e2a\u5143\u7d20\u662f\u5426\u7b49\u4e8e\u7b2c\u4e00\u4e2a\u6570\u7ec4\u4e2d\u7684\u67d0\u4e2a\u5143\u7d20\uff1f\uff08\u91cd\u590d\u5143\u7d20\u4e0d\u4f5c\u7279\u6b8a\u5904\u7406\uff0c\u56e0\u6b64 ARRAY[1] \u548c ARRAY[1,1] \u88ab\u8ba4\u4e3a\u5305\u542b\u5bf9\u65b9\u3002\uff09", "ARRAY[1,4,3] @> ARRAY[3,1,3] \u2192 t"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 37.14 \u8282 \u3002", "\u672a\u4f7f\u7528\u7684\u5217\u5305\u542b\u96f6\u3002\u4f8b\u5982\uff0c\u524d\u7f00\u64cd\u4f5c\u7b26\u7684 oprleft \u4e3a\u96f6\u3002"]}], "signature": "@>(anyarray,anyarray) \u2192 bool", "source_oid": "2751", "description": ["\u5305\u542b"], "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "description": "contains", "family_slug": "family-gin-array_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-403e-anyarray-anyarray", "sort_family_slug": ""}], "localization": {"status": "complete", "sources": [{"url": "/docs/13/catalog-pg-amop.html", "method": "same-major semantic node", "sha256": "344df36a802a949f2a1e178d6708bf07012cd0daff6368987f59cab3023d2853", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMOP/p[2]/em[1]"]}, {"url": "/docs/13/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "46fd38944eeaedaf5977bf7e555facfc61d03f97bee7df978680e2d60921724e", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]", "#CATALOG-PG-OPERATOR/p[5]"]}, {"url": "/docs/13/functions-array.html", "method": "same-major semantic node", "sha256": "5b68ce06a08318b28765d09394231470a901efcf6eb97f52fc58eca6ddde425b", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[0]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/13/description/0": "contains", "/versions/13/facts/0/label": "Left operand", "/versions/13/facts/1/label": "Right operand", "/versions/13/facts/2/label": "Result type", "/versions/13/facts/3/label": "Implementing function", "/versions/13/facts/4/label": "Operator kind", "/versions/13/facts/5/label": "Hash join candidate", "/versions/13/facts/5/value": "no", "/versions/13/facts/6/label": "Merge join candidate", "/versions/13/facts/6/value": "no", "/versions/13/tables/0/title": "Declared operator-family membership", "/versions/13/related/0/label": "anyarray data type", "/versions/13/related/1/label": "bool data type", "/versions/13/related/2/label": "Commutator: <@(anyarray,anyarray)", "/versions/13/related/3/label": "gin/array_ops family", "/versions/13/sections/0/title": "English manual definition", "/versions/13/sections/1/title": "Catalog interpretation", "/versions/13/sections/0/paragraphs/0": "Does the first array contain the second, that is, does each element appearing in the second array equal some element of the first array? (Duplicates are not treated specially, thus ARRAY[1] and ARRAY[1,1] are each considered to contain the other.)", "/versions/13/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 37.14 for more information.", "/versions/13/sections/1/paragraphs/1": "Unused columns contain zeroes. For example, oprleft is zero for a prefix operator.", "/versions/13/tables/0/rows/0/purpose": "search", "/versions/13/tables/0/columns/0/label": "Index AM", "/versions/13/tables/0/columns/1/label": "Family", "/versions/13/tables/0/columns/2/label": "Strategy", "/versions/13/tables/0/columns/3/label": "Purpose", "/versions/13/tables/0/columns/4/label": "Ordering family"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "c3b8eed85cea828bd201c4b53c3fd2a21e1ddee9091a9c2101cdb2994fb7da39"}, "comparison_data": {"operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "sort_family": ""}]}, "comparison_hash": "061bd581a5f986bbe6db0c78cde77e07d35618bbbfb76260faf66cd228a9846c", "manual_semantics": "Exact operand/result signature matched"}, "14": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "bool"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "arraycontains(anyarray,anyarray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gin-array_ops/?v=14", "text": "array_ops"}, "method": {"url": "/wiki/indexam/gin/?v=14", "text": "GIN"}, "purpose": "\u641c\u7d22", "strategy": "2", "sort_family": ""}], "title": "\u58f0\u660e\u7684\u64cd\u4f5c\u7b26\u5bb6\u65cf\u6210\u5458\u5173\u7cfb", "columns": [{"key": "method", "label": "\u7d22\u5f15\u8bbf\u95ee\u65b9\u6cd5"}, {"key": "family", "label": "\u64cd\u4f5c\u7b26\u5bb6\u65cf"}, {"key": "strategy", "label": "\u7b56\u7565"}, {"key": "purpose", "label": "\u7528\u9014"}, {"key": "sort_family", "label": "\u6392\u5e8f\u5bb6\u65cf"}]}], "aliases": ["@>", "@>(anyarray,anyarray)"], "related": [{"url": "/wiki/type/anyarray/?v=14", "label": "anyarray \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/type/bool/?v=14", "label": "bool \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/operator/op-3c40-anyarray-anyarray/?v=14", "label": "\u4ea4\u6362\u64cd\u4f5c\u7b26\uff1a<@(anyarray,anyarray)"}, {"url": "/wiki/opclass/family-gin-array_ops/?v=14", "label": "gin/array_ops \u5bb6\u65cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "label": "14.24", "major": "14", "channel": "stable", "revision": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897", "source_sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897", "manual_fingerprint": "1d055c6dc55d4defe2b6e9d0f842a47005487b21025b67e51d06721d3c122f71", "catalog_fingerprint": "9e0116f26e5ce870719efb77ef7b73e30c7928f8af27cbe87fdea32efe3811ef"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, {"url": "https://pg.center/docs/14/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 14 English manual: catalog-pg-operator.html", "sha256": "5e69fa82a7f0b49efb4ba5fc669e5bd35aeeede75682493bfc87e6035b23dd4d", "language": "en", "original_url": "/docs/14/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/14/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 14 English manual: catalog-pg-amop.html", "sha256": "402b87d7fb1a313b096ba5349a676ae38d507e2eb98739d6ed7f0681e0b9a9a4", "language": "en", "original_url": "/docs/14/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/14/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 14 English manual: functions-array.html", "sha256": "060b0c966d3d15591cbd968eaedd31c9cd3d882a6f7cefd1521bca5f7795c12a", "language": "en", "original_url": "/docs/14/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u7b2c\u4e00\u4e2a\u6570\u7ec4\u662f\u5426\u5305\u542b\u7b2c\u4e8c\u4e2a\u6570\u7ec4\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u51fa\u73b0\u5728\u7b2c\u4e8c\u4e2a\u6570\u7ec4\u4e2d\u7684\u6bcf\u4e2a\u5143\u7d20\u662f\u5426\u7b49\u4e8e\u7b2c\u4e00\u4e2a\u6570\u7ec4\u4e2d\u7684\u67d0\u4e2a\u5143\u7d20\uff1f\uff08\u91cd\u590d\u5143\u7d20\u4e0d\u4f5c\u7279\u6b8a\u5904\u7406\uff0c\u56e0\u6b64 ARRAY[1] \u548c ARRAY[1,1] \u88ab\u8ba4\u4e3a\u5305\u542b\u5bf9\u65b9\u3002\uff09", "ARRAY[1,4,3] @> ARRAY[3,1,3] \u2192 t"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 38.14 \u8282 \u3002"]}], "signature": "@>(anyarray,anyarray) \u2192 bool", "source_oid": "2751", "description": ["\u5305\u542b"], "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "description": "contains", "family_slug": "family-gin-array_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-403e-anyarray-anyarray", "sort_family_slug": ""}], "localization": {"status": "complete", "sources": [{"url": "/docs/14/catalog-pg-amop.html", "method": "same-major semantic node", "sha256": "2b8fdc15654f6701ab77bdf068a2c3b50cadd8da3bce8f385811b4193b4952b4", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMOP/p[2]/em[1]"]}, {"url": "/docs/14/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "77531e62ed30180fca3990f31ecee43d1a140f3a459c18583e5158aa4b41435a", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/14/functions-array.html", "method": "same-major semantic node", "sha256": "9782299db4c3b687e0bc9e3e2b2d3dd303b44c7c33039f518b8984ff4d1114a9", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[0]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "contains", "/versions/14/facts/0/label": "Left operand", "/versions/14/facts/1/label": "Right operand", "/versions/14/facts/2/label": "Result type", "/versions/14/facts/3/label": "Implementing function", "/versions/14/facts/4/label": "Operator kind", "/versions/14/facts/5/label": "Hash join candidate", "/versions/14/facts/5/value": "no", "/versions/14/facts/6/label": "Merge join candidate", "/versions/14/facts/6/value": "no", "/versions/14/tables/0/title": "Declared operator-family membership", "/versions/14/related/0/label": "anyarray data type", "/versions/14/related/1/label": "bool data type", "/versions/14/related/2/label": "Commutator: <@(anyarray,anyarray)", "/versions/14/related/3/label": "gin/array_ops family", "/versions/14/sections/0/title": "English manual definition", "/versions/14/sections/1/title": "Catalog interpretation", "/versions/14/sections/0/paragraphs/0": "Does the first array contain the second, that is, does each element appearing in the second array equal some element of the first array? (Duplicates are not treated specially, thus ARRAY[1] and ARRAY[1,1] are each considered to contain the other.)", "/versions/14/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 38.14 for more information.", "/versions/14/tables/0/rows/0/purpose": "search", "/versions/14/tables/0/columns/0/label": "Index AM", "/versions/14/tables/0/columns/1/label": "Family", "/versions/14/tables/0/columns/2/label": "Strategy", "/versions/14/tables/0/columns/3/label": "Purpose", "/versions/14/tables/0/columns/4/label": "Ordering family"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "23995594ac138243bb15e380dec37bc1ec6c0a054500c514b16083073683e2e9"}, "comparison_data": {"operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "sort_family": ""}]}, "comparison_hash": "061bd581a5f986bbe6db0c78cde77e07d35618bbbfb76260faf66cd228a9846c", "manual_semantics": "Exact operand/result signature matched"}, "15": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "bool"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "arraycontains(anyarray,anyarray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gin-array_ops/?v=15", "text": "array_ops"}, "method": {"url": "/wiki/indexam/gin/?v=15", "text": "GIN"}, "purpose": "\u641c\u7d22", "strategy": "2", "sort_family": ""}], "title": "\u58f0\u660e\u7684\u64cd\u4f5c\u7b26\u5bb6\u65cf\u6210\u5458\u5173\u7cfb", "columns": [{"key": "method", "label": "\u7d22\u5f15\u8bbf\u95ee\u65b9\u6cd5"}, {"key": "family", "label": "\u64cd\u4f5c\u7b26\u5bb6\u65cf"}, {"key": "strategy", "label": "\u7b56\u7565"}, {"key": "purpose", "label": "\u7528\u9014"}, {"key": "sort_family", "label": "\u6392\u5e8f\u5bb6\u65cf"}]}], "aliases": ["@>", "@>(anyarray,anyarray)"], "related": [{"url": "/wiki/type/anyarray/?v=15", "label": "anyarray \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/type/bool/?v=15", "label": "bool \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/operator/op-3c40-anyarray-anyarray/?v=15", "label": "\u4ea4\u6362\u64cd\u4f5c\u7b26\uff1a<@(anyarray,anyarray)"}, {"url": "/wiki/opclass/family-gin-array_ops/?v=15", "label": "gin/array_ops \u5bb6\u65cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "label": "15.19", "major": "15", "channel": "stable", "revision": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89", "source_sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89", "manual_fingerprint": "f39c61e9facb5b9404c7d6d1cf494d83af0cc46146554a7fc40724eb882d24a9", "catalog_fingerprint": "1c332a5ccec7bfdd8ca19b55a0279b5bd6cb1dd5dcc6c5587a98a491a9b566a5"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, {"url": "https://pg.center/docs/15/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 15 English manual: catalog-pg-operator.html", "sha256": "3719563ca7bb28791116cb206b9998cd336d09fb4d4cc4a236b6447bcfd5cbb2", "language": "en", "original_url": "/docs/15/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/15/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 15 English manual: catalog-pg-amop.html", "sha256": "53ced8770f19710869151ab02a9a6f0d97380981ca4bfe83752092bfb74a9e0c", "language": "en", "original_url": "/docs/15/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/15/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 15 English manual: functions-array.html", "sha256": "3a51987d44e436f2a5fd3d31371d7ac3213ecd6f86d8efc297d9e902dbbe1954", "language": "en", "original_url": "/docs/15/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u7b2c\u4e00\u4e2a\u6570\u7ec4\u662f\u5426\u5305\u542b\u7b2c\u4e8c\u4e2a\u6570\u7ec4\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u51fa\u73b0\u5728\u7b2c\u4e8c\u4e2a\u6570\u7ec4\u4e2d\u7684\u6bcf\u4e2a\u5143\u7d20\u662f\u5426\u7b49\u4e8e\u7b2c\u4e00\u4e2a\u6570\u7ec4\u4e2d\u7684\u67d0\u4e2a\u5143\u7d20\uff1f\uff08\u91cd\u590d\u5143\u7d20\u4e0d\u4f5c\u7279\u6b8a\u5904\u7406\uff0c\u56e0\u6b64 ARRAY[1] \u548c ARRAY[1,1] \u88ab\u8ba4\u4e3a\u5305\u542b\u5bf9\u65b9\u3002\uff09", "ARRAY[1,4,3] @> ARRAY[3,1,3] \u2192 t"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 38.14 \u8282 \u3002"]}], "signature": "@>(anyarray,anyarray) \u2192 bool", "source_oid": "2751", "description": ["\u5305\u542b"], "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "description": "contains", "family_slug": "family-gin-array_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-403e-anyarray-anyarray", "sort_family_slug": ""}], "localization": {"status": "complete", "sources": [{"url": "/docs/15/catalog-pg-amop.html", "method": "same-major semantic node", "sha256": "722b907f43f8178f67214192f7587c04c86bbab3759c44150d611dead287836f", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMOP/p[2]/em[1]"]}, {"url": "/docs/15/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "4865734bda46f48a054c1c554b2ff262358a48b562081c1f01a178a6df15e38b", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/15/functions-array.html", "method": "same-major semantic node", "sha256": "63a5366566d831e563c2912e58e18684791947a72d43a1947d81d840b6debc5e", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[0]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "contains", "/versions/15/facts/0/label": "Left operand", "/versions/15/facts/1/label": "Right operand", "/versions/15/facts/2/label": "Result type", "/versions/15/facts/3/label": "Implementing function", "/versions/15/facts/4/label": "Operator kind", "/versions/15/facts/5/label": "Hash join candidate", "/versions/15/facts/5/value": "no", "/versions/15/facts/6/label": "Merge join candidate", "/versions/15/facts/6/value": "no", "/versions/15/tables/0/title": "Declared operator-family membership", "/versions/15/related/0/label": "anyarray data type", "/versions/15/related/1/label": "bool data type", "/versions/15/related/2/label": "Commutator: <@(anyarray,anyarray)", "/versions/15/related/3/label": "gin/array_ops family", "/versions/15/sections/0/title": "English manual definition", "/versions/15/sections/1/title": "Catalog interpretation", "/versions/15/sections/0/paragraphs/0": "Does the first array contain the second, that is, does each element appearing in the second array equal some element of the first array? (Duplicates are not treated specially, thus ARRAY[1] and ARRAY[1,1] are each considered to contain the other.)", "/versions/15/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 38.14 for more information.", "/versions/15/tables/0/rows/0/purpose": "search", "/versions/15/tables/0/columns/0/label": "Index AM", "/versions/15/tables/0/columns/1/label": "Family", "/versions/15/tables/0/columns/2/label": "Strategy", "/versions/15/tables/0/columns/3/label": "Purpose", "/versions/15/tables/0/columns/4/label": "Ordering family"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "29484ef1b5f8879dbfaffe29134ec1864731c566f5d03b5e426f1f3ae2544101"}, "comparison_data": {"operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "sort_family": ""}]}, "comparison_hash": "061bd581a5f986bbe6db0c78cde77e07d35618bbbfb76260faf66cd228a9846c", "manual_semantics": "Exact operand/result signature matched"}, "16": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "bool"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "arraycontains(anyarray,anyarray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gin-array_ops/?v=16", "text": "array_ops"}, "method": {"url": "/wiki/indexam/gin/?v=16", "text": "GIN"}, "purpose": "\u641c\u7d22", "strategy": "2", "sort_family": ""}], "title": "\u58f0\u660e\u7684\u64cd\u4f5c\u7b26\u5bb6\u65cf\u6210\u5458\u5173\u7cfb", "columns": [{"key": "method", "label": "\u7d22\u5f15\u8bbf\u95ee\u65b9\u6cd5"}, {"key": "family", "label": "\u64cd\u4f5c\u7b26\u5bb6\u65cf"}, {"key": "strategy", "label": "\u7b56\u7565"}, {"key": "purpose", "label": "\u7528\u9014"}, {"key": "sort_family", "label": "\u6392\u5e8f\u5bb6\u65cf"}]}], "aliases": ["@>", "@>(anyarray,anyarray)"], "related": [{"url": "/wiki/type/anyarray/?v=16", "label": "anyarray \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/type/bool/?v=16", "label": "bool \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/operator/op-3c40-anyarray-anyarray/?v=16", "label": "\u4ea4\u6362\u64cd\u4f5c\u7b26\uff1a<@(anyarray,anyarray)"}, {"url": "/wiki/opclass/family-gin-array_ops/?v=16", "label": "gin/array_ops \u5bb6\u65cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "16.15", "major": "16", "channel": "stable", "revision": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed", "manual_fingerprint": "846fb006e9d590387203c1c65f671240bc5c30604c4e3084cf572817aacc19d0", "catalog_fingerprint": "70797d889dd8aeed77ae81092f99ab380e1109b54b0b7ca6fbf400e0a2111a70"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, {"url": "https://pg.center/docs/16/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 16 English manual: catalog-pg-operator.html", "sha256": "dc789ccf76b6bcbb9b1793858fe700431720a1e70f3261de2b3362ed78040476", "language": "en", "original_url": "/docs/16/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/16/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 16 English manual: catalog-pg-amop.html", "sha256": "f580ac4a34d5f9d567834684e0c41b7df32a952e20a2fc11a9ce0964c2df7e9a", "language": "en", "original_url": "/docs/16/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/16/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 16 English manual: functions-array.html", "sha256": "d7f628dae90278f57c4d5306b81206e85506017da233d2e41f01c1ee261c64f5", "language": "en", "original_url": "/docs/16/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u7b2c\u4e00\u4e2a\u6570\u7ec4\u662f\u5426\u5305\u542b\u7b2c\u4e8c\u4e2a\u6570\u7ec4\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u51fa\u73b0\u5728\u7b2c\u4e8c\u4e2a\u6570\u7ec4\u4e2d\u7684\u6bcf\u4e2a\u5143\u7d20\u662f\u5426\u7b49\u4e8e\u7b2c\u4e00\u4e2a\u6570\u7ec4\u4e2d\u7684\u67d0\u4e2a\u5143\u7d20\uff1f\uff08\u91cd\u590d\u5143\u7d20\u4e0d\u4f5c\u7279\u6b8a\u5904\u7406\uff0c\u56e0\u6b64 ARRAY[1] \u548c ARRAY[1,1] \u88ab\u8ba4\u4e3a\u5305\u542b\u5bf9\u65b9\u3002\uff09", "ARRAY[1,4,3] @> ARRAY[3,1,3] \u2192 t"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 38.14 \u8282 \u3002"]}], "signature": "@>(anyarray,anyarray) \u2192 bool", "source_oid": "2751", "description": ["\u5305\u542b"], "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "description": "contains", "family_slug": "family-gin-array_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-403e-anyarray-anyarray", "sort_family_slug": ""}], "localization": {"status": "complete", "sources": [{"url": "/docs/16/catalog-pg-amop.html", "method": "same-major semantic node", "sha256": "704b1a6817cd451566b69b08f4210b2fb192934810322e22cb9a2980f7d93af4", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMOP/p[2]/em[1]"]}, {"url": "/docs/16/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "ff2395afae4eb19cedbcb0acbd87a844078e82ba0722c2dbe9e7fa0c4c6503d4", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/16/functions-array.html", "method": "same-major semantic node", "sha256": "edd3b6606a2929629f746b3a82d883a41d4e15c1644d2b0c17b7d29ca050e341", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[0]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "contains", "/versions/16/facts/0/label": "Left operand", "/versions/16/facts/1/label": "Right operand", "/versions/16/facts/2/label": "Result type", "/versions/16/facts/3/label": "Implementing function", "/versions/16/facts/4/label": "Operator kind", "/versions/16/facts/5/label": "Hash join candidate", "/versions/16/facts/5/value": "no", "/versions/16/facts/6/label": "Merge join candidate", "/versions/16/facts/6/value": "no", "/versions/16/tables/0/title": "Declared operator-family membership", "/versions/16/related/0/label": "anyarray data type", "/versions/16/related/1/label": "bool data type", "/versions/16/related/2/label": "Commutator: <@(anyarray,anyarray)", "/versions/16/related/3/label": "gin/array_ops family", "/versions/16/sections/0/title": "English manual definition", "/versions/16/sections/1/title": "Catalog interpretation", "/versions/16/sections/0/paragraphs/0": "Does the first array contain the second, that is, does each element appearing in the second array equal some element of the first array? (Duplicates are not treated specially, thus ARRAY[1] and ARRAY[1,1] are each considered to contain the other.)", "/versions/16/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 38.14 for more information.", "/versions/16/tables/0/rows/0/purpose": "search", "/versions/16/tables/0/columns/0/label": "Index AM", "/versions/16/tables/0/columns/1/label": "Family", "/versions/16/tables/0/columns/2/label": "Strategy", "/versions/16/tables/0/columns/3/label": "Purpose", "/versions/16/tables/0/columns/4/label": "Ordering family"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "4ae3af36727013b896170b83713e079561b9517a7963ff753258688d9634d285"}, "comparison_data": {"operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "sort_family": ""}]}, "comparison_hash": "061bd581a5f986bbe6db0c78cde77e07d35618bbbfb76260faf66cd228a9846c", "manual_semantics": "Exact operand/result signature matched"}, "17": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "bool"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "arraycontains(anyarray,anyarray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gin-array_ops/?v=17", "text": "array_ops"}, "method": {"url": "/wiki/indexam/gin/?v=17", "text": "GIN"}, "purpose": "\u641c\u7d22", "strategy": "2", "sort_family": ""}], "title": "\u58f0\u660e\u7684\u64cd\u4f5c\u7b26\u5bb6\u65cf\u6210\u5458\u5173\u7cfb", "columns": [{"key": "method", "label": "\u7d22\u5f15\u8bbf\u95ee\u65b9\u6cd5"}, {"key": "family", "label": "\u64cd\u4f5c\u7b26\u5bb6\u65cf"}, {"key": "strategy", "label": "\u7b56\u7565"}, {"key": "purpose", "label": "\u7528\u9014"}, {"key": "sort_family", "label": "\u6392\u5e8f\u5bb6\u65cf"}]}], "aliases": ["@>", "@>(anyarray,anyarray)"], "related": [{"url": "/wiki/type/anyarray/?v=17", "label": "anyarray \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/type/bool/?v=17", "label": "bool \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/operator/op-3c40-anyarray-anyarray/?v=17", "label": "\u4ea4\u6362\u64cd\u4f5c\u7b26\uff1a<@(anyarray,anyarray)"}, {"url": "/wiki/opclass/family-gin-array_ops/?v=17", "label": "gin/array_ops \u5bb6\u65cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979", "manual_fingerprint": "b55870f8e80e1114a92ac7bfc97f4a6fa0dee8e75935895252bb6e5b866cf187", "catalog_fingerprint": "e888e3474202df1c60a8e7b6bf9f2d83b3866a52d119521659b7a82787d3829d"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, {"url": "https://pg.center/docs/17/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 17 English manual: catalog-pg-operator.html", "sha256": "a66984c4fde91649a9677d33a2e002381cb07e99d72ad0971fa3251741030a69", "language": "en", "original_url": "/docs/17/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/17/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 17 English manual: catalog-pg-amop.html", "sha256": "19b2fb110b348860f7fbcb6e0e0544e341f5645113c23f50920a54434d432359", "language": "en", "original_url": "/docs/17/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/17/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 17 English manual: functions-array.html", "sha256": "24ff62c83b1d0bea3a4d84fa2d85e3acf7ce23e786aae52571d9be14e8075291", "language": "en", "original_url": "/docs/17/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u7b2c\u4e00\u4e2a\u6570\u7ec4\u662f\u5426\u5305\u542b\u7b2c\u4e8c\u4e2a\u6570\u7ec4\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u51fa\u73b0\u5728\u7b2c\u4e8c\u4e2a\u6570\u7ec4\u4e2d\u7684\u6bcf\u4e2a\u5143\u7d20\u662f\u5426\u7b49\u4e8e\u7b2c\u4e00\u4e2a\u6570\u7ec4\u4e2d\u7684\u67d0\u4e2a\u5143\u7d20\uff1f\uff08\u91cd\u590d\u5143\u7d20\u4e0d\u4f5c\u7279\u6b8a\u5904\u7406\uff0c\u56e0\u6b64 ARRAY[1] \u548c ARRAY[1,1] \u88ab\u8ba4\u4e3a\u5305\u542b\u5bf9\u65b9\u3002\uff09", "ARRAY[1,4,3] @> ARRAY[3,1,3] \u2192 t"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 36.14 \u8282 \u3002"]}], "signature": "@>(anyarray,anyarray) \u2192 bool", "source_oid": "2751", "description": ["\u5305\u542b"], "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "description": "contains", "family_slug": "family-gin-array_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-403e-anyarray-anyarray", "sort_family_slug": ""}], "localization": {"status": "complete", "sources": [{"url": "/docs/17/catalog-pg-amop.html", "method": "same-major semantic node", "sha256": "79658772dd07ff10c4a4a472853e5a9bcba832796f5f9d2c0c77a87da769e5f6", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMOP/p[2]/em[1]"]}, {"url": "/docs/17/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "f83afaba592d4bb686da0579943b49e4c821b3df0a02b82c5fab86e1d168a26e", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/17/functions-array.html", "method": "same-major semantic node", "sha256": "1f2bbb3053bfea41ee69493c671dadbcfa0038c01d2526997802c5f5696bb154", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[0]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "contains", "/versions/17/facts/0/label": "Left operand", "/versions/17/facts/1/label": "Right operand", "/versions/17/facts/2/label": "Result type", "/versions/17/facts/3/label": "Implementing function", "/versions/17/facts/4/label": "Operator kind", "/versions/17/facts/5/label": "Hash join candidate", "/versions/17/facts/5/value": "no", "/versions/17/facts/6/label": "Merge join candidate", "/versions/17/facts/6/value": "no", "/versions/17/tables/0/title": "Declared operator-family membership", "/versions/17/related/0/label": "anyarray data type", "/versions/17/related/1/label": "bool data type", "/versions/17/related/2/label": "Commutator: <@(anyarray,anyarray)", "/versions/17/related/3/label": "gin/array_ops family", "/versions/17/sections/0/title": "English manual definition", "/versions/17/sections/1/title": "Catalog interpretation", "/versions/17/sections/0/paragraphs/0": "Does the first array contain the second, that is, does each element appearing in the second array equal some element of the first array? (Duplicates are not treated specially, thus ARRAY[1] and ARRAY[1,1] are each considered to contain the other.)", "/versions/17/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.", "/versions/17/tables/0/rows/0/purpose": "search", "/versions/17/tables/0/columns/0/label": "Index AM", "/versions/17/tables/0/columns/1/label": "Family", "/versions/17/tables/0/columns/2/label": "Strategy", "/versions/17/tables/0/columns/3/label": "Purpose", "/versions/17/tables/0/columns/4/label": "Ordering family"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "11a39f3162b10da73197f59dddd9d72791faac8f17331c6ebb2e147d3fbf72fa"}, "comparison_data": {"operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "sort_family": ""}]}, "comparison_hash": "061bd581a5f986bbe6db0c78cde77e07d35618bbbfb76260faf66cd228a9846c", "manual_semantics": "Exact operand/result signature matched"}, "18": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "bool"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "arraycontains(anyarray,anyarray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gin-array_ops/?v=18", "text": "array_ops"}, "method": {"url": "/wiki/indexam/gin/?v=18", "text": "GIN"}, "purpose": "\u641c\u7d22", "strategy": "2", "sort_family": ""}], "title": "\u58f0\u660e\u7684\u64cd\u4f5c\u7b26\u5bb6\u65cf\u6210\u5458\u5173\u7cfb", "columns": [{"key": "method", "label": "\u7d22\u5f15\u8bbf\u95ee\u65b9\u6cd5"}, {"key": "family", "label": "\u64cd\u4f5c\u7b26\u5bb6\u65cf"}, {"key": "strategy", "label": "\u7b56\u7565"}, {"key": "purpose", "label": "\u7528\u9014"}, {"key": "sort_family", "label": "\u6392\u5e8f\u5bb6\u65cf"}]}], "aliases": ["@>", "@>(anyarray,anyarray)"], "related": [{"url": "/wiki/type/anyarray/?v=18", "label": "anyarray \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/type/bool/?v=18", "label": "bool \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/operator/op-3c40-anyarray-anyarray/?v=18", "label": "\u4ea4\u6362\u64cd\u4f5c\u7b26\uff1a<@(anyarray,anyarray)"}, {"url": "/wiki/opclass/family-gin-array_ops/?v=18", "label": "gin/array_ops \u5bb6\u65cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "manual_fingerprint": "fefce9e478eb2afe5e17e869492bbedc67dce23d317f0a5257240113d6496ebc", "catalog_fingerprint": "deec62e0f0c649d9d0d058ddd0b16bf41afffd569c3fd73949ff0971ce5cabd6"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, {"url": "https://pg.center/docs/18/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 18 English manual: catalog-pg-operator.html", "sha256": "e0b1817914e5e8f9037955cd41e9a43584e9227fcc115784898ecdd9a6c0ecd6", "language": "en", "original_url": "/docs/18/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/18/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 18 English manual: catalog-pg-amop.html", "sha256": "e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1", "language": "en", "original_url": "/docs/18/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 18 English manual: functions-array.html", "sha256": "d84446981971a18b9bab327f3c737737f8cc290dd9963d1472c7e6cab60bea7c", "language": "en", "original_url": "/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u7b2c\u4e00\u4e2a\u6570\u7ec4\u662f\u5426\u5305\u542b\u7b2c\u4e8c\u4e2a\u6570\u7ec4\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u51fa\u73b0\u5728\u7b2c\u4e8c\u4e2a\u6570\u7ec4\u4e2d\u7684\u6bcf\u4e2a\u5143\u7d20\u662f\u5426\u7b49\u4e8e\u7b2c\u4e00\u4e2a\u6570\u7ec4\u4e2d\u7684\u67d0\u4e2a\u5143\u7d20\uff1f\uff08\u91cd\u590d\u5143\u7d20\u4e0d\u4f5c\u7279\u6b8a\u5904\u7406\uff0c\u56e0\u6b64 ARRAY[1] \u548c ARRAY[1,1] \u88ab\u8ba4\u4e3a\u5305\u542b\u5bf9\u65b9\u3002\uff09", "ARRAY[1,4,3] @> ARRAY[3,1,3] \u2192 t"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 36.14 \u8282 \u3002"]}], "signature": "@>(anyarray,anyarray) \u2192 bool", "source_oid": "2751", "description": ["\u5305\u542b"], "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "description": "contains", "family_slug": "family-gin-array_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-403e-anyarray-anyarray", "sort_family_slug": ""}], "localization": {"status": "complete", "sources": [{"url": "/docs/18/catalog-pg-amop.html", "method": "same-major semantic node", "sha256": "c46185aa5f574dacd289a0b3876023793406b4cf58dee7eeebb86436d0577bdc", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMOP/p[2]/em[1]"]}, {"url": "/docs/18/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "7cfcd945bbbd55377dea8d4bd57380014caceb4e83c5db3be16c23eb5991d68f", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/18/functions-array.html", "method": "same-major semantic node", "sha256": "0e8d3a063c256532ec483932c334b157e003cd25afc91aa6fb0a9f0a5fb0e039", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[0]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "contains", "/versions/18/facts/0/label": "Left operand", "/versions/18/facts/1/label": "Right operand", "/versions/18/facts/2/label": "Result type", "/versions/18/facts/3/label": "Implementing function", "/versions/18/facts/4/label": "Operator kind", "/versions/18/facts/5/label": "Hash join candidate", "/versions/18/facts/5/value": "no", "/versions/18/facts/6/label": "Merge join candidate", "/versions/18/facts/6/value": "no", "/versions/18/tables/0/title": "Declared operator-family membership", "/versions/18/related/0/label": "anyarray data type", "/versions/18/related/1/label": "bool data type", "/versions/18/related/2/label": "Commutator: <@(anyarray,anyarray)", "/versions/18/related/3/label": "gin/array_ops family", "/versions/18/sections/0/title": "English manual definition", "/versions/18/sections/1/title": "Catalog interpretation", "/versions/18/sections/0/paragraphs/0": "Does the first array contain the second, that is, does each element appearing in the second array equal some element of the first array? (Duplicates are not treated specially, thus ARRAY[1] and ARRAY[1,1] are each considered to contain the other.)", "/versions/18/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.", "/versions/18/tables/0/rows/0/purpose": "search", "/versions/18/tables/0/columns/0/label": "Index AM", "/versions/18/tables/0/columns/1/label": "Family", "/versions/18/tables/0/columns/2/label": "Strategy", "/versions/18/tables/0/columns/3/label": "Purpose", "/versions/18/tables/0/columns/4/label": "Ordering family"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "d4624c7eaa42ef692592f12dc2da0f4bf6f4f68c3114adabc6b31b6b2897a649"}, "comparison_data": {"operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "sort_family": ""}]}, "comparison_hash": "061bd581a5f986bbe6db0c78cde77e07d35618bbbfb76260faf66cd228a9846c", "manual_semantics": "Exact operand/result signature matched"}, "19": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "bool"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "arraycontains(anyarray,anyarray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gin-array_ops/?v=19", "text": "array_ops"}, "method": {"url": "/wiki/indexam/gin/?v=19", "text": "GIN"}, "purpose": "\u641c\u7d22", "strategy": "2", "sort_family": ""}], "title": "\u58f0\u660e\u7684\u64cd\u4f5c\u7b26\u5bb6\u65cf\u6210\u5458\u5173\u7cfb", "columns": [{"key": "method", "label": "\u7d22\u5f15\u8bbf\u95ee\u65b9\u6cd5"}, {"key": "family", "label": "\u64cd\u4f5c\u7b26\u5bb6\u65cf"}, {"key": "strategy", "label": "\u7b56\u7565"}, {"key": "purpose", "label": "\u7528\u9014"}, {"key": "sort_family", "label": "\u6392\u5e8f\u5bb6\u65cf"}]}], "aliases": ["@>", "@>(anyarray,anyarray)"], "related": [{"url": "/wiki/type/anyarray/?v=19", "label": "anyarray \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/type/bool/?v=19", "label": "bool \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/operator/op-3c40-anyarray-anyarray/?v=19", "label": "\u4ea4\u6362\u64cd\u4f5c\u7b26\uff1a<@(anyarray,anyarray)"}, {"url": "/wiki/opclass/family-gin-array_ops/?v=19", "label": "gin/array_ops \u5bb6\u65cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "manual_fingerprint": "d1c30d7808d3ae2edc8773a0dd66f7beb5861e8939001e171c1908f7a09bb497", "catalog_fingerprint": "9af4323d0c8ed03d0e795331930bd14ce9bf6193c6b766c463b9f6ec0829409a"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, {"url": "https://pg.center/docs/19/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 19 English manual: catalog-pg-operator.html", "sha256": "fa89c3d5f2ba2adfe53192fd39c819efc78a22998994feed5fd4239bedaa938a", "language": "en", "original_url": "/docs/19/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/19/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 19 English manual: catalog-pg-amop.html", "sha256": "711850fdde973fbaf16da94143a2de3b972bed7a3b8663bf80e4aeabaf2f43fe", "language": "en", "original_url": "/docs/19/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/19/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 19 English manual: functions-array.html", "sha256": "d7cfbba448f2dbbf83e1e6c8f26811fae4bf09dc1d4861c21660b8831c3ad69e", "language": "en", "original_url": "/docs/19/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u7b2c\u4e00\u4e2a\u6570\u7ec4\u662f\u5426\u5305\u542b\u7b2c\u4e8c\u4e2a\u6570\u7ec4\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u51fa\u73b0\u5728\u7b2c\u4e8c\u4e2a\u6570\u7ec4\u4e2d\u7684\u6bcf\u4e2a\u5143\u7d20\u662f\u5426\u7b49\u4e8e\u7b2c\u4e00\u4e2a\u6570\u7ec4\u4e2d\u7684\u67d0\u4e2a\u5143\u7d20\uff1f\uff08\u91cd\u590d\u5143\u7d20\u4e0d\u4f5c\u7279\u6b8a\u5904\u7406\uff0c\u56e0\u6b64 ARRAY[1] \u548c ARRAY[1,1] \u88ab\u8ba4\u4e3a\u5305\u542b\u5bf9\u65b9\u3002\uff09", "ARRAY[1,4,3] @> ARRAY[3,1,3] \u2192 t"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 36.14 \u8282 \u3002"]}], "signature": "@>(anyarray,anyarray) \u2192 bool", "source_oid": "2751", "description": ["\u5305\u542b"], "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "description": "contains", "family_slug": "family-gin-array_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-403e-anyarray-anyarray", "sort_family_slug": ""}], "localization": {"status": "complete", "sources": [{"url": "/docs/19/catalog-pg-amop.html", "method": "same-major semantic node", "sha256": "8685135a1f22b71dfcd182e77ed97d14ceb21f011d1b58b2b168130423c68d5c", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMOP/p[2]/em[1]"]}, {"url": "/docs/19/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "9debafecc544409918e14c4ab4498c5b52d41808968dccb8a5874794ef8e4ac1", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/19/functions-array.html", "method": "same-major semantic node", "sha256": "21410c8a0e986c22adc0760e9d2f41c79c021aefe84016b3d15a55ea9dc0c452", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[0]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "contains", "/versions/19/facts/0/label": "Left operand", "/versions/19/facts/1/label": "Right operand", "/versions/19/facts/2/label": "Result type", "/versions/19/facts/3/label": "Implementing function", "/versions/19/facts/4/label": "Operator kind", "/versions/19/facts/5/label": "Hash join candidate", "/versions/19/facts/5/value": "no", "/versions/19/facts/6/label": "Merge join candidate", "/versions/19/facts/6/value": "no", "/versions/19/tables/0/title": "Declared operator-family membership", "/versions/19/related/0/label": "anyarray data type", "/versions/19/related/1/label": "bool data type", "/versions/19/related/2/label": "Commutator: <@(anyarray,anyarray)", "/versions/19/related/3/label": "gin/array_ops family", "/versions/19/sections/0/title": "English manual definition", "/versions/19/sections/1/title": "Catalog interpretation", "/versions/19/sections/0/paragraphs/0": "Does the first array contain the second, that is, does each element appearing in the second array equal some element of the first array? (Duplicates are not treated specially, thus ARRAY[1] and ARRAY[1,1] are each considered to contain the other.)", "/versions/19/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.", "/versions/19/tables/0/rows/0/purpose": "search", "/versions/19/tables/0/columns/0/label": "Index AM", "/versions/19/tables/0/columns/1/label": "Family", "/versions/19/tables/0/columns/2/label": "Strategy", "/versions/19/tables/0/columns/3/label": "Purpose", "/versions/19/tables/0/columns/4/label": "Ordering family"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "aa6faf36bd10611c9dbd45a35157c751f95df538280f03d418e732ce1f098f33"}, "comparison_data": {"operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "sort_family": ""}]}, "comparison_hash": "061bd581a5f986bbe6db0c78cde77e07d35618bbbfb76260faf66cd228a9846c", "manual_semantics": "Exact operand/result signature matched"}, "20": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "bool"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "arraycontains(anyarray,anyarray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gin-array_ops/?v=20", "text": "array_ops"}, "method": {"url": "/wiki/indexam/gin/?v=20", "text": "GIN"}, "purpose": "\u641c\u7d22", "strategy": "2", "sort_family": ""}], "title": "\u58f0\u660e\u7684\u64cd\u4f5c\u7b26\u5bb6\u65cf\u6210\u5458\u5173\u7cfb", "columns": [{"key": "method", "label": "\u7d22\u5f15\u8bbf\u95ee\u65b9\u6cd5"}, {"key": "family", "label": "\u64cd\u4f5c\u7b26\u5bb6\u65cf"}, {"key": "strategy", "label": "\u7b56\u7565"}, {"key": "purpose", "label": "\u7528\u9014"}, {"key": "sort_family", "label": "\u6392\u5e8f\u5bb6\u65cf"}]}], "aliases": ["@>", "@>(anyarray,anyarray)"], "related": [{"url": "/wiki/type/anyarray/?v=20", "label": "anyarray \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/type/bool/?v=20", "label": "bool \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/operator/op-3c40-anyarray-anyarray/?v=20", "label": "\u4ea4\u6362\u64cd\u4f5c\u7b26\uff1a<@(anyarray,anyarray)"}, {"url": "/wiki/opclass/family-gin-array_ops/?v=20", "label": "gin/array_ops \u5bb6\u65cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "manual_fingerprint": "48fb9e20e9e1454fe93d367e75b949833c82c1c52c2b69314dfffe1c464f3f39", "catalog_fingerprint": "cc1a474e972c8c342cf17f37e2884c56cc4b114cb59407b0180e99cdcfffa5c5", "source_snapshot_utc": "26-Sep-2026 20:22"}, "sources": [{"url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, {"url": "https://pg.center/docs/devel/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 20 English manual: catalog-pg-operator.html", "sha256": "b8882bb8329f1659f719eb9397246146135c228892834fbd29325ed3030f17cb", "language": "en", "original_url": "/docs/devel/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/devel/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 20 English manual: catalog-pg-amop.html", "sha256": "00fee8a631088b687e2d880e4091791ca30f9c69fca888c51ece463d1b9e1e61", "language": "en", "original_url": "/docs/devel/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/devel/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 20 English manual: functions-array.html", "sha256": "cf0d049a52c36212dd10c521bbee3ae2462540c76344b7ee57d429d0f68ec9be", "language": "en", "original_url": "/docs/devel/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u7b2c\u4e00\u4e2a\u6570\u7ec4\u662f\u5426\u5305\u542b\u7b2c\u4e8c\u4e2a\u6570\u7ec4\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u51fa\u73b0\u5728\u7b2c\u4e8c\u4e2a\u6570\u7ec4\u4e2d\u7684\u6bcf\u4e2a\u5143\u7d20\u662f\u5426\u7b49\u4e8e\u7b2c\u4e00\u4e2a\u6570\u7ec4\u4e2d\u7684\u67d0\u4e2a\u5143\u7d20\uff1f\uff08\u91cd\u590d\u5143\u7d20\u4e0d\u4f5c\u7279\u6b8a\u5904\u7406\uff0c\u56e0\u6b64 ARRAY[1] \u548c ARRAY[1,1] \u88ab\u8ba4\u4e3a\u5305\u542b\u5bf9\u65b9\u3002\uff09", "ARRAY[1,4,3] @> ARRAY[3,1,3] \u2192 t"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 36.14 \u8282 \u3002"]}], "signature": "@>(anyarray,anyarray) \u2192 bool", "source_oid": "2751", "description": ["\u5305\u542b"], "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "description": "contains", "family_slug": "family-gin-array_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-403e-anyarray-anyarray", "sort_family_slug": ""}], "localization": {"status": "complete", "sources": [{"url": "/docs/devel/catalog-pg-amop.html", "method": "same-major semantic node", "sha256": "e899b3d8b206f52e8dc0ac4b6019e55022abcf901a9d6cf93edf588bc4354664", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMOP/p[2]/em[1]"]}, {"url": "/docs/devel/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "573e7b9d66caef244b2c03df37b3c4b39b92c1b0e7f32fa8bd3e09d17d5591be", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/devel/functions-array.html", "method": "same-major semantic node", "sha256": "c656bb07e15d20cc07a0ebc9419d4e848e4b7a236a4b3103e6ac59dcc46773e4", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[0]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/summary": "contains", "/category": "Pseudo-types", "/versions/20/description/0": "contains", "/versions/20/facts/0/label": "Left operand", "/versions/20/facts/1/label": "Right operand", "/versions/20/facts/2/label": "Result type", "/versions/20/facts/3/label": "Implementing function", "/versions/20/facts/4/label": "Operator kind", "/versions/20/facts/5/label": "Hash join candidate", "/versions/20/facts/5/value": "no", "/versions/20/facts/6/label": "Merge join candidate", "/versions/20/facts/6/value": "no", "/versions/20/tables/0/title": "Declared operator-family membership", "/versions/20/related/0/label": "anyarray data type", "/versions/20/related/1/label": "bool data type", "/versions/20/related/2/label": "Commutator: <@(anyarray,anyarray)", "/versions/20/related/3/label": "gin/array_ops family", "/versions/20/sections/0/title": "English manual definition", "/versions/20/sections/1/title": "Catalog interpretation", "/versions/20/sections/0/paragraphs/0": "Does the first array contain the second, that is, does each element appearing in the second array equal some element of the first array? (Duplicates are not treated specially, thus ARRAY[1] and ARRAY[1,1] are each considered to contain the other.)", "/versions/20/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.", "/versions/20/tables/0/rows/0/purpose": "search", "/versions/20/tables/0/columns/0/label": "Index AM", "/versions/20/tables/0/columns/1/label": "Family", "/versions/20/tables/0/columns/2/label": "Strategy", "/versions/20/tables/0/columns/3/label": "Purpose", "/versions/20/tables/0/columns/4/label": "Ordering family"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "f87b5613d3c35b45a6e5755786c02736a6eaca861de32a76167bfbcf1a18e1ba"}, "comparison_data": {"operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "sort_family": ""}]}, "comparison_hash": "061bd581a5f986bbe6db0c78cde77e07d35618bbbfb76260faf66cd228a9846c", "manual_semantics": "Exact operand/result signature matched"}}}, "snapshot": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anyarray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "bool"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "arraycontains(anyarray,anyarray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gin-array_ops/?v=18", "text": "array_ops"}, "method": {"url": "/wiki/indexam/gin/?v=18", "text": "GIN"}, "purpose": "\u641c\u7d22", "strategy": "2", "sort_family": ""}], "title": "\u58f0\u660e\u7684\u64cd\u4f5c\u7b26\u5bb6\u65cf\u6210\u5458\u5173\u7cfb", "columns": [{"key": "method", "label": "\u7d22\u5f15\u8bbf\u95ee\u65b9\u6cd5"}, {"key": "family", "label": "\u64cd\u4f5c\u7b26\u5bb6\u65cf"}, {"key": "strategy", "label": "\u7b56\u7565"}, {"key": "purpose", "label": "\u7528\u9014"}, {"key": "sort_family", "label": "\u6392\u5e8f\u5bb6\u65cf"}]}], "aliases": ["@>", "@>(anyarray,anyarray)"], "related": [{"url": "/wiki/type/anyarray/?v=18", "label": "anyarray \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/type/bool/?v=18", "label": "bool \u6570\u636e\u7c7b\u578b"}, {"url": "/wiki/operator/op-3c40-anyarray-anyarray/?v=18", "label": "\u4ea4\u6362\u64cd\u4f5c\u7b26\uff1a<@(anyarray,anyarray)"}, {"url": "/wiki/opclass/family-gin-array_ops/?v=18", "label": "gin/array_ops \u5bb6\u65cf"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "manual_fingerprint": "fefce9e478eb2afe5e17e869492bbedc67dce23d317f0a5257240113d6496ebc", "catalog_fingerprint": "deec62e0f0c649d9d0d058ddd0b16bf41afffd569c3fd73949ff0971ce5cabd6"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, {"url": "https://pg.center/docs/18/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 18 English manual: catalog-pg-operator.html", "sha256": "e0b1817914e5e8f9037955cd41e9a43584e9227fcc115784898ecdd9a6c0ecd6", "language": "en", "original_url": "/docs/18/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/18/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 18 English manual: catalog-pg-amop.html", "sha256": "e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1", "language": "en", "original_url": "/docs/18/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 18 English manual: functions-array.html", "sha256": "d84446981971a18b9bab327f3c737737f8cc290dd9963d1472c7e6cab60bea7c", "language": "en", "original_url": "/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u7b2c\u4e00\u4e2a\u6570\u7ec4\u662f\u5426\u5305\u542b\u7b2c\u4e8c\u4e2a\u6570\u7ec4\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u51fa\u73b0\u5728\u7b2c\u4e8c\u4e2a\u6570\u7ec4\u4e2d\u7684\u6bcf\u4e2a\u5143\u7d20\u662f\u5426\u7b49\u4e8e\u7b2c\u4e00\u4e2a\u6570\u7ec4\u4e2d\u7684\u67d0\u4e2a\u5143\u7d20\uff1f\uff08\u91cd\u590d\u5143\u7d20\u4e0d\u4f5c\u7279\u6b8a\u5904\u7406\uff0c\u56e0\u6b64 ARRAY[1] \u548c ARRAY[1,1] \u88ab\u8ba4\u4e3a\u5305\u542b\u5bf9\u65b9\u3002\uff09", "ARRAY[1,4,3] @> ARRAY[3,1,3] \u2192 t"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 36.14 \u8282 \u3002"]}], "signature": "@>(anyarray,anyarray) \u2192 bool", "source_oid": "2751", "description": ["\u5305\u542b"], "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "description": "contains", "family_slug": "family-gin-array_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-403e-anyarray-anyarray", "sort_family_slug": ""}], "localization": {"status": "complete", "sources": [{"url": "/docs/18/catalog-pg-amop.html", "method": "same-major semantic node", "sha256": "c46185aa5f574dacd289a0b3876023793406b4cf58dee7eeebb86436d0577bdc", "language": "zh", "matched_nodes": ["#CATALOG-PG-AMOP/p[2]/em[1]"]}, {"url": "/docs/18/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "7cfcd945bbbd55377dea8d4bd57380014caceb4e83c5db3be16c23eb5991d68f", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/18/functions-array.html", "method": "same-major semantic node", "sha256": "0e8d3a063c256532ec483932c334b157e003cd25afc91aa6fb0a9f0a5fb0e039", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[0]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "contains", "/versions/18/facts/0/label": "Left operand", "/versions/18/facts/1/label": "Right operand", "/versions/18/facts/2/label": "Result type", "/versions/18/facts/3/label": "Implementing function", "/versions/18/facts/4/label": "Operator kind", "/versions/18/facts/5/label": "Hash join candidate", "/versions/18/facts/5/value": "no", "/versions/18/facts/6/label": "Merge join candidate", "/versions/18/facts/6/value": "no", "/versions/18/tables/0/title": "Declared operator-family membership", "/versions/18/related/0/label": "anyarray data type", "/versions/18/related/1/label": "bool data type", "/versions/18/related/2/label": "Commutator: <@(anyarray,anyarray)", "/versions/18/related/3/label": "gin/array_ops family", "/versions/18/sections/0/title": "English manual definition", "/versions/18/sections/1/title": "Catalog interpretation", "/versions/18/sections/0/paragraphs/0": "Does the first array contain the second, that is, does each element appearing in the second array equal some element of the first array? (Duplicates are not treated specially, thus ARRAY[1] and ARRAY[1,1] are each considered to contain the other.)", "/versions/18/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.", "/versions/18/tables/0/rows/0/purpose": "search", "/versions/18/tables/0/columns/0/label": "Index AM", "/versions/18/tables/0/columns/1/label": "Family", "/versions/18/tables/0/columns/2/label": "Strategy", "/versions/18/tables/0/columns/3/label": "Purpose", "/versions/18/tables/0/columns/4/label": "Ordering family"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "d4624c7eaa42ef692592f12dc2da0f4bf6f4f68c3114adabc6b31b6b2897a649"}, "comparison_data": {"operator": {"kind": "b", "symbol": "@>", "negator": "", "function": "arraycontains(anyarray,anyarray)", "hash_join": "f", "left_type": "anyarray", "commutator": "<@(anyarray,anyarray)", "merge_join": "f", "right_type": "anyarray", "result_type": "bool"}, "memberships": [{"family": "array_ops", "method": "gin", "purpose": "search", "operator": "@>(anyarray,anyarray)", "strategy": "2", "left_type": "anyarray", "right_type": "anyarray", "sort_family": ""}]}, "comparison_hash": "061bd581a5f986bbe6db0c78cde77e07d35618bbbfb76260faf66cd228a9846c", "manual_semantics": "Exact operand/result signature matched"}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}