{"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","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"],"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"}],"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"}],"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"}]},"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":"zh-Hans","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}