string cidr IPv4 or IPv6 network address circle circle in the plane date calendar date (year, month, day) double precision float8 double precision floating-point number inet IPv4 or IPv6 host address integer output using the first syntax. 8.8. Network Address Types PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-17. It is preferable to use these types instead of plain text IPv4 and IPv6 networks inet 12 or 24 bytes IPv4 and IPv6 hosts and networks macaddr 6 bytes MAC addresses When sorting inet or cidr data types, IPv4 addresses will always sort before IPv6 addresses

string cidr IPv4 or IPv6 network address circle circle in the plane date calendar date (year, month, day) double precision float8 double precision floating-point number inet IPv4 or IPv6 host address integer output using the first syntax. 8.8. Network Address Types PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-17. It is preferable to use these types instead of plain text IPv4 and IPv6 networks inet 12 or 24 bytes IPv4 and IPv6 hosts and networks macaddr 6 bytes MAC addresses When sorting inet or cidr data types, IPv4 addresses will always sort before IPv6 addresses

string cidr IPv4 or IPv6 network address circle circle in the plane date calendar date (year, month, day) double precision float8 double precision floating-point number inet IPv4 or IPv6 host address integer output using the first syntax. 8.8. Network Address Types PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-17. It is preferable to use these types instead of plain text IPv4 and IPv6 networks inet 12 or 24 bytes IPv4 and IPv6 hosts and networks macaddr 6 bytes MAC addresses When sorting inet or cidr data types, IPv4 addresses will always sort before IPv6 addresses

string cidr IPv4 or IPv6 network address circle circle in the plane date calendar date (year, month, day) double precision float8 double precision floating-point number inet IPv4 or IPv6 host address integer output using the first syntax. 8.8. Network Address Types PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-17. It is preferable to use these types instead of plain text IPv4 and IPv6 networks inet 12 or 24 bytes IPv4 and IPv6 hosts and networks macaddr 6 bytes MAC addresses When sorting inet or cidr data types, IPv4 addresses will always sort before IPv6 addresses

string cidr IPv4 or IPv6 network address circle circle in the plane date calendar date (year, month, day) double precision float8 double precision floating-point number inet IPv4 or IPv6 host address integer output using the first syntax. 8.8. Network Address Types PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-17. It is preferable to use these types instead of plain text IPv4 and IPv6 networks inet 12 or 24 bytes IPv4 and IPv6 hosts and networks macaddr 6 bytes MAC addresses When sorting inet or cidr data types, IPv4 addresses will always sort before IPv6 addresses

string cidr IPv4 or IPv6 network address circle circle in the plane date calendar date (year, month, day) double precision float8 double precision floating-point number inet IPv4 or IPv6 host address integer output using the first syntax. 8.8. Network Address Types PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-17. It is preferable to use these types instead of plain text IPv4 and IPv6 networks inet 12 or 24 bytes IPv4 and IPv6 hosts and networks macaddr 6 bytes MAC addresses When sorting inet or cidr data types, IPv4 addresses will always sort before IPv6 addresses

cidr IPv4 or IPv6 network address circle circle on a plane date calendar date (year, month, day) double precision float8 double precision floating-point number (8 bytes) inet IPv4 or IPv6 host address output using the first syntax. 8.9. Network Address Types PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-20. It is better to use these types instead of plain text bytes IPv4 and IPv6 networks inet 7 or 19 bytes IPv4 and IPv6 hosts and networks macaddr 6 bytes MAC addresses When sorting inet or cidr data types, IPv4 addresses will always sort before IPv6 addresses

cidr IPv4 or IPv6 network address circle circle on a plane date calendar date (year, month, day) double precision float8 double precision floating-point number (8 bytes) inet IPv4 or IPv6 host address output using the first syntax. 8.9. Network Address Types PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-20. It is better to use these types instead of plain text bytes IPv4 and IPv6 networks inet 7 or 19 bytes IPv4 and IPv6 hosts and networks macaddr 6 bytes MAC addresses When sorting inet or cidr data types, IPv4 addresses will always sort before IPv6 addresses

cidr IPv4 or IPv6 network address circle circle on a plane date calendar date (year, month, day) double precision float8 double precision floating-point number (8 bytes) inet IPv4 or IPv6 host address output using the first syntax. 8.9. Network Address Types PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-21. It is better to use these types instead of plain text bytes IPv4 and IPv6 networks inet 7 or 19 bytes IPv4 and IPv6 hosts and networks macaddr 6 bytes MAC addresses When sorting inet or cidr data types, IPv4 addresses will always sort before IPv6 addresses

cidr IPv4 or IPv6 network address circle circle on a plane date calendar date (year, month, day) double precision float8 double precision floating-point number (8 bytes) inet IPv4 or IPv6 host address output using the first syntax. 8.9. Network Address Types PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-21. It is better to use these types instead of plain text bytes IPv4 and IPv6 networks inet 7 or 19 bytes IPv4 and IPv6 hosts and networks macaddr 6 bytes MAC addresses When sorting inet or cidr data types, IPv4 addresses will always sort before IPv6 addresses