{"Entry":{"collection":"operator","key":"op-40-box-box","name":"@(box,box)","aliases":["@","@(box,box)"],"metadata":{"aliases":["@","@(box,box)"],"category":"Geometric","content_hash":"55f7ea6063f360aefc74670816ea65343b5dd1aefe831043636fdd8c2490042e","imported_at":"2026-09-30T00:40:43.483547+08:00","name":"@(box,box)","name_zh":"","slug":"op-40-box-box","summary":"deprecated, use \u003c@ instead"}},"Definition":{"Collection":"operator","Key":"op-40-box-box","SourceDatabase":"center","Version":"13","SourceTable":"pg_operator_entry","SourceKey":"op-40-box-box","SourceRevision":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","Facts":{"aliases":["@","@(box,box)"],"comparison_data":{"memberships":[{"family":"box_ops","left_type":"box","method":"gist","operator":"@(box,box)","purpose":"search","right_type":"box","sort_family":"","strategy":"14"}],"operator":{"commutator":"~(box,box)","function":"box_contained(box,box)","hash_join":"f","kind":"b","left_type":"box","merge_join":"f","negator":"","result_type":"bool","right_type":"box","symbol":"@"}},"comparison_hash":"7456f2203fde50db22a6d3578e8f0e9b7f1c2f7b4d3bf379124d4290174cfc7b","description":["deprecated, use \u003c@ instead"],"facts":[{"label":"Left operand","value":"box"},{"label":"Right operand","value":"box"},{"label":"Result type","value":"bool"},{"label":"Implementing function","value":"box_contained(box,box)"},{"label":"Operator kind","value":"Binary"},{"label":"Hash join candidate","value":"no"},{"label":"Merge join candidate","value":"no"}],"manual_semantics":"Source catalog description; no additional matching manual operator definition claimed","memberships":[{"description":"deprecated, use \u003c@ instead","family":"box_ops","family_slug":"family-gist-box_ops","left_type":"box","method":"gist","operator":"@(box,box)","operator_slug":"op-40-box-box","purpose":"search","result_type":"bool","right_type":"box","sort_family":"","sort_family_slug":"","strategy":"14"}],"operator":{"commutator":"~(box,box)","function":"box_contained(box,box)","hash_join":"f","kind":"b","left_type":"box","merge_join":"f","negator":"","result_type":"bool","right_type":"box","symbol":"@"},"related":[{"label":"box data type","url":"/wiki/type/box/?v=13"},{"label":"bool data type","url":"/wiki/type/bool/?v=13"},{"label":"Commutator: ~(box,box)","url":"/wiki/operator/op-7e-box-box/?v=13"},{"label":"gist/box_ops family","url":"/wiki/opclass/family-gist-box_ops/?v=13"}],"release":{"catalog_fingerprint":"df58d29b226fbb90326087233d7970032abdec1352373270449eeee324f84a35","channel":"historical","label":"13.23","major":"13","manual_fingerprint":"2bbea71f4723fc9e4e58cfdb28368763f999de2800d45ade748f7c7546dfb9d3","ref":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2","revision":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","source_sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"},"sections":[{"paragraphs":["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 37.14 for more information.","Unused columns contain zeroes. For example, oprleft is zero for a prefix operator."],"title":"Catalog interpretation"}],"signature":"@(box,box) → bool","source_oid":"2862","sources":[{"label":"Matching PostgreSQL source archive","sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","url":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2"},{"label":"PostgreSQL 13 English manual: catalog-pg-operator.html","path":"catalog-pg-operator.html","sha256":"1a325d2fa41f711c0a7fa6b57e37e8e98a59f218e01112e0767c455c1b5818a1","url":"/docs/13/catalog-pg-operator.html"},{"label":"PostgreSQL 13 English manual: catalog-pg-amop.html","path":"catalog-pg-amop.html","sha256":"7a8e67f8dc59c305612c6d029fc8760c092f27203d5338c6db6c6d9b8aabc561","url":"/docs/13/catalog-pg-amop.html"}],"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":"box_ops","url":"/wiki/opclass/family-gist-box_ops/?v=13"},"method":{"text":"GiST","url":"/wiki/indexam/gist/?v=13"},"purpose":"search","sort_family":"","strategy":"14"}],"title":"Declared operator-family membership"}]},"ManualEvidence":{"release":{"catalog_fingerprint":"df58d29b226fbb90326087233d7970032abdec1352373270449eeee324f84a35","channel":"historical","label":"13.23","major":"13","manual_fingerprint":"2bbea71f4723fc9e4e58cfdb28368763f999de2800d45ade748f7c7546dfb9d3","ref":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2","revision":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","source_sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"},"sources":[{"label":"Matching PostgreSQL source archive","sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","url":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2"},{"label":"PostgreSQL 13 English manual: catalog-pg-operator.html","path":"catalog-pg-operator.html","sha256":"1a325d2fa41f711c0a7fa6b57e37e8e98a59f218e01112e0767c455c1b5818a1","url":"/docs/13/catalog-pg-operator.html"},{"label":"PostgreSQL 13 English manual: catalog-pg-amop.html","path":"catalog-pg-amop.html","sha256":"7a8e67f8dc59c305612c6d029fc8760c092f27203d5338c6db6c6d9b8aabc561","url":"/docs/13/catalog-pg-amop.html"}]},"MeasuredEvidence":{}},"Text":{"Collection":"operator","Key":"op-40-box-box","SourceDatabase":"center","Version":"13","Locale":"en","Title":"@(box,box)","Summary":"deprecated, use \u003c@ instead","BodyHTML":"\u003cp\u003edeprecated, use \u0026lt;@ instead\u003c/p\u003e","SourceRevision":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","ContentHash":"6b5ce7f8afdb341851e7503db5e5bb30b47d1ecd8fd3043bab3e5e799772490a","Payload":{"description":["deprecated, use \u003c@ instead"],"related":[{"label":"box data type","url":"/wiki/type/box/?v=13"},{"label":"bool data type","url":"/wiki/type/bool/?v=13"},{"label":"Commutator: ~(box,box)","url":"/wiki/operator/op-7e-box-box/?v=13"},{"label":"gist/box_ops family","url":"/wiki/opclass/family-gist-box_ops/?v=13"}],"sections":[{"paragraphs":["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 37.14 for more information.","Unused columns contain zeroes. For example, oprleft is zero for a prefix operator."],"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":"box_ops","url":"/wiki/opclass/family-gist-box_ops/?v=13"},"method":{"text":"GiST","url":"/wiki/indexam/gist/?v=13"},"purpose":"search","sort_family":"","strategy":"14"}],"title":"Declared operator-family membership"}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["10","11","12","13"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}