[  etch-backports  ] [  lenny  ] [  squeeze  ] [  sid  ]
[ Källkod: ip4r  ]

Paket: postgresql-8.3-ip4r (1.03-2)

IPv4 and IPv4 range index types for PostgreSQL 8.3

This PostgreSQL module provides two data types, ip4 and ip4r, which can contain a single IPv4 address or a range of IPv4 addresses, respectively.

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

Andra paket besläktade med postgresql-8.3-ip4r

  • beror
  • rekommenderar
  • föreslår
  • dep: libc0.1 (>= 2.3) [kfreebsd-amd64, kfreebsd-i386]
    GNU C-bibliotek: Delade bibliotek
    också ett virtuellt paket som tillhandahålls av libc0.1-udeb
  • dep: libc0.3 (>= 2.9) [hurd-i386]
    GNU C-bibliotek: Delade bibliotek
    också ett virtuellt paket som tillhandahålls av libc0.3-udeb
  • dep: libc6 (>= 2.7-1) [ej alpha, hurd-i386, ia64, kfreebsd-amd64, kfreebsd-i386]
    GNU C-bibliotek: Delade bibliotek
    också ett virtuellt paket som tillhandahålls av libc6-udeb
  • dep: libc6.1 (>= 2.7-1) [alpha, ia64]
    GNU C-bibliotek: Delade bibliotek
    också ett virtuellt paket som tillhandahålls av libc6.1-udeb
  • rec: postgresql-8.3
    object-relational SQL database, version 8.3 server

Hämta postgresql-8.3-ip4r

Hämtningar för alla tillgängliga arkitekturer
Arkitektur Paketstorlek Installerad storlek Filer
alpha 24,7 kbyte132 kbyte [filförteckning]
amd64 23,0 kbyte68 kbyte [filförteckning]
armel 21,9 kbyte116 kbyte [filförteckning]
hppa 22,6 kbyte120 kbyte [filförteckning]
hurd-i386 20,8 kbyte116 kbyte [filförteckning]
i386 21,7 kbyte64 kbyte [filförteckning]
ia64 25,6 kbyte136 kbyte [filförteckning]
kfreebsd-amd64 23,0 kbyte88 kbyte [filförteckning]
kfreebsd-i386 21,7 kbyte82 kbyte [filförteckning]
mips 21,2 kbyte124 kbyte [filförteckning]
mipsel 21,1 kbyte124 kbyte [filförteckning]
powerpc 24,3 kbyte128 kbyte [filförteckning]
s390 24,5 kbyte124 kbyte [filförteckning]
sparc 22,0 kbyte120 kbyte [filförteckning]