{"kind": "operator", "major": "18", "item": {"slug": "op-3c3c-inet-inet", "name": "<<(inet,inet)", "name_zh": "", "category": "Network addresses", "summary": "is subnet", "aliases": ["<<", "<<(inet,inet)"], "content_hash": "4b509db92eefed63c066d7d54101b0971c85ce55d318f4c6cf36c5e371e32e07", "versions": {"10": {"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"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gist-network_ops/?v=10", "text": "network_ops"}, "method": {"url": "/wiki/indexam/gist/?v=10", "text": "GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-spgist-network_ops/?v=10", "text": "network_ops"}, "method": {"url": "/wiki/indexam/spgist/?v=10", "text": "SP-GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=10", "text": "network_inclusion_ops"}, "method": {"url": "/wiki/indexam/brin/?v=10", "text": "BRIN"}, "purpose": "search", "strategy": "26", "sort_family": ""}], "title": "Declared operator-family membership", "columns": [{"key": "method", "label": "Index AM"}, {"key": "family", "label": "Family"}, {"key": "strategy", "label": "Strategy"}, {"key": "purpose", "label": "Purpose"}, {"key": "sort_family", "label": "Ordering family"}]}], "aliases": ["<<", "<<(inet,inet)"], "related": [{"url": "/wiki/type/inet/?v=10", "label": "inet data type"}, {"url": "/wiki/type/bool/?v=10", "label": "bool data type"}, {"url": "/wiki/operator/op-3e3e-inet-inet/?v=10", "label": "Commutator: >>(inet,inet)"}, {"url": "/wiki/opclass/family-gist-network_ops/?v=10", "label": "gist/network_ops family"}, {"url": "/wiki/opclass/family-spgist-network_ops/?v=10", "label": "spgist/network_ops family"}, {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=10", "label": "brin/network_inclusion_ops family"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "label": "10.23", "major": "10", "channel": "historical", "revision": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9", "source_sha256": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9", "manual_fingerprint": "113b870e3ff4b52320f34750da5e740800f3f6e4ed6f2fc00a0891944d1be7c2", "catalog_fingerprint": "dd2d5fd5e17d29184db5f6625f9f0f9b9d40ae7aa34b6ccf28ddbc8684bd4992"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9"}, {"url": "/docs/10/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 10 English manual: catalog-pg-operator.html", "sha256": "1264240e312e88b54064702e9716b8d21fec2f06d1e3a9568f88a01f19f722df"}, {"url": "/docs/10/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 10 English manual: catalog-pg-amop.html", "sha256": "d5ce5a3be599e5506edbe3ff615674beb013720953f4979a44b6ecfd4cc24090"}], "operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "sections": [{"title": "Catalog interpretation", "paragraphs": ["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 37.12 for more information.", "Unused columns contain zeroes. For example, oprleft is zero for a prefix operator."]}], "signature": "<<(inet,inet) \u2192 bool", "source_oid": "931", "description": ["is subnet"], "memberships": [{"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-gist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-spgist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-brin-network_inclusion_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}], "comparison_data": {"operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "memberships": [{"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}]}, "comparison_hash": "d42adb90295a56bfb804854ebc4a868e8f5cfb8aff948a3e98e8253030f20ecb", "manual_semantics": "Source catalog description; no additional matching manual operator definition claimed"}, "11": {"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"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gist-network_ops/?v=11", "text": "network_ops"}, "method": {"url": "/wiki/indexam/gist/?v=11", "text": "GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-spgist-network_ops/?v=11", "text": "network_ops"}, "method": {"url": "/wiki/indexam/spgist/?v=11", "text": "SP-GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=11", "text": "network_inclusion_ops"}, "method": {"url": "/wiki/indexam/brin/?v=11", "text": "BRIN"}, "purpose": "search", "strategy": "26", "sort_family": ""}], "title": "Declared operator-family membership", "columns": [{"key": "method", "label": "Index AM"}, {"key": "family", "label": "Family"}, {"key": "strategy", "label": "Strategy"}, {"key": "purpose", "label": "Purpose"}, {"key": "sort_family", "label": "Ordering family"}]}], "aliases": ["<<", "<<(inet,inet)"], "related": [{"url": "/wiki/type/inet/?v=11", "label": "inet data type"}, {"url": "/wiki/type/bool/?v=11", "label": "bool data type"}, {"url": "/wiki/operator/op-3e3e-inet-inet/?v=11", "label": "Commutator: >>(inet,inet)"}, {"url": "/wiki/opclass/family-gist-network_ops/?v=11", "label": "gist/network_ops family"}, {"url": "/wiki/opclass/family-spgist-network_ops/?v=11", "label": "spgist/network_ops family"}, {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=11", "label": "brin/network_inclusion_ops family"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "label": "11.22", "major": "11", "channel": "historical", "revision": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0", "source_sha256": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0", "manual_fingerprint": "99c9e45d34555f000789cb4e019492e838041c1f2f31d840f3051ff9d7ed9118", "catalog_fingerprint": "4f08eb8c7ac7d09abfbb29a172148a44b8fb72026616bb55a5f8f84db7a38785"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, {"url": "/docs/11/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 11 English manual: catalog-pg-operator.html", "sha256": "3de94bb7f17052a69cf35056c95cac18bf74de96ea2c7b243165f1eeb6a3d587"}, {"url": "/docs/11/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 11 English manual: catalog-pg-amop.html", "sha256": "c17d050a6f2d093de2c343242bcc4d446b936de1d2902727d3fa3b0697b44fd3"}], "operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "sections": [{"title": "Catalog interpretation", "paragraphs": ["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 38.13 for more information.", "Unused columns contain zeroes. For example, oprleft is zero for a prefix operator."]}], "signature": "<<(inet,inet) \u2192 bool", "source_oid": "931", "description": ["is subnet"], "memberships": [{"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-gist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-spgist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-brin-network_inclusion_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}], "comparison_data": {"operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "memberships": [{"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}]}, "comparison_hash": "d42adb90295a56bfb804854ebc4a868e8f5cfb8aff948a3e98e8253030f20ecb", "manual_semantics": "Source catalog description; no additional matching manual operator definition claimed"}, "12": {"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"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gist-network_ops/?v=12", "text": "network_ops"}, "method": {"url": "/wiki/indexam/gist/?v=12", "text": "GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-spgist-network_ops/?v=12", "text": "network_ops"}, "method": {"url": "/wiki/indexam/spgist/?v=12", "text": "SP-GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=12", "text": "network_inclusion_ops"}, "method": {"url": "/wiki/indexam/brin/?v=12", "text": "BRIN"}, "purpose": "search", "strategy": "26", "sort_family": ""}], "title": "Declared operator-family membership", "columns": [{"key": "method", "label": "Index AM"}, {"key": "family", "label": "Family"}, {"key": "strategy", "label": "Strategy"}, {"key": "purpose", "label": "Purpose"}, {"key": "sort_family", "label": "Ordering family"}]}], "aliases": ["<<", "<<(inet,inet)"], "related": [{"url": "/wiki/type/inet/?v=12", "label": "inet data type"}, {"url": "/wiki/type/bool/?v=12", "label": "bool data type"}, {"url": "/wiki/operator/op-3e3e-inet-inet/?v=12", "label": "Commutator: >>(inet,inet)"}, {"url": "/wiki/opclass/family-gist-network_ops/?v=12", "label": "gist/network_ops family"}, {"url": "/wiki/opclass/family-spgist-network_ops/?v=12", "label": "spgist/network_ops family"}, {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=12", "label": "brin/network_inclusion_ops family"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "label": "12.22", "major": "12", "channel": "historical", "revision": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b", "source_sha256": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b", "manual_fingerprint": "535df36baec2140f211303631c0a3f64e02d2673b9d34cb050d247997c94bd1e", "catalog_fingerprint": "1f423fd3c5fb61c039f8814116ce19dedbb2804bc864599818e88cbc4f5f284a"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, {"url": "/docs/12/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 12 English manual: catalog-pg-operator.html", "sha256": "e3f4410bbe926fcc950323b3358f3be85a42e2552afd5938562f725df6675cdb"}, {"url": "/docs/12/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 12 English manual: catalog-pg-amop.html", "sha256": "84b91a9d763b1fb2968cc8be226a0369d31a6acb2468eb56cfd0b8d2030d1b45"}], "operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "sections": [{"title": "Catalog interpretation", "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."]}], "signature": "<<(inet,inet) \u2192 bool", "source_oid": "931", "description": ["is subnet"], "memberships": [{"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-gist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-spgist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-brin-network_inclusion_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}], "comparison_data": {"operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "memberships": [{"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}]}, "comparison_hash": "d42adb90295a56bfb804854ebc4a868e8f5cfb8aff948a3e98e8253030f20ecb", "manual_semantics": "Source catalog description; no additional matching manual operator definition claimed"}, "13": {"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"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gist-network_ops/?v=13", "text": "network_ops"}, "method": {"url": "/wiki/indexam/gist/?v=13", "text": "GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-spgist-network_ops/?v=13", "text": "network_ops"}, "method": {"url": "/wiki/indexam/spgist/?v=13", "text": "SP-GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=13", "text": "network_inclusion_ops"}, "method": {"url": "/wiki/indexam/brin/?v=13", "text": "BRIN"}, "purpose": "search", "strategy": "26", "sort_family": ""}], "title": "Declared operator-family membership", "columns": [{"key": "method", "label": "Index AM"}, {"key": "family", "label": "Family"}, {"key": "strategy", "label": "Strategy"}, {"key": "purpose", "label": "Purpose"}, {"key": "sort_family", "label": "Ordering family"}]}], "aliases": ["<<", "<<(inet,inet)"], "related": [{"url": "/wiki/type/inet/?v=13", "label": "inet data type"}, {"url": "/wiki/type/bool/?v=13", "label": "bool data type"}, {"url": "/wiki/operator/op-3e3e-inet-inet/?v=13", "label": "Commutator: >>(inet,inet)"}, {"url": "/wiki/opclass/family-gist-network_ops/?v=13", "label": "gist/network_ops family"}, {"url": "/wiki/opclass/family-spgist-network_ops/?v=13", "label": "spgist/network_ops family"}, {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=13", "label": "brin/network_inclusion_ops family"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "label": "13.23", "major": "13", "channel": "historical", "revision": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6", "source_sha256": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6", "manual_fingerprint": "2bbea71f4723fc9e4e58cfdb28368763f999de2800d45ade748f7c7546dfb9d3", "catalog_fingerprint": "df58d29b226fbb90326087233d7970032abdec1352373270449eeee324f84a35"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, {"url": "/docs/13/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 13 English manual: catalog-pg-operator.html", "sha256": "1a325d2fa41f711c0a7fa6b57e37e8e98a59f218e01112e0767c455c1b5818a1"}, {"url": "/docs/13/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 13 English manual: catalog-pg-amop.html", "sha256": "7a8e67f8dc59c305612c6d029fc8760c092f27203d5338c6db6c6d9b8aabc561"}, {"url": "/docs/13/functions-net.html#CIDR-INET-OPERATORS-TABLE", "path": "functions-net.html", "label": "PostgreSQL 13 English manual: functions-net.html", "sha256": "9816c404116c5409f85c602d176bc16364051b876666eb447c8430d6c0c89e43"}], "operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "sections": [{"title": "English manual definition", "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' << inet '192.168.1/24' \u2192 t", "inet '192.168.0.5' << inet '192.168.1/24' \u2192 f", "inet '192.168.1/24' << inet '192.168.1/24' \u2192 f"]}, {"title": "Catalog interpretation", "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."]}], "signature": "<<(inet,inet) \u2192 bool", "source_oid": "931", "description": ["is subnet"], "memberships": [{"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-gist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-spgist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-brin-network_inclusion_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}], "comparison_data": {"operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "memberships": [{"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}]}, "comparison_hash": "d42adb90295a56bfb804854ebc4a868e8f5cfb8aff948a3e98e8253030f20ecb", "manual_semantics": "Exact operand/result signature matched"}, "14": {"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"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gist-network_ops/?v=14", "text": "network_ops"}, "method": {"url": "/wiki/indexam/gist/?v=14", "text": "GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-spgist-network_ops/?v=14", "text": "network_ops"}, "method": {"url": "/wiki/indexam/spgist/?v=14", "text": "SP-GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=14", "text": "network_inclusion_ops"}, "method": {"url": "/wiki/indexam/brin/?v=14", "text": "BRIN"}, "purpose": "search", "strategy": "26", "sort_family": ""}], "title": "Declared operator-family membership", "columns": [{"key": "method", "label": "Index AM"}, {"key": "family", "label": "Family"}, {"key": "strategy", "label": "Strategy"}, {"key": "purpose", "label": "Purpose"}, {"key": "sort_family", "label": "Ordering family"}]}], "aliases": ["<<", "<<(inet,inet)"], "related": [{"url": "/wiki/type/inet/?v=14", "label": "inet data type"}, {"url": "/wiki/type/bool/?v=14", "label": "bool data type"}, {"url": "/wiki/operator/op-3e3e-inet-inet/?v=14", "label": "Commutator: >>(inet,inet)"}, {"url": "/wiki/opclass/family-gist-network_ops/?v=14", "label": "gist/network_ops family"}, {"url": "/wiki/opclass/family-spgist-network_ops/?v=14", "label": "spgist/network_ops family"}, {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=14", "label": "brin/network_inclusion_ops family"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "label": "14.24", "major": "14", "channel": "stable", "revision": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897", "source_sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897", "manual_fingerprint": "1d055c6dc55d4defe2b6e9d0f842a47005487b21025b67e51d06721d3c122f71", "catalog_fingerprint": "9e0116f26e5ce870719efb77ef7b73e30c7928f8af27cbe87fdea32efe3811ef"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, {"url": "/docs/14/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 14 English manual: catalog-pg-operator.html", "sha256": "5e69fa82a7f0b49efb4ba5fc669e5bd35aeeede75682493bfc87e6035b23dd4d"}, {"url": "/docs/14/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 14 English manual: catalog-pg-amop.html", "sha256": "402b87d7fb1a313b096ba5349a676ae38d507e2eb98739d6ed7f0681e0b9a9a4"}, {"url": "/docs/14/functions-net.html#CIDR-INET-OPERATORS-TABLE", "path": "functions-net.html", "label": "PostgreSQL 14 English manual: functions-net.html", "sha256": "48c90b46cbc4a40225a5cd5e3e5f4ace0dfb33e2f12c59b83dd7315ebc6f4ac9"}], "operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "sections": [{"title": "English manual definition", "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' << inet '192.168.1/24' \u2192 t", "inet '192.168.0.5' << inet '192.168.1/24' \u2192 f", "inet '192.168.1/24' << inet '192.168.1/24' \u2192 f"]}, {"title": "Catalog interpretation", "paragraphs": ["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 38.14 for more information."]}], "signature": "<<(inet,inet) \u2192 bool", "source_oid": "931", "description": ["is subnet"], "memberships": [{"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-gist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-spgist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-brin-network_inclusion_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}], "comparison_data": {"operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "memberships": [{"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}]}, "comparison_hash": "d42adb90295a56bfb804854ebc4a868e8f5cfb8aff948a3e98e8253030f20ecb", "manual_semantics": "Exact operand/result signature matched"}, "15": {"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"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gist-network_ops/?v=15", "text": "network_ops"}, "method": {"url": "/wiki/indexam/gist/?v=15", "text": "GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-spgist-network_ops/?v=15", "text": "network_ops"}, "method": {"url": "/wiki/indexam/spgist/?v=15", "text": "SP-GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=15", "text": "network_inclusion_ops"}, "method": {"url": "/wiki/indexam/brin/?v=15", "text": "BRIN"}, "purpose": "search", "strategy": "26", "sort_family": ""}], "title": "Declared operator-family membership", "columns": [{"key": "method", "label": "Index AM"}, {"key": "family", "label": "Family"}, {"key": "strategy", "label": "Strategy"}, {"key": "purpose", "label": "Purpose"}, {"key": "sort_family", "label": "Ordering family"}]}], "aliases": ["<<", "<<(inet,inet)"], "related": [{"url": "/wiki/type/inet/?v=15", "label": "inet data type"}, {"url": "/wiki/type/bool/?v=15", "label": "bool data type"}, {"url": "/wiki/operator/op-3e3e-inet-inet/?v=15", "label": "Commutator: >>(inet,inet)"}, {"url": "/wiki/opclass/family-gist-network_ops/?v=15", "label": "gist/network_ops family"}, {"url": "/wiki/opclass/family-spgist-network_ops/?v=15", "label": "spgist/network_ops family"}, {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=15", "label": "brin/network_inclusion_ops family"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "label": "15.19", "major": "15", "channel": "stable", "revision": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89", "source_sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89", "manual_fingerprint": "f39c61e9facb5b9404c7d6d1cf494d83af0cc46146554a7fc40724eb882d24a9", "catalog_fingerprint": "1c332a5ccec7bfdd8ca19b55a0279b5bd6cb1dd5dcc6c5587a98a491a9b566a5"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, {"url": "/docs/15/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 15 English manual: catalog-pg-operator.html", "sha256": "3719563ca7bb28791116cb206b9998cd336d09fb4d4cc4a236b6447bcfd5cbb2"}, {"url": "/docs/15/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 15 English manual: catalog-pg-amop.html", "sha256": "53ced8770f19710869151ab02a9a6f0d97380981ca4bfe83752092bfb74a9e0c"}, {"url": "/docs/15/functions-net.html#CIDR-INET-OPERATORS-TABLE", "path": "functions-net.html", "label": "PostgreSQL 15 English manual: functions-net.html", "sha256": "990aef317891f7aa2513e7e3e7442d9b7076eab0c69fce9ebf0caa2280888420"}], "operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "sections": [{"title": "English manual definition", "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' << inet '192.168.1/24' \u2192 t", "inet '192.168.0.5' << inet '192.168.1/24' \u2192 f", "inet '192.168.1/24' << inet '192.168.1/24' \u2192 f"]}, {"title": "Catalog interpretation", "paragraphs": ["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 38.14 for more information."]}], "signature": "<<(inet,inet) \u2192 bool", "source_oid": "931", "description": ["is subnet"], "memberships": [{"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-gist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-spgist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-brin-network_inclusion_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}], "comparison_data": {"operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "memberships": [{"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}]}, "comparison_hash": "d42adb90295a56bfb804854ebc4a868e8f5cfb8aff948a3e98e8253030f20ecb", "manual_semantics": "Exact operand/result signature matched"}, "16": {"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"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gist-network_ops/?v=16", "text": "network_ops"}, "method": {"url": "/wiki/indexam/gist/?v=16", "text": "GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-spgist-network_ops/?v=16", "text": "network_ops"}, "method": {"url": "/wiki/indexam/spgist/?v=16", "text": "SP-GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=16", "text": "network_inclusion_ops"}, "method": {"url": "/wiki/indexam/brin/?v=16", "text": "BRIN"}, "purpose": "search", "strategy": "26", "sort_family": ""}], "title": "Declared operator-family membership", "columns": [{"key": "method", "label": "Index AM"}, {"key": "family", "label": "Family"}, {"key": "strategy", "label": "Strategy"}, {"key": "purpose", "label": "Purpose"}, {"key": "sort_family", "label": "Ordering family"}]}], "aliases": ["<<", "<<(inet,inet)"], "related": [{"url": "/wiki/type/inet/?v=16", "label": "inet data type"}, {"url": "/wiki/type/bool/?v=16", "label": "bool data type"}, {"url": "/wiki/operator/op-3e3e-inet-inet/?v=16", "label": "Commutator: >>(inet,inet)"}, {"url": "/wiki/opclass/family-gist-network_ops/?v=16", "label": "gist/network_ops family"}, {"url": "/wiki/opclass/family-spgist-network_ops/?v=16", "label": "spgist/network_ops family"}, {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=16", "label": "brin/network_inclusion_ops family"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "16.15", "major": "16", "channel": "stable", "revision": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed", "manual_fingerprint": "846fb006e9d590387203c1c65f671240bc5c30604c4e3084cf572817aacc19d0", "catalog_fingerprint": "70797d889dd8aeed77ae81092f99ab380e1109b54b0b7ca6fbf400e0a2111a70"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, {"url": "/docs/16/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 16 English manual: catalog-pg-operator.html", "sha256": "dc789ccf76b6bcbb9b1793858fe700431720a1e70f3261de2b3362ed78040476"}, {"url": "/docs/16/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 16 English manual: catalog-pg-amop.html", "sha256": "f580ac4a34d5f9d567834684e0c41b7df32a952e20a2fc11a9ce0964c2df7e9a"}, {"url": "/docs/16/functions-net.html#CIDR-INET-OPERATORS-TABLE", "path": "functions-net.html", "label": "PostgreSQL 16 English manual: functions-net.html", "sha256": "92bcf90c0bea8a4af3a2b86a7f294b250b021cf2bac1d9e0896abf1ced909bfe"}], "operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "sections": [{"title": "English manual definition", "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' << inet '192.168.1/24' \u2192 t", "inet '192.168.0.5' << inet '192.168.1/24' \u2192 f", "inet '192.168.1/24' << inet '192.168.1/24' \u2192 f"]}, {"title": "Catalog interpretation", "paragraphs": ["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 38.14 for more information."]}], "signature": "<<(inet,inet) \u2192 bool", "source_oid": "931", "description": ["is subnet"], "memberships": [{"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-gist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-spgist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-brin-network_inclusion_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}], "comparison_data": {"operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "memberships": [{"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}]}, "comparison_hash": "d42adb90295a56bfb804854ebc4a868e8f5cfb8aff948a3e98e8253030f20ecb", "manual_semantics": "Exact operand/result signature matched"}, "17": {"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"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gist-network_ops/?v=17", "text": "network_ops"}, "method": {"url": "/wiki/indexam/gist/?v=17", "text": "GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-spgist-network_ops/?v=17", "text": "network_ops"}, "method": {"url": "/wiki/indexam/spgist/?v=17", "text": "SP-GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=17", "text": "network_inclusion_ops"}, "method": {"url": "/wiki/indexam/brin/?v=17", "text": "BRIN"}, "purpose": "search", "strategy": "26", "sort_family": ""}], "title": "Declared operator-family membership", "columns": [{"key": "method", "label": "Index AM"}, {"key": "family", "label": "Family"}, {"key": "strategy", "label": "Strategy"}, {"key": "purpose", "label": "Purpose"}, {"key": "sort_family", "label": "Ordering family"}]}], "aliases": ["<<", "<<(inet,inet)"], "related": [{"url": "/wiki/type/inet/?v=17", "label": "inet data type"}, {"url": "/wiki/type/bool/?v=17", "label": "bool data type"}, {"url": "/wiki/operator/op-3e3e-inet-inet/?v=17", "label": "Commutator: >>(inet,inet)"}, {"url": "/wiki/opclass/family-gist-network_ops/?v=17", "label": "gist/network_ops family"}, {"url": "/wiki/opclass/family-spgist-network_ops/?v=17", "label": "spgist/network_ops family"}, {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=17", "label": "brin/network_inclusion_ops family"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979", "manual_fingerprint": "b55870f8e80e1114a92ac7bfc97f4a6fa0dee8e75935895252bb6e5b866cf187", "catalog_fingerprint": "e888e3474202df1c60a8e7b6bf9f2d83b3866a52d119521659b7a82787d3829d"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, {"url": "/docs/17/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 17 English manual: catalog-pg-operator.html", "sha256": "a66984c4fde91649a9677d33a2e002381cb07e99d72ad0971fa3251741030a69"}, {"url": "/docs/17/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 17 English manual: catalog-pg-amop.html", "sha256": "19b2fb110b348860f7fbcb6e0e0544e341f5645113c23f50920a54434d432359"}, {"url": "/docs/17/functions-net.html#CIDR-INET-OPERATORS-TABLE", "path": "functions-net.html", "label": "PostgreSQL 17 English manual: functions-net.html", "sha256": "109dfaabdc16aee6b5557127e03d1f734a65ac6e633fd561e1cf861a8ba52d34"}], "operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "sections": [{"title": "English manual definition", "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' << inet '192.168.1/24' \u2192 t", "inet '192.168.0.5' << inet '192.168.1/24' \u2192 f", "inet '192.168.1/24' << inet '192.168.1/24' \u2192 f"]}, {"title": "Catalog interpretation", "paragraphs": ["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."]}], "signature": "<<(inet,inet) \u2192 bool", "source_oid": "931", "description": ["is subnet"], "memberships": [{"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-gist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-spgist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-brin-network_inclusion_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}], "comparison_data": {"operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "memberships": [{"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}]}, "comparison_hash": "d42adb90295a56bfb804854ebc4a868e8f5cfb8aff948a3e98e8253030f20ecb", "manual_semantics": "Exact operand/result signature matched"}, "18": {"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"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gist-network_ops/?v=18", "text": "network_ops"}, "method": {"url": "/wiki/indexam/gist/?v=18", "text": "GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-spgist-network_ops/?v=18", "text": "network_ops"}, "method": {"url": "/wiki/indexam/spgist/?v=18", "text": "SP-GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=18", "text": "network_inclusion_ops"}, "method": {"url": "/wiki/indexam/brin/?v=18", "text": "BRIN"}, "purpose": "search", "strategy": "26", "sort_family": ""}], "title": "Declared operator-family membership", "columns": [{"key": "method", "label": "Index AM"}, {"key": "family", "label": "Family"}, {"key": "strategy", "label": "Strategy"}, {"key": "purpose", "label": "Purpose"}, {"key": "sort_family", "label": "Ordering family"}]}], "aliases": ["<<", "<<(inet,inet)"], "related": [{"url": "/wiki/type/inet/?v=18", "label": "inet data type"}, {"url": "/wiki/type/bool/?v=18", "label": "bool data type"}, {"url": "/wiki/operator/op-3e3e-inet-inet/?v=18", "label": "Commutator: >>(inet,inet)"}, {"url": "/wiki/opclass/family-gist-network_ops/?v=18", "label": "gist/network_ops family"}, {"url": "/wiki/opclass/family-spgist-network_ops/?v=18", "label": "spgist/network_ops family"}, {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=18", "label": "brin/network_inclusion_ops family"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "manual_fingerprint": "fefce9e478eb2afe5e17e869492bbedc67dce23d317f0a5257240113d6496ebc", "catalog_fingerprint": "deec62e0f0c649d9d0d058ddd0b16bf41afffd569c3fd73949ff0971ce5cabd6"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, {"url": "/docs/18/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 18 English manual: catalog-pg-operator.html", "sha256": "e0b1817914e5e8f9037955cd41e9a43584e9227fcc115784898ecdd9a6c0ecd6"}, {"url": "/docs/18/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 18 English manual: catalog-pg-amop.html", "sha256": "e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1"}, {"url": "/docs/18/functions-net.html#CIDR-INET-OPERATORS-TABLE", "path": "functions-net.html", "label": "PostgreSQL 18 English manual: functions-net.html", "sha256": "6685d0c85e49d8995caaaf39c4435d6fe4e8c4e3f88a1c8312de4d870a9adcc6"}], "operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "sections": [{"title": "English manual definition", "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' << inet '192.168.1/24' \u2192 t", "inet '192.168.0.5' << inet '192.168.1/24' \u2192 f", "inet '192.168.1/24' << inet '192.168.1/24' \u2192 f"]}, {"title": "Catalog interpretation", "paragraphs": ["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."]}], "signature": "<<(inet,inet) \u2192 bool", "source_oid": "931", "description": ["is subnet"], "memberships": [{"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-gist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-spgist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-brin-network_inclusion_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}], "comparison_data": {"operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "memberships": [{"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}]}, "comparison_hash": "d42adb90295a56bfb804854ebc4a868e8f5cfb8aff948a3e98e8253030f20ecb", "manual_semantics": "Exact operand/result signature matched"}, "19": {"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"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gist-network_ops/?v=19", "text": "network_ops"}, "method": {"url": "/wiki/indexam/gist/?v=19", "text": "GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-spgist-network_ops/?v=19", "text": "network_ops"}, "method": {"url": "/wiki/indexam/spgist/?v=19", "text": "SP-GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=19", "text": "network_inclusion_ops"}, "method": {"url": "/wiki/indexam/brin/?v=19", "text": "BRIN"}, "purpose": "search", "strategy": "26", "sort_family": ""}], "title": "Declared operator-family membership", "columns": [{"key": "method", "label": "Index AM"}, {"key": "family", "label": "Family"}, {"key": "strategy", "label": "Strategy"}, {"key": "purpose", "label": "Purpose"}, {"key": "sort_family", "label": "Ordering family"}]}], "aliases": ["<<", "<<(inet,inet)"], "related": [{"url": "/wiki/type/inet/?v=19", "label": "inet data type"}, {"url": "/wiki/type/bool/?v=19", "label": "bool data type"}, {"url": "/wiki/operator/op-3e3e-inet-inet/?v=19", "label": "Commutator: >>(inet,inet)"}, {"url": "/wiki/opclass/family-gist-network_ops/?v=19", "label": "gist/network_ops family"}, {"url": "/wiki/opclass/family-spgist-network_ops/?v=19", "label": "spgist/network_ops family"}, {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=19", "label": "brin/network_inclusion_ops family"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "manual_fingerprint": "d1c30d7808d3ae2edc8773a0dd66f7beb5861e8939001e171c1908f7a09bb497", "catalog_fingerprint": "9af4323d0c8ed03d0e795331930bd14ce9bf6193c6b766c463b9f6ec0829409a"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, {"url": "/docs/19/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 19 English manual: catalog-pg-operator.html", "sha256": "fa89c3d5f2ba2adfe53192fd39c819efc78a22998994feed5fd4239bedaa938a"}, {"url": "/docs/19/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 19 English manual: catalog-pg-amop.html", "sha256": "711850fdde973fbaf16da94143a2de3b972bed7a3b8663bf80e4aeabaf2f43fe"}, {"url": "/docs/19/functions-net.html#CIDR-INET-OPERATORS-TABLE", "path": "functions-net.html", "label": "PostgreSQL 19 English manual: functions-net.html", "sha256": "427ec05c3a7a036331b94620e499db1fa09d40a24a271c721c786f98c390f1a0"}], "operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "sections": [{"title": "English manual definition", "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' << inet '192.168.1/24' \u2192 t", "inet '192.168.0.5' << inet '192.168.1/24' \u2192 f", "inet '192.168.1/24' << inet '192.168.1/24' \u2192 f"]}, {"title": "Catalog interpretation", "paragraphs": ["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."]}], "signature": "<<(inet,inet) \u2192 bool", "source_oid": "931", "description": ["is subnet"], "memberships": [{"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-gist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-spgist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-brin-network_inclusion_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}], "comparison_data": {"operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "memberships": [{"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}]}, "comparison_hash": "d42adb90295a56bfb804854ebc4a868e8f5cfb8aff948a3e98e8253030f20ecb", "manual_semantics": "Exact operand/result signature matched"}, "20": {"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"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gist-network_ops/?v=20", "text": "network_ops"}, "method": {"url": "/wiki/indexam/gist/?v=20", "text": "GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-spgist-network_ops/?v=20", "text": "network_ops"}, "method": {"url": "/wiki/indexam/spgist/?v=20", "text": "SP-GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=20", "text": "network_inclusion_ops"}, "method": {"url": "/wiki/indexam/brin/?v=20", "text": "BRIN"}, "purpose": "search", "strategy": "26", "sort_family": ""}], "title": "Declared operator-family membership", "columns": [{"key": "method", "label": "Index AM"}, {"key": "family", "label": "Family"}, {"key": "strategy", "label": "Strategy"}, {"key": "purpose", "label": "Purpose"}, {"key": "sort_family", "label": "Ordering family"}]}], "aliases": ["<<", "<<(inet,inet)"], "related": [{"url": "/wiki/type/inet/?v=20", "label": "inet data type"}, {"url": "/wiki/type/bool/?v=20", "label": "bool data type"}, {"url": "/wiki/operator/op-3e3e-inet-inet/?v=20", "label": "Commutator: >>(inet,inet)"}, {"url": "/wiki/opclass/family-gist-network_ops/?v=20", "label": "gist/network_ops family"}, {"url": "/wiki/opclass/family-spgist-network_ops/?v=20", "label": "spgist/network_ops family"}, {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=20", "label": "brin/network_inclusion_ops family"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "manual_fingerprint": "48fb9e20e9e1454fe93d367e75b949833c82c1c52c2b69314dfffe1c464f3f39", "catalog_fingerprint": "cc1a474e972c8c342cf17f37e2884c56cc4b114cb59407b0180e99cdcfffa5c5", "source_snapshot_utc": "26-Sep-2026 20:22"}, "sources": [{"url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, {"url": "/docs/devel/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 20 English manual: catalog-pg-operator.html", "sha256": "b8882bb8329f1659f719eb9397246146135c228892834fbd29325ed3030f17cb"}, {"url": "/docs/devel/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 20 English manual: catalog-pg-amop.html", "sha256": "00fee8a631088b687e2d880e4091791ca30f9c69fca888c51ece463d1b9e1e61"}, {"url": "/docs/devel/functions-net.html#CIDR-INET-OPERATORS-TABLE", "path": "functions-net.html", "label": "PostgreSQL 20 English manual: functions-net.html", "sha256": "b50ee9c7eaa09c045e50060e3843084fe408a1881758c406be33c9dcf9157d61"}], "operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "sections": [{"title": "English manual definition", "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' << inet '192.168.1/24' \u2192 t", "inet '192.168.0.5' << inet '192.168.1/24' \u2192 f", "inet '192.168.1/24' << inet '192.168.1/24' \u2192 f"]}, {"title": "Catalog interpretation", "paragraphs": ["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."]}], "signature": "<<(inet,inet) \u2192 bool", "source_oid": "931", "description": ["is subnet"], "memberships": [{"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-gist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-spgist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-brin-network_inclusion_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}], "comparison_data": {"operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "memberships": [{"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}]}, "comparison_hash": "d42adb90295a56bfb804854ebc4a868e8f5cfb8aff948a3e98e8253030f20ecb", "manual_semantics": "Exact operand/result signature matched"}}}, "snapshot": {"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"}], "tables": [{"key": "memberships", "rows": [{"family": {"url": "/wiki/opclass/family-gist-network_ops/?v=18", "text": "network_ops"}, "method": {"url": "/wiki/indexam/gist/?v=18", "text": "GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-spgist-network_ops/?v=18", "text": "network_ops"}, "method": {"url": "/wiki/indexam/spgist/?v=18", "text": "SP-GiST"}, "purpose": "search", "strategy": "24", "sort_family": ""}, {"family": {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=18", "text": "network_inclusion_ops"}, "method": {"url": "/wiki/indexam/brin/?v=18", "text": "BRIN"}, "purpose": "search", "strategy": "26", "sort_family": ""}], "title": "Declared operator-family membership", "columns": [{"key": "method", "label": "Index AM"}, {"key": "family", "label": "Family"}, {"key": "strategy", "label": "Strategy"}, {"key": "purpose", "label": "Purpose"}, {"key": "sort_family", "label": "Ordering family"}]}], "aliases": ["<<", "<<(inet,inet)"], "related": [{"url": "/wiki/type/inet/?v=18", "label": "inet data type"}, {"url": "/wiki/type/bool/?v=18", "label": "bool data type"}, {"url": "/wiki/operator/op-3e3e-inet-inet/?v=18", "label": "Commutator: >>(inet,inet)"}, {"url": "/wiki/opclass/family-gist-network_ops/?v=18", "label": "gist/network_ops family"}, {"url": "/wiki/opclass/family-spgist-network_ops/?v=18", "label": "spgist/network_ops family"}, {"url": "/wiki/opclass/family-brin-network_inclusion_ops/?v=18", "label": "brin/network_inclusion_ops family"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "manual_fingerprint": "fefce9e478eb2afe5e17e869492bbedc67dce23d317f0a5257240113d6496ebc", "catalog_fingerprint": "deec62e0f0c649d9d0d058ddd0b16bf41afffd569c3fd73949ff0971ce5cabd6"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, {"url": "/docs/18/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 18 English manual: catalog-pg-operator.html", "sha256": "e0b1817914e5e8f9037955cd41e9a43584e9227fcc115784898ecdd9a6c0ecd6"}, {"url": "/docs/18/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 18 English manual: catalog-pg-amop.html", "sha256": "e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1"}, {"url": "/docs/18/functions-net.html#CIDR-INET-OPERATORS-TABLE", "path": "functions-net.html", "label": "PostgreSQL 18 English manual: functions-net.html", "sha256": "6685d0c85e49d8995caaaf39c4435d6fe4e8c4e3f88a1c8312de4d870a9adcc6"}], "operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "sections": [{"title": "English manual definition", "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' << inet '192.168.1/24' \u2192 t", "inet '192.168.0.5' << inet '192.168.1/24' \u2192 f", "inet '192.168.1/24' << inet '192.168.1/24' \u2192 f"]}, {"title": "Catalog interpretation", "paragraphs": ["The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."]}], "signature": "<<(inet,inet) \u2192 bool", "source_oid": "931", "description": ["is subnet"], "memberships": [{"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-gist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-spgist-network_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}, {"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "description": "is subnet", "family_slug": "family-brin-network_inclusion_ops", "result_type": "bool", "sort_family": "", "operator_slug": "op-3c3c-inet-inet", "sort_family_slug": ""}], "comparison_data": {"operator": {"kind": "b", "symbol": "<<", "negator": "", "function": "network_sub(inet,inet)", "hash_join": "f", "left_type": "inet", "commutator": ">>(inet,inet)", "merge_join": "f", "right_type": "inet", "result_type": "bool"}, "memberships": [{"family": "network_inclusion_ops", "method": "brin", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "26", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "gist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}, {"family": "network_ops", "method": "spgist", "purpose": "search", "operator": "<<(inet,inet)", "strategy": "24", "left_type": "inet", "right_type": "inet", "sort_family": ""}]}, "comparison_hash": "d42adb90295a56bfb804854ebc4a868e8f5cfb8aff948a3e98e8253030f20ecb", "manual_semantics": "Exact operand/result signature matched"}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}