X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=daklib%2Fcontents.py;h=056da53f18d244c8ed28a51a440d0dac364d3c11;hb=ddf0f7dd6691ac530013468c68b6e81118c67a31;hp=65e7e3f1c31dedd1f0fc660550d0b0ed3f077268;hpb=edae3d82ea0b9cebbb3921930e1e62028efc73fd;p=dak.git

diff --git a/daklib/contents.py b/daklib/contents.py
index 65e7e3f1..056da53f 100755
--- a/daklib/contents.py
+++ b/daklib/contents.py
@@ -92,7 +92,7 @@ unique_override as
         where o.suite = :overridesuite and o.type = :type_id and o.section = s.id and
         o.component = :component)
 
-select bc.file, substring(o.section from position('/' in o.section) + 1) || '/' || b.package as package
+select bc.file, o.section || '/' || b.package as package
     from newest_binaries b, bin_contents bc, unique_override o
     where b.id = bc.binary_id and o.package = b.package
     order by bc.file, b.package'''
@@ -120,7 +120,7 @@ unique_override as
         where o.suite = :overridesuite and o.type = :type_id and o.section = s.id
         order by o.package, s.section, o.modified desc)
 
-select bc.file, substring(o.section from position('/' in o.section) + 1) || '/' || b.package as package
+select bc.file, o.section || '/' || b.package as package
     from newest_binaries b, bin_contents bc, unique_override o
     where b.id = bc.binary_id and o.package = b.package
     order by bc.file, b.package'''