October 2001
Beginner to intermediate
400 pages
7h 45m
English
PostgreSQL includes many functions that are network oriented. Primarily, these are useful for performing calculations and transformations of IP-related data. The following sections discuss the included network functions in PostgreSQL.
The ABBREV function returns an abbreviated text format for a supplied inet or cidr value.
ABBREV(inet | cidr)
ABBREV('192.168.0.0/24') → "192.168/24" The BROADCAST function returns the broadcast address of the supplied inet or cidr value.
BROADCAST(inet | cidr)
BROADCAST('192.168.0.1/24') → '192.168.0.255/24' The HOST function extracts the host address for the supplied inet or cidr value.
Read now
Unlock full access