Re: [SQL] inet versus text for ip addresses

2003-07-20 Thread Bruce Momjian
Dan Langille wrote: > The PostgreSQL inet datatype stores an holds an IP host address, and > optionally the identity of the subnet it is in, all in one field. > This requires 12 bytes. > > Using my "random" data of approximately 8000 IP addresses collected > during previous polls, I've foun

[SQL] inet versus text for ip addresses

2003-07-04 Thread Dan Langille
The PostgreSQL inet datatype stores an holds an IP host address, and optionally the identity of the subnet it is in, all in one field. This requires 12 bytes. Using my "random" data of approximately 8000 IP addresses collected during previous polls, I've found the average length of an IP ad