On Wed, Nov 30, 2011 at 1:08 PM, Jeff Davis <pg...@j-davis.com> wrote: > One that I'd like to see is an IP address type, but that's complicated > because inet and cidr support netmasks.
A CIDR address defines a range all by itself, without packing any other type on top. It just needs GIST support, and an indexable operator for "contains or is contained by"; then, you can define an exclusion constraint over a CIDR column to enforce a no-duplicate-or-overlapping-IP-ranges rule. I started working on that at one point, but I didn't have as much enthusiasm as the task needed so I gave up before accomplishing anything particularly useful. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
