Functions & Operators which apply to the SQL types: inet, inet4 and inet6.
See IP address for the differences between these types.
| Operator | Description | Example | Result |
|---|---|---|---|
| < | is less than | inet '192.168.1.5' < inet '192.168.1.6' | true |
| <= | is less than or equal | inet '192.168.1.5' <= inet '192.168.1.5' | true |
| = | equals | inet '192.168.1.5' = inet '192.168.1.5' | true |
| > | is greater than | inet '192.168.1.5' > inet '192.168.1.4' | true |
| >= | is greater than or equal | inet '192.168.1.5' >= inet '192.168.1.5' | true |
| <> | is not equal | inet '192.168.1.5' <> inet '192.168.1.4' | true |
| << | is contained by | inet '192.168.1.5' << inet '192.168.1/24' | true |
| <<= | is contained by or equals | inet '192.168.1/24' <<= inet '192.168.1/24' | true |
| >> | contains | inet '192.168.1/24' >> inet '192.168.1.5' | true |
| >>= | contains or equals | inet '192.168.1/24' >>= inet '192.168.1/24' | true |
| Function | Return type | Description | Example | Result |
|---|---|---|---|---|
| sys.abbrev(inet) | clob | abbreviated display format as text | sys.abbrev(inet '10.1.0.0/16') | 10.1/16 |
| sys.broadcast(inet) | inet | broadcast address for network | sys.broadcast(inet '192.168.1.5/24') | 192.168.1.255/24 |
| sys.host(inet) | clob | extract IP address as text | sys.host(inet '192.168.1.5/24') | 192.168.1.5 |
| sys.hostmask(inet) | inet | construct host mask for network | sys.hostmask(inet '192.168.23.20/30') | 0.0.0.3 |
| sys.left_shift(inet, inet) | boolean | is contained by | sys.left_shift(inet '192.168.1/24', inet '192.168.1.5') | true |
| sys.left_shift_assign(inet, inet) | boolean | is contained by or equals | sys.left_shift_assign(inet '192.168.1/24', inet '192.168.1/24') | true |
| sys.masklen(inet) | int | extract netmask length | sys.masklen(inet '192.168.1.5/24') | 24 |
| sys.netmask(inet) | inet | construct netmask for network | sys.netmask(inet '192.168.1.5/24') | 255.255.255.0 |
| sys.network(inet) | inet | extract network part of address | sys.network(inet '192.168.1.5/24') | 192.168.1.0/24 |
| sys.right_shift(inet, inet) | boolean | contains | sys.right_shift(inet '192.168.1/24', inet '192.168.1.5') | true |
| sys.right_shift_assign(inet, inet) | boolean | contains or equals | sys.right_shift_assign(inet '192.168.1/24', inet '192.168.1/24') | true |
| sys.setmasklen(inet, int) | inet | set netmask length for inet value | sys.setmasklen(inet '192.168.1.5/24', 16) | 192.168.1.5/16 |
| sys.text(inet) | clob | extract IP address and netmask length as text | sys.text(inet '192.168.1.5') | 192.168.1.5/32 |
| Function | Return type | Description | Example | Result |
|---|---|---|---|---|
| sys.bit_and(ip1 inet4, ip2 inet4) | inet4 | bitwise AND operation | ||
| sys.bit_not(ip1 inet4) | inet4 | bitwise NOT operation | ||
| sys.bit_or(ip1 inet4, ip2 inet4) | inet4 | bitwise OR operation | ||
| sys.bit_xor(ip1 inet4, ip2 inet4) | inet4 | bitwise XOR operation | ||
| sys.contains(ip1 inet4, ip2 inet4, netmask tinyint) | bool | |||
| sys.contains(ip1 inet4, netmask1 tinyint, ip2 inet4, netmask2 tinyint) | bool | |||
| sys.containsorequal(ip1 inet4, ip2 inet4, netmask tinyint) | bool | |||
| sys.containsorequal(ip1 inet4, netmask1 tinyint, ip2 inet4, netmask2 tinyint) | bool | |||
| sys.containssymmetric(ip1 inet4, netmask1 tinyint, ip2 inet4, netmask2 tinyint) | bool |
| Function | Return type | Description | Example | Result |
|---|---|---|---|---|
| sys.bit_and(ip1 inet6, ip2 inet6) | inet6 | bitwise AND operation | ||
| sys.bit_not(ip1 inet6) | inet6 | bitwise NOT operation | ||
| sys.bit_or(ip1 inet6, ip2 inet6) | inet6 | bitwise OR operation | ||
| sys.bit_xor(ip1 inet6, ip2 inet6) | inet6 | bitwise XOR operation | ||
| sys.contains(ip1 inet6, ip2 inet6, netmask smallint) | bool | |||
| sys.contains(ip1 inet6, netmask1 smallint, ip2 inet6, netmask2 smallint) | bool | |||
| sys.containsorequal(ip1 inet6, ip2 inet6, netmask smallint) | bool | |||
| sys.containsorequal(ip1 inet6, netmask1 smallint, ip2 inet6, netmask2 smallint) | bool | |||
| sys.containssymmetric(ip1 inet6, netmask1 smallint, ip2 inet6, netmask2 smallint) | bool |