Table 5-15. PostgresIP V4 Functions
| Function | Returns | Description | Example |
|---|---|---|---|
| broadcast(cidr) | text | construct broadcast address as text | broadcast('192.168.1.5/24') |
| broadcast(inet) | text | construct broadcast address as text | broadcast('192.168.1.5/24') |
| host(inet) | text | extract host address as text | host('192.168.1.5/24') |
| masklen(cidr) | int4 | calculate netmask length | masklen('192.168.1.5/24') |
| masklen(inet) | int4 | calculate netmask length | masklen('192.168.1.5/24') |
| netmask(inet) | text | construct netmask as text | netmask('192.168.1.5/24') |
Read the upstream documentation. For corrections, first check the current manual.