{"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","derived_content_hash":"c8513e2c9c54ab24f2f9274e24581f660b011f246df89e0aa5448bb7e64ddcb9","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"],"description_zh":"是子网。","description_zh_html":"\u003cp\u003e是子网。\u003c/p\u003e\u003cdl\u003e\u003cdt\u003e种类\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003eb\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e符号\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003e\u0026lt;\u0026lt;\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e实现函数\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003enetwork_sub(inet,inet)\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e可用于哈希连接\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003e否\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e左操作数类型\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003einet\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e交换运算符\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003e\u0026gt;\u0026gt;(inet,inet)\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e可用于归并连接\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003e否\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e右操作数类型\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003einet\u003c/code\u003e\u003c/dd\u003e\u003cdt\u003e结果类型\u003c/dt\u003e\u003cdd\u003e\u003ccode\u003ebool\u003c/code\u003e\u003c/dd\u003e\u003c/dl\u003e\u003ch3\u003e同版本中文手册节选\u003c/h3\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 9.39. IP 地址操作符\u003c/strong\u003e\u003c/p\u003e\u003cp\u003e\u003ca href=\"/zh/docs/18/functions-net.html#CIDR-INET-OPERATORS-TABLE\"\u003e查看完整中文手册与上下文\u003c/a\u003e。\u003c/p\u003e\u003cp\u003e本页开头的中文说明为 PG.CENTER 对源码说明的翻译；手册节选保留对应版本中文文档原文。源码信息及手册示例不代表重新进行过运行测试。\u003c/p\u003e","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"}],"facts_zh":[{"label":"左操作数","value":"inet"},{"label":"右操作数","value":"inet"},{"label":"返回类型","value":"bool"},{"label":"实现函数","value":"network_sub(inet,inet)"},{"label":"操作符种类","value":"Binary"},{"label":"可用于哈希连接","value":"否"},{"label":"可用于归并连接","value":"否"}],"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"}],"sections_zh":[{"paragraphs":["子网是否严格包含在另一个子网中？这个操作符和后续四个操作符测试子网包含关系。它们只考虑两个地址的网络部分（忽略网络掩码右侧的所有位），并判断一个网络是否与另一个网络相同，或是另一个网络的子网。","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":"英文手册定义"},{"paragraphs":["目录 pg_operator 存储关于操作符的信息。详见 CREATE OPERATOR 和 第 36.14 节 。"],"title":"目录记录解读"}],"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"}],"tables_zh":[{"columns":[{"key":"method","label":"索引访问方法"},{"key":"family","label":"操作符家族"},{"key":"strategy","label":"策略"},{"key":"purpose","label":"用途"},{"key":"sort_family","label":"排序家族"}],"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":"搜索","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":"搜索","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":"搜索","sort_family":"","strategy":"26"}],"title":"声明的操作符家族成员关系"}],"zh_from":{"authored_translation":"authored-translation-of-source-description","body_sha256":"d7d715be93b633d8b5667f1a38f6d0558355e10e46b2cae96c56c3eb723d273f","kind":"same-version-chinese-manual-with-authored-translation-of-source-description","manual":{"anchor":"CIDR-INET-OPERATORS-TABLE","build_id":107,"extraction":"concept-introduction","fragment_sha256":"ceee3afb1b40d38a9c4f19d8159a6ae3f529fe1348805c52af47cecf6ec63d7c","locale":"zh-Hans","page_key":"functions-net.html","source_hash":"f7bc82e79db54043a600f7fd78cd812affe41981686a58e1156921fdd998606d","source_revision":"unknown:rendered-translation-baseline","translated_from_revision":null,"translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","url":"/zh/docs/18/functions-net.html#CIDR-INET-OPERATORS-TABLE","version":"18"},"runtime_rerun":false,"source_facts_revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}},"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":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}