IPv4 and IPv6 types and range operations
ip4r
extension provides data types and functions for working with IPv4 and IPv6 addresses and ranges. It’s particularly useful for network-related applications, IP-based access control, and geolocation services.
Your Nile database arrives with the ip4r
extension already enabled.
ip4
- IPv4 addressip4r
- IPv4 rangeip6
- IPv6 addressip6r
- IPv6 rangeipaddress
- Can store either IPv4 or IPv6 addressiprange
- Can store either IPv4 or IPv6 range>>
(contains)>>=
(contains or equals)<<
(contained by)<<=
(contained by or equals)&&
(overlaps)inet
type for basic IP address storagecidr
type for network ranges without host bits