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.3 -r1.4
--- openacs-4/packages/acs-admin/www/apm/index-postgresql.xql	5 May 2001 17:39:19 -0000	1.3
+++ openacs-4/packages/acs-admin/www/apm/index-postgresql.xql	13 May 2001 01:53:18 -0000	1.4
@@ -24,5 +24,15 @@
       </querytext>
 </fullquery>
 
+<partialquery name="latest">
+   <querytext>
+     (installed_p = 't' or enabled_p = 't' or not exists (
+        select 1 from apm_package_versions v2
+        where v2.package_key = v.package_key
+          and (v2.installed_p = 't' or v2.enabled_p = 't')
+         and apm_package_version__sortable_version_name(v2.version_name) >
+             apm_package_version__sortable_version_name(v.version_name)))
+   </querytext>
+</partialquery>
  
 </queryset>