Index: openacs-4/packages/acs-admin/www/apm/version-dependencies-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/version-dependencies-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-admin/www/apm/version-dependencies-postgresql.xql	27 Apr 2001 01:41:12 -0000	1.1
+++ openacs-4/packages/acs-admin/www/apm/version-dependencies-postgresql.xql	28 Apr 2001 17:35:30 -0000	1.2
@@ -24,5 +24,19 @@
     
       </querytext>
 </fullquery>
+ 
+<fullquery name="apm_specific_version_dependencies">      
+      <querytext>
+        select t.pretty_name as dep_pretty_name, v.version_name as dep_version_name,
+               v.version_id as dep_version_id
+        from apm_package_versions v, apm_package_dependencies d, apm_package_types t
+        where d.service_uri = :service_uri
+           and d.dependency_type = :other_dependency_type_prep
+           and d.version_id = v.version_id
+           and t.package_key = v.package_key 
+           and apm_package_version__sortable_version_name(d.service_version) $sign
+               apm_package_version__sortable_version_name(:service_version)
+      </querytext>
+</fullquery>
 
 </queryset>