Network Functions

I l @ ve RuBoard

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.

ABBREV

Description

The ABBREV function returns an abbreviated text format for a supplied inet or cidr value.

Input

 ABBREV(  inet   cidr  ) 

Example

 ABBREV('192.168.0.0/24')  "192.168/24" 

BROADCAST

Description

The BROADCAST function returns the broadcast address of the supplied inet or cidr value.

Input

 BROADCAST(  inet   cidr  ) 

Example

 BROADCAST('192.168.0.1/24')  '192.168.0.255/24' 

HOST

Description

The HOST function extracts the host address for the supplied inet or cidr value.

Input

 HOST(  inet   cidr  ) 

Example

 HOST('192.168.0.101/24')  '192.168.0.101' 

MASKLEN

Description

The MASKLEN function extracts the netmask length for the supplied inet or cidr value.

Input

 MASKLEN(  inet   cidr  ) 

Example

 MASKLEN('192.168.0.1/24')  24 

NETMASK

Description

The NETMASK function calculates the netmask for the supplied inet or cidr value.

Input

 NETMASK(  inet   cidr  ) 

Example

 NETMASK('192.168.0.1/24')  '255.255.255.0' 

NETWORK

Description

The NETWORK function extracts the network from a supplied inet or cidr value.

Input

 NETWORK(  inet   cidr  ) 

Example

 NETWORK('192.168.0.155/24')  '192.168.1.0/24' 

TEXT

Description

The TEXT function returns the IP and netmask length as a text value.

Input

 TEXT(  inet   cidr  ) 

Example

 TEXT(CIDR '192.168.0.1/24')  "192.168.0.1/24" 

TRUNC

Description

The TRUNC function sets the last 3 bytes to zero for the supplied macaddr value.

Input

 TRUNC(macaddr) 

Example

 TRUNC(macaddr '33:33:33:33:33:aa')  '33:33:33:00:00:00' 

Notes

This function is useful for associating a supplied MAC address with a manufacturer. See the directory $SOURCE/ contrib /mac ( SOURCE is the location of the PostgreSQL source code) for more information.

I l @ ve RuBoard