Index: openacs-4/packages/acs-admin/www/apm/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/index-postgresql.xql,v
diff -u -N -r1.7 -r1.7.4.1
--- openacs-4/packages/acs-admin/www/apm/index-postgresql.xql	27 Oct 2014 16:38:51 -0000	1.7
+++ openacs-4/packages/acs-admin/www/apm/index-postgresql.xql	3 Apr 2021 14:10:06 -0000	1.7.4.1
@@ -2,27 +2,28 @@
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
-<fullquery name="apm_table">      
-      <querytext>
+<fullquery name="apm_table">
+  <querytext>
 
-        select  v.version_id, v.package_key, t.pretty_name, v.version_name, 
-		to_char(v.release_date, 'YYYY-MM-DD') as release_date, 
-		v.enabled_p, v.installed_p, v.distribution_uri,
-            (select count(*) from apm_package_versions v2
-             where v2.package_key = v.package_key
-             and   v2.installed_p
-             and   apm_package_version__sortable_version_name(v2.version_name) >
-                   apm_package_version__sortable_version_name(v.version_name)) as  superseded_p,
-             case
-               when content_item__get_latest_revision(item_id) is null
-               then 0
-               else 1
-             end as tarball_p
-        from    apm_package_versions v, apm_package_types t
-        where  t.package_key = v.package_key
-        $filter_where_clause
-        [template::list::orderby_clause -orderby -name package_list]
-      </querytext>
+    select
+        v.version_id, v.package_key, t.pretty_name, v.version_name,
+        to_char(v.release_date, 'YYYY-MM-DD') as release_date,
+        v.enabled_p, v.installed_p, v.distribution_uri,
+        (select count(*) from apm_package_versions v2
+            where v2.package_key = v.package_key
+            and   v2.installed_p
+            and   apm_package_version__sortable_version_name(v2.version_name) >
+            apm_package_version__sortable_version_name(v.version_name)) as superseded_p,
+        case
+            when content_item__get_latest_revision(item_id) is null
+            then 0
+            else 1
+        end as tarball_p
+    from    apm_package_versions v, apm_package_types t
+    where  t.package_key = v.package_key
+    $filter_where_clause
+    [template::list::orderby_clause -orderby -name package_list]
+  </querytext>
 </fullquery>
 
 <partialquery name="latest">
@@ -35,5 +36,5 @@
              apm_package_version__sortable_version_name(v.version_name)))
    </querytext>
 </partialquery>
- 
+
 </queryset>