IP V4 Functions

Table 5-9. PostgresIP V4 Functions

FunctionReturnsDescriptionExample
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')