{"Entry":{"collection":"operator","key":"op-3c3c-inet-inet","name":"\u003c\u003c(inet,inet)","aliases":["\u003c\u003c","\u003c\u003c(inet,inet)"],"metadata":{"aliases":["\u003c\u003c","\u003c\u003c(inet,inet)"],"category":"Network addresses","content_hash":"4b509db92eefed63c066d7d54101b0971c85ce55d318f4c6cf36c5e371e32e07","imported_at":"2026-09-30T00:40:41.673308+08:00","name":"\u003c\u003c(inet,inet)","name_zh":"","slug":"op-3c3c-inet-inet","summary":"is subnet"}},"Definition":{"Collection":"operator","Key":"op-3c3c-inet-inet","SourceDatabase":"center","Version":"18","SourceTable":"pg_operator_entry","SourceKey":"op-3c3c-inet-inet","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"aliases":["\u003c\u003c","\u003c\u003c(inet,inet)"],"comparison_data":{"memberships":[{"family":"network_inclusion_ops","left_type":"inet","method":"brin","operator":"\u003c\u003c(inet,inet)","purpose":"search","right_type":"inet","sort_family":"","strategy":"26"},{"family":"network_ops","left_type":"inet","method":"gist","operator":"\u003c\u003c(inet,inet)","purpose":"search","right_type":"inet","sort_family":"","strategy":"24"},{"family":"network_ops","left_type":"inet","method":"spgist","operator":"\u003c\u003c(inet,inet)","purpose":"search","right_type":"inet","sort_family":"","strategy":"24"}],"operator":{"commutator":"\u003e\u003e(inet,inet)","function":"network_sub(inet,inet)","hash_join":"f","kind":"b","left_type":"inet","merge_join":"f","negator":"","result_type":"bool","right_type":"inet","symbol":"\u003c\u003c"}},"comparison_hash":"d42adb90295a56bfb804854ebc4a868e8f5cfb8aff948a3e98e8253030f20ecb","description":["is subnet"],"facts":[{"label":"Left operand","value":"inet"},{"label":"Right operand","value":"inet"},{"label":"Result type","value":"bool"},{"label":"Implementing function","value":"network_sub(inet,inet)"},{"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":"is subnet","family":"network_ops","family_slug":"family-gist-network_ops","left_type":"inet","method":"gist","operator":"\u003c\u003c(inet,inet)","operator_slug":"op-3c3c-inet-inet","purpose":"search","result_type":"bool","right_type":"inet","sort_family":"","sort_family_slug":"","strategy":"24"},{"description":"is subnet","family":"network_ops","family_slug":"family-spgist-network_ops","left_type":"inet","method":"spgist","operator":"\u003c\u003c(inet,inet)","operator_slug":"op-3c3c-inet-inet","purpose":"search","result_type":"bool","right_type":"inet","sort_family":"","sort_family_slug":"","strategy":"24"},{"description":"is subnet","family":"network_inclusion_ops","family_slug":"family-brin-network_inclusion_ops","left_type":"inet","method":"brin","operator":"\u003c\u003c(inet,inet)","operator_slug":"op-3c3c-inet-inet","purpose":"search","result_type":"bool","right_type":"inet","sort_family":"","sort_family_slug":"","strategy":"26"}],"operator":{"commutator":"\u003e\u003e(inet,inet)","function":"network_sub(inet,inet)","hash_join":"f","kind":"b","left_type":"inet","merge_join":"f","negator":"","result_type":"bool","right_type":"inet","symbol":"\u003c\u003c"},"related":[{"label":"inet data type","url":"/wiki/type/inet/?v=18"},{"label":"bool data type","url":"/wiki/type/bool/?v=18"},{"label":"Commutator: \u003e\u003e(inet,inet)","url":"/wiki/operator/op-3e3e-inet-inet/?v=18"},{"label":"gist/network_ops family","url":"/wiki/opclass/family-gist-network_ops/?v=18"},{"label":"spgist/network_ops family","url":"/wiki/opclass/family-spgist-network_ops/?v=18"},{"label":"brin/network_inclusion_ops family","url":"/wiki/opclass/family-brin-network_inclusion_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":["Is subnet strictly contained by subnet? This operator, and the next four, test for subnet inclusion. They consider only the network parts of the two addresses (ignoring any bits to the right of the netmasks) and determine whether one network is identical to or a subnet of the other.","inet '192.168.1.5' \u003c\u003c inet '192.168.1/24' → t","inet '192.168.0.5' \u003c\u003c inet '192.168.1/24' → f","inet '192.168.1/24' \u003c\u003c inet '192.168.1/24' → f"],"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":"\u003c\u003c(inet,inet) → bool","source_oid":"931","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-net.html","path":"functions-net.html","sha256":"6685d0c85e49d8995caaaf39c4435d6fe4e8c4e3f88a1c8312de4d870a9adcc6","url":"/docs/18/functions-net.html#CIDR-INET-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":"network_ops","url":"/wiki/opclass/family-gist-network_ops/?v=18"},"method":{"text":"GiST","url":"/wiki/indexam/gist/?v=18"},"purpose":"search","sort_family":"","strategy":"24"},{"family":{"text":"network_ops","url":"/wiki/opclass/family-spgist-network_ops/?v=18"},"method":{"text":"SP-GiST","url":"/wiki/indexam/spgist/?v=18"},"purpose":"search","sort_family":"","strategy":"24"},{"family":{"text":"network_inclusion_ops","url":"/wiki/opclass/family-brin-network_inclusion_ops/?v=18"},"method":{"text":"BRIN","url":"/wiki/indexam/brin/?v=18"},"purpose":"search","sort_family":"","strategy":"26"}],"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-net.html","path":"functions-net.html","sha256":"6685d0c85e49d8995caaaf39c4435d6fe4e8c4e3f88a1c8312de4d870a9adcc6","url":"/docs/18/functions-net.html#CIDR-INET-OPERATORS-TABLE"}]},"MeasuredEvidence":{}},"Text":{"Collection":"operator","Key":"op-3c3c-inet-inet","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\u003c\u003c(inet,inet)","Summary":"is subnet","BodyHTML":"\u003cp\u003eis subnet\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"b353a5c32df92449d7d221085a8f320a3a43c7c3f1f24915403db8ca75cbc0d4","Payload":{"description":["is subnet"],"related":[{"label":"inet data type","url":"/wiki/type/inet/?v=18"},{"label":"bool data type","url":"/wiki/type/bool/?v=18"},{"label":"Commutator: \u003e\u003e(inet,inet)","url":"/wiki/operator/op-3e3e-inet-inet/?v=18"},{"label":"gist/network_ops family","url":"/wiki/opclass/family-gist-network_ops/?v=18"},{"label":"spgist/network_ops family","url":"/wiki/opclass/family-spgist-network_ops/?v=18"},{"label":"brin/network_inclusion_ops family","url":"/wiki/opclass/family-brin-network_inclusion_ops/?v=18"}],"sections":[{"paragraphs":["Is subnet strictly contained by subnet? This operator, and the next four, test for subnet inclusion. They consider only the network parts of the two addresses (ignoring any bits to the right of the netmasks) and determine whether one network is identical to or a subnet of the other.","inet '192.168.1.5' \u003c\u003c inet '192.168.1/24' → t","inet '192.168.0.5' \u003c\u003c inet '192.168.1/24' → f","inet '192.168.1/24' \u003c\u003c inet '192.168.1/24' → f"],"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":"network_ops","url":"/wiki/opclass/family-gist-network_ops/?v=18"},"method":{"text":"GiST","url":"/wiki/indexam/gist/?v=18"},"purpose":"search","sort_family":"","strategy":"24"},{"family":{"text":"network_ops","url":"/wiki/opclass/family-spgist-network_ops/?v=18"},"method":{"text":"SP-GiST","url":"/wiki/indexam/spgist/?v=18"},"purpose":"search","sort_family":"","strategy":"24"},{"family":{"text":"network_inclusion_ops","url":"/wiki/opclass/family-brin-network_inclusion_ops/?v=18"},"method":{"text":"BRIN","url":"/wiki/indexam/brin/?v=18"},"purpose":"search","sort_family":"","strategy":"26"}],"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}