Project

Profile

Help

Story #5402

Updated by bmbouter 11 months ago

In order to be able to do things like ORDER BY (EVR) in postgres on the <code>Package</code> content unit, postgres, we need to have a type and a comparison method available. Some examples of this include:

Debian:
* https://packages.debian.org/sid/postgresql-11-debversion

Spacewalk:
* https://github.com/spacewalkproject/spacewalk/blob/master/schema/spacewalk/postgres/class/evr_t.sql
* https://github.com/spacewalkproject/spacewalk/blob/master/schema/spacewalk/postgres/packages/rpm.pkb#L194

VMaaS:
* https://github.com/RedHatInsights/vmaas/blob/master/database/vmaas_db_postgresql.sql#L8

We should probably adopt one of the existing methods for into the "Package model":https://github.com/pulp/pulp_rpm/blob/master/pulp_rpm/app/models.py#L34.
Pulp3 codebase.

Back