This page in other versions: Unsupported versions: 6.4

IP V4 Functions

Table 10-8. PostgresIP V4 Functions

Function Returns Description Example
broadcast(cidr) text construct broadcast address as text broadcast('192.168.1.5/24') ==> '192.168.1.255'
broadcast(inet) text construct broadcast address as text broadcast('192.168.1.5/24') ==> '192.168.1.255'
host(inet) text extract host address as text host('192.168.1.5/24') ==> '192.168.1.5'
masklen(cidr) int4 calculate netmask length masklen('192.168.1.5/24') ==> 24
masklen(inet) int4 calculate netmask length masklen('192.168.1.5/24') ==> 24
netmask(inet) text construct netmask as text netmask('192.168.1.5/24') ==> '255.255.255.0'
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group