{"Entry":{"collection":"operator","key":"op-403e-anyarray-anyarray","name":"@\u003e(anyarray,anyarray)","aliases":["@\u003e","@\u003e(anyarray,anyarray)"],"metadata":{"aliases":["@\u003e","@\u003e(anyarray,anyarray)"],"category":"Pseudo-types","content_hash":"ccec587ff0803fe08e4f300bf699342b24b337e86e0474f9158c4247ceff54f0","derived_content_hash":"d6e726606039845aa441972e240b59509e1181d695e492b970f851b19089a3d8","imported_at":"2026-09-30T00:40:43.541169+08:00","name":"@\u003e(anyarray,anyarray)","name_zh":"","slug":"op-403e-anyarray-anyarray","summary":"contains"}},"Definition":{"Collection":"operator","Key":"op-403e-anyarray-anyarray","SourceDatabase":"center","Version":"18","SourceTable":"pg_operator_entry","SourceKey":"op-403e-anyarray-anyarray","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"aliases":["@\u003e","@\u003e(anyarray,anyarray)"],"comparison_data":{"memberships":[{"family":"array_ops","left_type":"anyarray","method":"gin","operator":"@\u003e(anyarray,anyarray)","purpose":"search","right_type":"anyarray","sort_family":"","strategy":"2"}],"operator":{"commutator":"\u003c@(anyarray,anyarray)","function":"arraycontains(anyarray,anyarray)","hash_join":"f","kind":"b","left_type":"anyarray","merge_join":"f","negator":"","result_type":"bool","right_type":"anyarray","symbol":"@\u003e"}},"comparison_hash":"061bd581a5f986bbe6db0c78cde77e07d35618bbbfb76260faf66cd228a9846c","description":["contains"],"description_zh":"包含。","description_zh_html":"\u003cp\u003e包含。\u003c/p\u003e\u003cdl\u003e\u003cdt\u003e种类\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003eb\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e符号\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003e@\u0026gt;\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e实现函数\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003earraycontains(anyarray,anyarray)\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e可用于哈希连接\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003e否\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e左操作数类型\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003eanyarray\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e交换运算符\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003e\u0026lt;@(anyarray,anyarray)\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e可用于归并连接\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003e否\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e右操作数类型\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003eanyarray\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e结果类型\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003ebool\u003c/code\u003e\u003c/dd\u003e\u003c/dl\u003e\u003ch3\u003e同版本中文手册节选\u003c/h3\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 9.56. 数组操作符\u003c/strong\u003e\u003c/p\u003e\u003cp\u003e\u003ca href=\"/zh/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE\"\u003e查看完整中文手册与上下文\u003c/a\u003e。\u003c/p\u003e\u003cp\u003e本页开头的中文说明为 PG.CENTER 对源码说明的翻译；手册节选保留对应版本中文文档原文。源码信息及手册示例不代表重新进行过运行测试。\u003c/p\u003e","facts":[{"label":"Left operand","value":"anyarray"},{"label":"Right operand","value":"anyarray"},{"label":"Result type","value":"bool"},{"label":"Implementing function","value":"arraycontains(anyarray,anyarray)"},{"label":"Operator kind","value":"Binary"},{"label":"Hash join candidate","value":"no"},{"label":"Merge join candidate","value":"no"}],"facts_zh":[{"label":"左操作数","value":"anyarray"},{"label":"右操作数","value":"anyarray"},{"label":"返回类型","value":"bool"},{"label":"实现函数","value":"arraycontains(anyarray,anyarray)"},{"label":"操作符种类","value":"Binary"},{"label":"可用于哈希连接","value":"否"},{"label":"可用于归并连接","value":"否"}],"manual_semantics":"Exact operand/result signature matched","memberships":[{"description":"contains","family":"array_ops","family_slug":"family-gin-array_ops","left_type":"anyarray","method":"gin","operator":"@\u003e(anyarray,anyarray)","operator_slug":"op-403e-anyarray-anyarray","purpose":"search","result_type":"bool","right_type":"anyarray","sort_family":"","sort_family_slug":"","strategy":"2"}],"operator":{"commutator":"\u003c@(anyarray,anyarray)","function":"arraycontains(anyarray,anyarray)","hash_join":"f","kind":"b","left_type":"anyarray","merge_join":"f","negator":"","result_type":"bool","right_type":"anyarray","symbol":"@\u003e"},"related":[{"label":"anyarray data type","url":"/wiki/type/anyarray/?v=18"},{"label":"bool data type","url":"/wiki/type/bool/?v=18"},{"label":"Commutator: \u003c@(anyarray,anyarray)","url":"/wiki/operator/op-3c40-anyarray-anyarray/?v=18"},{"label":"gin/array_ops family","url":"/wiki/opclass/family-gin-array_ops/?v=18"}],"release":{"catalog_fingerprint":"deec62e0f0c649d9d0d058ddd0b16bf41afffd569c3fd73949ff0971ce5cabd6","channel":"stable","label":"18.6","major":"18","manual_fingerprint":"fefce9e478eb2afe5e17e869492bbedc67dce23d317f0a5257240113d6496ebc","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[{"paragraphs":["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.)","ARRAY[1,4,3] @\u003e ARRAY[3,1,3] → t"],"title":"English manual definition"},{"paragraphs":["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."],"title":"Catalog interpretation"}],"sections_zh":[{"paragraphs":["第一个数组是否包含第二个数组，也就是说，出现在第二个数组中的每个元素是否等于第一个数组中的某个元素？（重复元素不作特殊处理，因此 ARRAY[1] 和 ARRAY[1,1] 被认为包含对方。）","ARRAY[1,4,3] @\u003e ARRAY[3,1,3] → t"],"title":"英文手册定义"},{"paragraphs":["目录 pg_operator 存储关于操作符的信息。详见 CREATE OPERATOR 和 第 36.14 节 。"],"title":"目录记录解读"}],"signature":"@\u003e(anyarray,anyarray) → bool","source_oid":"2751","sources":[{"label":"Matching PostgreSQL source archive","sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"label":"PostgreSQL 18 English manual: catalog-pg-operator.html","path":"catalog-pg-operator.html","sha256":"e0b1817914e5e8f9037955cd41e9a43584e9227fcc115784898ecdd9a6c0ecd6","url":"/docs/18/catalog-pg-operator.html"},{"label":"PostgreSQL 18 English manual: catalog-pg-amop.html","path":"catalog-pg-amop.html","sha256":"e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1","url":"/docs/18/catalog-pg-amop.html"},{"label":"PostgreSQL 18 English manual: functions-array.html","path":"functions-array.html","sha256":"d84446981971a18b9bab327f3c737737f8cc290dd9963d1472c7e6cab60bea7c","url":"/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE"}],"tables":[{"columns":[{"key":"method","label":"Index AM"},{"key":"family","label":"Family"},{"key":"strategy","label":"Strategy"},{"key":"purpose","label":"Purpose"},{"key":"sort_family","label":"Ordering family"}],"key":"memberships","rows":[{"family":{"text":"array_ops","url":"/wiki/opclass/family-gin-array_ops/?v=18"},"method":{"text":"GIN","url":"/wiki/indexam/gin/?v=18"},"purpose":"search","sort_family":"","strategy":"2"}],"title":"Declared operator-family membership"}],"tables_zh":[{"columns":[{"key":"method","label":"索引访问方法"},{"key":"family","label":"操作符家族"},{"key":"strategy","label":"策略"},{"key":"purpose","label":"用途"},{"key":"sort_family","label":"排序家族"}],"key":"memberships","rows":[{"family":{"text":"array_ops","url":"/wiki/opclass/family-gin-array_ops/?v=18"},"method":{"text":"GIN","url":"/wiki/indexam/gin/?v=18"},"purpose":"搜索","sort_family":"","strategy":"2"}],"title":"声明的操作符家族成员关系"}],"zh_from":{"authored_translation":"authored-translation-of-source-description","body_sha256":"381f8734533cdb7b21f515f212d47b6a4cc89f78bf2e97f8aca4c962462eef68","kind":"same-version-chinese-manual-with-authored-translation-of-source-description","manual":{"anchor":"ARRAY-OPERATORS-TABLE","build_id":107,"extraction":"concept-introduction","fragment_sha256":"11833a0773d62a98775f804af42de3891fce6334c20ea10c046df39f619a0772","locale":"zh-Hans","page_key":"functions-array.html","source_hash":"a25a0710e8f84e027ef945e85452074399887341e22d79542584f9c646b8f076","source_revision":"unknown:rendered-translation-baseline","translated_from_revision":null,"translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","url":"/zh/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE","version":"18"},"runtime_rerun":false,"source_facts_revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}},"ManualEvidence":{"release":{"catalog_fingerprint":"deec62e0f0c649d9d0d058ddd0b16bf41afffd569c3fd73949ff0971ce5cabd6","channel":"stable","label":"18.6","major":"18","manual_fingerprint":"fefce9e478eb2afe5e17e869492bbedc67dce23d317f0a5257240113d6496ebc","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"label":"Matching PostgreSQL source archive","sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"label":"PostgreSQL 18 English manual: catalog-pg-operator.html","path":"catalog-pg-operator.html","sha256":"e0b1817914e5e8f9037955cd41e9a43584e9227fcc115784898ecdd9a6c0ecd6","url":"/docs/18/catalog-pg-operator.html"},{"label":"PostgreSQL 18 English manual: catalog-pg-amop.html","path":"catalog-pg-amop.html","sha256":"e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1","url":"/docs/18/catalog-pg-amop.html"},{"label":"PostgreSQL 18 English manual: functions-array.html","path":"functions-array.html","sha256":"d84446981971a18b9bab327f3c737737f8cc290dd9963d1472c7e6cab60bea7c","url":"/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE"}]},"MeasuredEvidence":{}},"Text":{"Collection":"operator","Key":"op-403e-anyarray-anyarray","SourceDatabase":"center","Version":"18","Locale":"en","Title":"@\u003e(anyarray,anyarray)","Summary":"contains","BodyHTML":"\u003cp\u003econtains\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"26697a74460484eb7aeb69559a4797780b57873f8102b8b1546ea6c713e9fb04","Payload":{"description":["contains"],"related":[{"label":"anyarray data type","url":"/wiki/type/anyarray/?v=18"},{"label":"bool data type","url":"/wiki/type/bool/?v=18"},{"label":"Commutator: \u003c@(anyarray,anyarray)","url":"/wiki/operator/op-3c40-anyarray-anyarray/?v=18"},{"label":"gin/array_ops family","url":"/wiki/opclass/family-gin-array_ops/?v=18"}],"sections":[{"paragraphs":["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.)","ARRAY[1,4,3] @\u003e ARRAY[3,1,3] → t"],"title":"English manual definition"},{"paragraphs":["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."],"title":"Catalog interpretation"}],"tables":[{"columns":[{"key":"method","label":"Index AM"},{"key":"family","label":"Family"},{"key":"strategy","label":"Strategy"},{"key":"purpose","label":"Purpose"},{"key":"sort_family","label":"Ordering family"}],"key":"memberships","rows":[{"family":{"text":"array_ops","url":"/wiki/opclass/family-gin-array_ops/?v=18"},"method":{"text":"GIN","url":"/wiki/indexam/gin/?v=18"},"purpose":"search","sort_family":"","strategy":"2"}],"title":"Declared operator-family membership"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}