{"Entry":{"collection":"operator","key":"op-403e-_aclitem-aclitem","name":"@\u003e(_aclitem,aclitem)","aliases":["@\u003e","@\u003e(_aclitem,aclitem)"],"metadata":{"aliases":["@\u003e","@\u003e(_aclitem,aclitem)"],"category":"Internal and special-purpose","content_hash":"4047d55502e321e6e5b595974f9995f1f9467159056c5be578d04a769c71325d","imported_at":"2026-09-30T00:40:43.537175+08:00","name":"@\u003e(_aclitem,aclitem)","name_zh":"","slug":"op-403e-_aclitem-aclitem","summary":"contains"}},"Definition":{"Collection":"operator","Key":"op-403e-_aclitem-aclitem","SourceDatabase":"center","Version":"18","SourceTable":"pg_operator_entry","SourceKey":"op-403e-_aclitem-aclitem","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"aliases":["@\u003e","@\u003e(_aclitem,aclitem)"],"comparison_data":{"memberships":[],"operator":{"commutator":"","function":"aclcontains(_aclitem,aclitem)","hash_join":"f","kind":"b","left_type":"_aclitem","merge_join":"f","negator":"","result_type":"bool","right_type":"aclitem","symbol":"@\u003e"}},"comparison_hash":"c008ef0480ab9d4df5e2d0cbacdd88f45897e8281f046e8add6a72ad19c46d55","description":["contains"],"facts":[{"label":"Left operand","value":"_aclitem"},{"label":"Right operand","value":"aclitem"},{"label":"Result type","value":"bool"},{"label":"Implementing function","value":"aclcontains(_aclitem,aclitem)"},{"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":[],"operator":{"commutator":"","function":"aclcontains(_aclitem,aclitem)","hash_join":"f","kind":"b","left_type":"_aclitem","merge_join":"f","negator":"","result_type":"bool","right_type":"aclitem","symbol":"@\u003e"},"related":[{"label":"_aclitem data type","url":"/wiki/type/arrays/?v=18"},{"label":"aclitem data type","url":"/wiki/type/aclitem/?v=18"},{"label":"bool data type","url":"/wiki/type/bool/?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 array contain the specified privileges? (This is true if there is an array entry that matches the aclitem 's grantee and grantor, and has at least the specified set of privileges.)","'{calvin=r*w/hobbes,hobbes=r*w*/postgres}'::aclitem[] @\u003e 'calvin=r*/hobbes'::aclitem → 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(_aclitem,aclitem) → bool","source_oid":"968","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-info.html","path":"functions-info.html","sha256":"78ac80bf81da2e4f4a33f3b850faa86f0f58ec54a083d6c31da557907de0df87","url":"/docs/18/functions-info.html#FUNCTIONS-ACLITEM-OP-TABLE"}],"tables":[]},"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-info.html","path":"functions-info.html","sha256":"78ac80bf81da2e4f4a33f3b850faa86f0f58ec54a083d6c31da557907de0df87","url":"/docs/18/functions-info.html#FUNCTIONS-ACLITEM-OP-TABLE"}]},"MeasuredEvidence":{}},"Text":{"Collection":"operator","Key":"op-403e-_aclitem-aclitem","SourceDatabase":"center","Version":"18","Locale":"en","Title":"@\u003e(_aclitem,aclitem)","Summary":"contains","BodyHTML":"\u003cp\u003econtains\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"98ad9ee0be06128780b67a1e8004236d0738e73dd851573bae0ee7ad3c58b5b5","Payload":{"description":["contains"],"related":[{"label":"_aclitem data type","url":"/wiki/type/arrays/?v=18"},{"label":"aclitem data type","url":"/wiki/type/aclitem/?v=18"},{"label":"bool data type","url":"/wiki/type/bool/?v=18"}],"sections":[{"paragraphs":["Does array contain the specified privileges? (This is true if there is an array entry that matches the aclitem 's grantee and grantor, and has at least the specified set of privileges.)","'{calvin=r*w/hobbes,hobbes=r*w*/postgres}'::aclitem[] @\u003e 'calvin=r*/hobbes'::aclitem → 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":[]}},"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}