IP Functions

    Returns the IP prefix of a given with subnet size of prefix_bits. ip_address can be either of type VARCHAR or type IPADDRESS.

    ip_subnet_min(ip_prefix) → ip_address

    Returns the smallest IP address of type IPADDRESS in the subnet specified by ip_prefix.

    Returns the largest IP address of type IPADDRESS in the subnet specified by ip_prefix.

    ip_subnet_range(ip_prefix)

    Return an array of 2 IP addresses. The array contains the smallest and the largest IP address in the subnet specified by ip_prefix.

    1. SELECT ip_subnet_range(IPPREFIX '1.2.3.160/24'); -- [{1.2.3.0}, {1.2.3.255}]

    Returns if the ip_address is in the subnet of ip_prefix.

    is_subnet_of(ip_prefix1, ip_prefix2) → boolean

    Returns true if ip_prefix2 is a subnet of ip_prefix1.

    1. SELECT is_subnet_of(IPPREFIX '192.168.3.131/26', IPPREFIX '192.168.3.144/30'); -- true
    2. SELECT is_subnet_of(IPPREFIX '192.168.3.131/26', IPPREFIX '192.168.3.131/26'); -- true