IPV4
The
IPV4 data type stores 4-byte IP addresses in the standard format:
x.x.x.xwhere x is an octet with a value between
0 and
255. An IPV4 address always contains three periods and
four octets. For example: 10.10.0.1
255.255.253.0
19.120.51.251See also IPV6, which is a separate data type, and Network Address Functions. Some network address functions accept netmask
values for processing; however, only single-host specifications are stored in
IPV4 columns, assuming a /32 netmask. If a source data
value contains the /n CIDR notation, this notation is ignored when the
value is loaded. For example, 1.2.3.4/8 is stored as
1.2.3.4
To explicitly identify a string as an
IPV4 literal value, use the
IPV4 keyword. For example:
where ip_address > ipv4 '192.168.1.6'IPV4 columns do not accept empty strings.