Text Size: Normal / Large

IP V4 Functions

Table 5-15. PostgresIP V4 Functions

FunctionReturnsDescriptionExample
broadcast(cidr)textconstruct broadcast address as textbroadcast('192.168.1.5/24')
broadcast(inet)textconstruct broadcast address as textbroadcast('192.168.1.5/24')
host(inet)textextract host address as texthost('192.168.1.5/24')
masklen(cidr)int4calculate netmask lengthmasklen('192.168.1.5/24')
masklen(inet)int4calculate netmask lengthmasklen('192.168.1.5/24')
netmask(inet)textconstruct netmask as textnetmask('192.168.1.5/24')

Privacy Policy | Project hosted by hub.org | Designed by tinysofa
Copyright © 1996 – 2007 PostgreSQL Global Development Group