debversion

pig repo add pgdg -u    # add pgdg repo and update cache

pig install debversion;		# install via package name, for the active PG version

pig install debversion -v 18;   # install for PG 18
pig install debversion -v 17;   # install for PG 17
pig install debversion -v 16;   # install for PG 16
pig install debversion -v 15;   # install for PG 15
pig install debversion -v 14;   # install for PG 14

CREATE EXTENSION debversion;

CREATE EXTENSION debversion;

CREATE TABLE packages (
    name    text,
    version debversion
);

INSERT INTO packages VALUES ('foo', '1.0-1'), ('foo', '2.0-1'), ('foo', '1.0-2');

SELECT * FROM packages ORDER BY version;

SELECT '1.60-26+b1'::debversion < '1.60+git20161116.90da8a0-1'::debversion;