↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Operator Families

brin/inet_inclusion_ops (class)

BRIN operator class for inet; member of network_inclusion_ops.

Reading PG 18·Select a recorded version

Object kind
Operator class
Index AM
BRIN
Input type
inet
Stored key type
inet
Default class
yes
aliases
inet_inclusion_ops, brin/inet_inclusion_ops
classes
map[default:t family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops input_type:inet key_type:inet method:brin name:inet_inclusion_ops slug:class-brin-inet_inclusion_ops source_oid:]
signature
brin/inet_inclusion_ops
source oid
Unknown

Definition PG 18

BRIN operator class for inet; member of network_inclusion_ops.

Family operator strategies

Operator overloadStrategyPurposeOrdering familyMembership scopeSource description
&&(inet,inet)3searchClass input pairoverlaps (is subnet or supernet)
>>=(inet,inet)7searchClass input pairis supernet or equal
<<=(inet,inet)8searchClass input pairis subnet or equal
=(inet,inet)18searchClass input pairequal
>>(inet,inet)24searchClass input pairis supernet
<<(inet,inet)26searchClass input pairis subnet

Family support functions

Support numberLeft typeRight typeFunction signatureResult type
1inetinetbrin_inclusion_opcinfo(internal)internal
2inetinetbrin_inclusion_add_value(internal,internal,internal,internal)bool
3inetinetbrin_inclusion_consistent(internal,internal,internal)bool
4inetinetbrin_inclusion_union(internal,internal,internal)bool
11inetinetinet_merge(inet,inet)cidr
12inetinetinet_same_family(inet,inet)bool
13inetinetnetwork_supeq(inet,inet)bool

Classes in this family

ClassInput typeKey typeDefault
inet_inclusion_opsinetinetyes

Compare versions

Complete source facts

class

{"default":"t","family":"network_inclusion_ops","input_type":"inet","key_type":"inet","method":"brin","name":"inet_inclusion_ops"}

operators

map[description:overlaps (is subnet or supernet) family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops left_type:inet method:brin operator:&&(inet,inet) operator_slug:op-2626-inet-inet purpose:search result_type:bool right_type:inet sort_family: sort_family_slug: strategy:3], map[description:is supernet or equal family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops left_type:inet method:brin operator:>>=(inet,inet) operator_slug:op-3e3e3d-inet-inet purpose:search result_type:bool right_type:inet sort_family: sort_family_slug: strategy:7], map[description:is subnet or equal family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops left_type:inet method:brin operator:<<=(inet,inet) operator_slug:op-3c3c3d-inet-inet purpose:search result_type:bool right_type:inet sort_family: sort_family_slug: strategy:8], map[description:equal family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops left_type:inet method:brin operator:=(inet,inet) operator_slug:op-3d-inet-inet purpose:search result_type:bool right_type:inet sort_family: sort_family_slug: strategy:18], map[description:is supernet family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops left_type:inet method:brin operator:>>(inet,inet) operator_slug:op-3e3e-inet-inet purpose:search result_type:bool right_type:inet sort_family: sort_family_slug: strategy:24], map[description:is subnet family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops left_type:inet method:brin operator:<<(inet,inet) operator_slug:op-3c3c-inet-inet purpose:search result_type:bool right_type:inet sort_family: sort_family_slug: strategy:26]

support functions

map[family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops function:brin_inclusion_opcinfo(internal) left_type:inet method:brin number:1 result_type:internal right_type:inet], map[family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops function:brin_inclusion_add_value(internal,internal,internal,internal) left_type:inet method:brin number:2 result_type:bool right_type:inet], map[family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops function:brin_inclusion_consistent(internal,internal,internal) left_type:inet method:brin number:3 result_type:bool right_type:inet], map[family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops function:brin_inclusion_union(internal,internal,internal) left_type:inet method:brin number:4 result_type:bool right_type:inet], map[family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops function:inet_merge(inet,inet) left_type:inet method:brin number:11 result_type:cidr right_type:inet], map[family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops function:inet_same_family(inet,inet) left_type:inet method:brin number:12 result_type:bool right_type:inet], map[family:network_inclusion_ops family_slug:family-brin-network_inclusion_ops function:network_supeq(inet,inet) left_type:inet method:brin number:13 result_type:bool right_type:inet]

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f