Project

Profile

Help

Story #5402

Updated by bmbouter about 5 years 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