This extension to postgreSQL implements a new function for the comparison of debian package versions in PL/pgSQL.

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 deb_version_cmp function for version comparison.

Version comparison uses the algorithm used by the Debian package manager, dpkg, using the implementation from libapt-pkg. This means that value comparing uses the same logic as dpkg --compare-versions.

postgresql-debversion-evr implements the following features:

• The deb_version_cmp function (comparing two text values)

How to install the extension:

• download the extension
• go to folder containing the extension and run make install
• inside the postgres database run CREATE EXTENSION debversion_evr;
• to uninstall extension from postgres run DROP EXTENSION debversion_evr; in database

How to run tests:

• go to file sql/debversion_test.sql

• add test statements as SELECT commands, eg

  SELECT deb_version_cmp('1.60-26+b1', '1.60+git20161116.90da8a0-1');

• go to folder expected/and run python3 debversion_test.py (this generates the output file debversion_test.out using the dpkg --compare-versions command in bash or libapt-pkg python-library)

• in main directory run make installcheck

Some parts have been taken from an already existing extension postgresql-debversion from Roger Leigh which stands under the GNU General Public License and can be found at https://salsa.debian.org/postgresql/postgresql-debversion/-/tree/master.

The PL/pgSQL function for debian version comparison has been implemented by Katharina Kreuzer based on an implentation by Matthias Dellweg.