[  lenny-backports  ] [  squeeze  ] [  sid  ]
[ Source: postgresql-debversion  ]

Package: postgresql-8.3-debversion (1.0.2-1 and others)

Debian version number type for PostgreSQL

Debian version numbers, used to version Debian binary and source packages, have a defined format, including specifications for how versions should be compared in order to sort them. This package implements a "debversion" type to represent Debian version numbers within the PostgreSQL database. This also includes operators for version comparison and index operator classes for creating indexes on the debversion type.

Version comparison uses the algorithm used by the Debian package manager, dpkg, using the implementation from libapt-pkg. This means that columns in tables using the debversion type may be sorted and compared correctly using the same logic as "dpkg --compare-versions". It is also possible to create indexes on these columns.

postgresql-debversion implements the following features: 

 * The "debversion" type (internally derived from the "text" type)
 * A full set of operators for version comparison (< <= = <> >= >)
   including commutator and negator optimisation hints
 * Operator classes for btree and hash indexes
 * The aggregate functions min() and max()

Other Packages Related to postgresql-8.3-debversion

  • depends
  • recommends
  • suggests
  • dep: libapt-pkg-libc6.9-6-4.8
    virtual package provided by apt
  • dep: libc6 (>= 2.1.3) [i386, powerpc, s390]
    GNU C Library: Shared libraries
    also a virtual package provided by libc6-udeb
    dep: libc6 (>= 2.2) [hppa, mips, mipsel]
    dep: libc6 (>= 2.2.5) [amd64]
    dep: libc6 (>= 2.4) [armel]
    dep: libc6 (>= 2.6) [sparc]
  • dep: libc6.1 (>= 2.2) [ia64]
    GNU C Library: Shared libraries
    also a virtual package provided by libc6.1-udeb
  • dep: libgcc1 (>= 1:4.1.1) [not armel, hppa]
    GCC support library
    dep: libgcc1 (>= 1:4.4.0) [armel]
  • dep: libgcc4 (>= 4.1.1) [hppa]
    GCC support library
  • dep: libstdc++6 (>= 4.1.1) [not armel]
    The GNU Standard C++ Library v3
    dep: libstdc++6 (>= 4.4.0) [armel]
  • dep: libunwind7 (>= 0.98.5-6) [ia64]
    A library to determine the call-chain of a program - runtime
  • dep: postgresql-8.3
    object-relational SQL database, version 8.3 server

Download postgresql-8.3-debversion

Download for all available architectures
Architecture Version Package Size Installed Size Files
amd64 1.0.2-1+b1 10.7 kB44 kB [list of files]
armel 1.0.2-1+b2 10.0 kB92 kB [list of files]
hppa 1.0.2-1+b1 11.3 kB96 kB [list of files]
i386 1.0.2-1+b1 10.6 kB92 kB [list of files]
ia64 1.0.2-1+b2 11.2 kB100 kB [list of files]
mips 1.0.2-1+b1 10.7 kB96 kB [list of files]
mipsel 1.0.2-1+b1 10.7 kB96 kB [list of files]
powerpc 1.0.2-1+b1 13.1 kB100 kB [list of files]
s390 1.0.2-1+b1 10.8 kB92 kB [list of files]
sparc 1.0.2-1+b1 10.5 kB92 kB [list of files]