diff options
author | Boris Kolpackov <boris@codesynthesis.com> | 2015-10-31 21:38:19 +0200 |
---|---|---|
committer | Boris Kolpackov <boris@codesynthesis.com> | 2015-11-02 20:08:21 +0200 |
commit | 4993f11bf464c9aee0e3fd5965f4a8258cbe8b30 (patch) | |
tree | 0abdc530e0a95dc6c6b4e40068be7d8554bca686 /brep/package-extra.sql | |
parent | 5b336ac46f60606cdcf77889d624ce15cdd62530 (diff) |
Bug fix in latest_packages() PostgreSQL function
Diffstat (limited to 'brep/package-extra.sql')
-rw-r--r-- | brep/package-extra.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/brep/package-extra.sql b/brep/package-extra.sql index d30a48e..6859173 100644 --- a/brep/package-extra.sql +++ b/brep/package-extra.sql @@ -14,7 +14,8 @@ latest_packages() RETURNS SETOF package AS $$ SELECT p1.* FROM package p1 LEFT JOIN package p2 ON ( - p1.name = p2.name AND + p1.internal_repository IS NOT NULL AND p1.name = p2.name AND + p2.internal_repository IS NOT NULL AND (p1.version_epoch < p2.version_epoch OR p1.version_epoch = p2.version_epoch AND (p1.version_canonical_upstream < p2.version_canonical_upstream OR |