{"Entry":{"collection":"operator","key":"op-3d-oid8-oid8","name":"=(oid8,oid8)","aliases":["=","=(oid8,oid8)"],"metadata":{"aliases":["=","=(oid8,oid8)"],"category":"Object and transaction identifiers","content_hash":"bbcb52a3716c003a5aeb38216d18aa109e5d0be6b0e8562473baa3ad582d8aab","imported_at":"2026-09-30T00:40:42.641653+08:00","name":"=(oid8,oid8)","name_zh":"","slug":"op-3d-oid8-oid8","summary":"equal"}},"Definition":{"Collection":"operator","Key":"op-3d-oid8-oid8","SourceDatabase":"center","Version":"20","SourceTable":"pg_operator_entry","SourceKey":"op-3d-oid8-oid8","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","Facts":{"aliases":["=","=(oid8,oid8)"],"comparison_data":{"memberships":[{"family":"oid8_ops","left_type":"oid8","method":"btree","operator":"=(oid8,oid8)","purpose":"search","right_type":"oid8","sort_family":"","strategy":"3"},{"family":"oid8_ops","left_type":"oid8","method":"hash","operator":"=(oid8,oid8)","purpose":"search","right_type":"oid8","sort_family":"","strategy":"1"}],"operator":{"commutator":"=(oid8,oid8)","function":"oid8eq(oid8,oid8)","hash_join":"t","kind":"b","left_type":"oid8","merge_join":"t","negator":"\u003c\u003e(oid8,oid8)","result_type":"bool","right_type":"oid8","symbol":"="}},"comparison_hash":"4ba33fa1b7d191d5d512df63880970676961967272bc4c6eae7b6b8c4aaf8bd5","description":["equal"],"facts":[{"label":"Left operand","value":"oid8"},{"label":"Right operand","value":"oid8"},{"label":"Result type","value":"bool"},{"label":"Implementing function","value":"oid8eq(oid8,oid8)"},{"label":"Operator kind","value":"Binary"},{"label":"Hash join candidate","value":"yes"},{"label":"Merge join candidate","value":"yes"}],"manual_semantics":"Source catalog description; no additional matching manual operator definition claimed","memberships":[{"description":"equal","family":"oid8_ops","family_slug":"family-btree-oid8_ops","left_type":"oid8","method":"btree","operator":"=(oid8,oid8)","operator_slug":"op-3d-oid8-oid8","purpose":"search","result_type":"bool","right_type":"oid8","sort_family":"","sort_family_slug":"","strategy":"3"},{"description":"equal","family":"oid8_ops","family_slug":"family-hash-oid8_ops","left_type":"oid8","method":"hash","operator":"=(oid8,oid8)","operator_slug":"op-3d-oid8-oid8","purpose":"search","result_type":"bool","right_type":"oid8","sort_family":"","sort_family_slug":"","strategy":"1"}],"operator":{"commutator":"=(oid8,oid8)","function":"oid8eq(oid8,oid8)","hash_join":"t","kind":"b","left_type":"oid8","merge_join":"t","negator":"\u003c\u003e(oid8,oid8)","result_type":"bool","right_type":"oid8","symbol":"="},"related":[{"label":"oid8 data type","url":"/wiki/type/oid8/?v=20"},{"label":"bool data type","url":"/wiki/type/bool/?v=20"},{"label":"Commutator: =(oid8,oid8)","url":"/wiki/operator/op-3d-oid8-oid8/?v=20"},{"label":"Negator: \u003c\u003e(oid8,oid8)","url":"/wiki/operator/op-3c3e-oid8-oid8/?v=20"},{"label":"btree/oid8_ops family","url":"/wiki/opclass/family-btree-oid8_ops/?v=20"},{"label":"hash/oid8_ops family","url":"/wiki/opclass/family-hash-oid8_ops/?v=20"}],"release":{"catalog_fingerprint":"cc1a474e972c8c342cf17f37e2884c56cc4b114cb59407b0180e99cdcfffa5c5","channel":"devel","label":"20devel","major":"20","manual_fingerprint":"48fb9e20e9e1454fe93d367e75b949833c82c1c52c2b69314dfffe1c464f3f39","ref":"https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2","revision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","source_sha256":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","source_snapshot_utc":"26-Sep-2026 20:22"},"sections":[{"paragraphs":["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."],"title":"Catalog interpretation"}],"signature":"=(oid8,oid8) → bool","source_oid":"6443","sources":[{"label":"Matching PostgreSQL source archive","sha256":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","url":"https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2"},{"label":"PostgreSQL 20 English manual: catalog-pg-operator.html","path":"catalog-pg-operator.html","sha256":"b8882bb8329f1659f719eb9397246146135c228892834fbd29325ed3030f17cb","url":"/docs/devel/catalog-pg-operator.html"},{"label":"PostgreSQL 20 English manual: catalog-pg-amop.html","path":"catalog-pg-amop.html","sha256":"00fee8a631088b687e2d880e4091791ca30f9c69fca888c51ece463d1b9e1e61","url":"/docs/devel/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":"oid8_ops","url":"/wiki/opclass/family-btree-oid8_ops/?v=20"},"method":{"text":"B-tree","url":"/wiki/indexam/btree/?v=20"},"purpose":"search","sort_family":"","strategy":"3"},{"family":{"text":"oid8_ops","url":"/wiki/opclass/family-hash-oid8_ops/?v=20"},"method":{"text":"Hash","url":"/wiki/indexam/hash/?v=20"},"purpose":"search","sort_family":"","strategy":"1"}],"title":"Declared operator-family membership"}]},"ManualEvidence":{"release":{"catalog_fingerprint":"cc1a474e972c8c342cf17f37e2884c56cc4b114cb59407b0180e99cdcfffa5c5","channel":"devel","label":"20devel","major":"20","manual_fingerprint":"48fb9e20e9e1454fe93d367e75b949833c82c1c52c2b69314dfffe1c464f3f39","ref":"https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2","revision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","source_sha256":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","source_snapshot_utc":"26-Sep-2026 20:22"},"sources":[{"label":"Matching PostgreSQL source archive","sha256":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","url":"https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2"},{"label":"PostgreSQL 20 English manual: catalog-pg-operator.html","path":"catalog-pg-operator.html","sha256":"b8882bb8329f1659f719eb9397246146135c228892834fbd29325ed3030f17cb","url":"/docs/devel/catalog-pg-operator.html"},{"label":"PostgreSQL 20 English manual: catalog-pg-amop.html","path":"catalog-pg-amop.html","sha256":"00fee8a631088b687e2d880e4091791ca30f9c69fca888c51ece463d1b9e1e61","url":"/docs/devel/catalog-pg-amop.html"}]},"MeasuredEvidence":{}},"Text":{"Collection":"operator","Key":"op-3d-oid8-oid8","SourceDatabase":"center","Version":"20","Locale":"en","Title":"=(oid8,oid8)","Summary":"equal","BodyHTML":"\u003cp\u003eequal\u003c/p\u003e","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","ContentHash":"5c1d1b305927338c296ca347ade8721ca63b905cab8323a3398a44b17fdb2748","Payload":{"description":["equal"],"related":[{"label":"oid8 data type","url":"/wiki/type/oid8/?v=20"},{"label":"bool data type","url":"/wiki/type/bool/?v=20"},{"label":"Commutator: =(oid8,oid8)","url":"/wiki/operator/op-3d-oid8-oid8/?v=20"},{"label":"Negator: \u003c\u003e(oid8,oid8)","url":"/wiki/operator/op-3c3e-oid8-oid8/?v=20"},{"label":"btree/oid8_ops family","url":"/wiki/opclass/family-btree-oid8_ops/?v=20"},{"label":"hash/oid8_ops family","url":"/wiki/opclass/family-hash-oid8_ops/?v=20"}],"sections":[{"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":"oid8_ops","url":"/wiki/opclass/family-btree-oid8_ops/?v=20"},"method":{"text":"B-tree","url":"/wiki/indexam/btree/?v=20"},"purpose":"search","sort_family":"","strategy":"3"},{"family":{"text":"oid8_ops","url":"/wiki/opclass/family-hash-oid8_ops/?v=20"},"method":{"text":"Hash","url":"/wiki/indexam/hash/?v=20"},"purpose":"search","sort_family":"","strategy":"1"}],"title":"Declared operator-family membership"}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}