October 2001
Beginner to intermediate
400 pages
7h 45m
English
PostgreSQL is unique among many SQL systems in that it includes built-in data types for network addresses. CIDR, INET, and MACADDR all represent specific aspects of network addresses. These data types can be particularly useful when using PostgreSQL as a back-end database to a web application.
Storing network values in these data types is preferential due to the included functions in PostgreSQL that act on network-specific data types.
Holds dotted-quad data for an IP address and the number of bits in the netmask. This data type is named for the Classless Internet Domain Routing (CIDR) convention.
x.x.x.x/y
x.x.x. x—Valid IP address.
y—Bits in the netmask.
12 bytes
Read now
Unlock full access