|File Search||Catalog||Content Search|
While PostgreSQL already has built-in types 'inet' and 'cidr', the authors of this module found that they had a number of requirements that were not addressed by the built-in type.
Firstly and most importantly, the built-in types have no support for index lookups of the form (column >>= parameter), i.e. where you have a table of IP address ranges and wish to find which ones include a given IP address. This requires an rtree or gist index to do efficiently, and also requires a way to represent IP address ranges that do not fall precisely on CIDR boundaries.
Secondly, the built-in inet/cidr are somewhat overloaded with semantics, with inet combining two distinct concepts (a netblock, and a specific IP within that netblock). Furthermore, they are variable length types (to support IPv6) with non-trivial overheads, and the authors (whose applications mainly deal in large volumes of single IPv4 addresses) wanted a more lightweight representation.
ip4r therefore supports two distinct data types (so far):
ip4 - a single IPv4 address ip4r - an arbitrary range of IPv4 addresses
IP4R - IPv4 and IPv4 range index type for PostgreSQL ===================================================== RATIONALE ========= While PostgreSQL already has builtin types 'inet' and 'cidr', the authors of this module found that they had a number of requirements that were not addressed by the builtin type. Firstly and most importantly, the builtin types have no support for index lookups of the more»
ip4r (1.05-0.1) unstable; urgency=low * Non-maintainer upload. * New upstream version compatible with PG 9.0. * Convert to use pg_buildext to build against PG 9.1; closes: #605711, #639470. -- Christoph Berg <email@example.com> Sat, 08 Oct 2011 14:34:24 +0200 ip4r (1.04-1) unstable; urgency=low * New upstream release; closes: #537693. * Drop postgresql-8.3-ip4r and build postgres more»
This package was debianized by Robert Edmonds <firstname.lastname@example.org> on Thu, 16 Mar 2006 13:50:09 -0500. It was downloaded from http://pgfoundry.org/projects/ip4r/ Copyright Holders: Andrew - Supernews <email@example.com> Steve Atkins <firstname.lastname@example.org> License: This code is available under the terms of the BSD license. On Debian GNU/Linux systems, the complete text of the BSD license can more»