{"Entry":{"collection":"operator","key":"op-3c-oid8-oid8","name":"\u003c(oid8,oid8)","aliases":["\u003c","\u003c(oid8,oid8)"],"metadata":{"aliases":["\u003c","\u003c(oid8,oid8)"],"category":"Object and transaction identifiers","content_hash":"3b12c2a16b5a7c805d8ac195f9771e05c792f6bbb676d365ead39c5b1ba25082","imported_at":"2026-09-30T00:40:41.425982+08:00","name":"\u003c(oid8,oid8)","name_zh":"","slug":"op-3c-oid8-oid8","summary":"less than"}},"Definition":{"Collection":"operator","Key":"op-3c-oid8-oid8","SourceDatabase":"center","Version":"20","SourceTable":"pg_operator_entry","SourceKey":"op-3c-oid8-oid8","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","Facts":{"aliases":["\u003c","\u003c(oid8,oid8)"],"comparison_data":{"memberships":[{"family":"oid8_ops","left_type":"oid8","method":"btree","operator":"\u003c(oid8,oid8)","purpose":"search","right_type":"oid8","sort_family":"","strategy":"1"}],"operator":{"commutator":"\u003e(oid8,oid8)","function":"oid8lt(oid8,oid8)","hash_join":"f","kind":"b","left_type":"oid8","merge_join":"f","negator":"\u003e=(oid8,oid8)","result_type":"bool","right_type":"oid8","symbol":"\u003c"}},"comparison_hash":"59ac479c5049b4067697a45aaaf9c90f4e5dded40985da27500145b3a53fd702","description":["less than"],"facts":[{"label":"Left operand","value":"oid8"},{"label":"Right operand","value":"oid8"},{"label":"Result type","value":"bool"},{"label":"Implementing function","value":"oid8lt(oid8,oid8)"},{"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":"less than","family":"oid8_ops","family_slug":"family-btree-oid8_ops","left_type":"oid8","method":"btree","operator":"\u003c(oid8,oid8)","operator_slug":"op-3c-oid8-oid8","purpose":"search","result_type":"bool","right_type":"oid8","sort_family":"","sort_family_slug":"","strategy":"1"}],"operator":{"commutator":"\u003e(oid8,oid8)","function":"oid8lt(oid8,oid8)","hash_join":"f","kind":"b","left_type":"oid8","merge_join":"f","negator":"\u003e=(oid8,oid8)","result_type":"bool","right_type":"oid8","symbol":"\u003c"},"related":[{"label":"oid8 data type","url":"/wiki/type/oid8/?v=20"},{"label":"bool data type","url":"/wiki/type/bool/?v=20"},{"label":"Commutator: \u003e(oid8,oid8)","url":"/wiki/operator/op-3e-oid8-oid8/?v=20"},{"label":"Negator: \u003e=(oid8,oid8)","url":"/wiki/operator/op-3e3d-oid8-oid8/?v=20"},{"label":"btree/oid8_ops family","url":"/wiki/opclass/family-btree-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":"\u003c(oid8,oid8) → bool","source_oid":"6445","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":"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-3c-oid8-oid8","SourceDatabase":"center","Version":"20","Locale":"en","Title":"\u003c(oid8,oid8)","Summary":"less than","BodyHTML":"\u003cp\u003eless than\u003c/p\u003e","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","ContentHash":"7f13cdd77dfe004c379240a79cefef0b64a57abcd4f9b7344e8ec2992bb66b9f","Payload":{"description":["less than"],"related":[{"label":"oid8 data type","url":"/wiki/type/oid8/?v=20"},{"label":"bool data type","url":"/wiki/type/bool/?v=20"},{"label":"Commutator: \u003e(oid8,oid8)","url":"/wiki/operator/op-3e-oid8-oid8/?v=20"},{"label":"Negator: \u003e=(oid8,oid8)","url":"/wiki/operator/op-3e3d-oid8-oid8/?v=20"},{"label":"btree/oid8_ops family","url":"/wiki/opclass/family-btree-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":"1"}],"title":"Declared operator-family membership"}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}