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.3 -r1.4 --- openacs-4/packages/acs-admin/www/apm/version-dependencies-postgresql.xql 13 Apr 2009 23:10:27 -0000 1.3 +++ openacs-4/packages/acs-admin/www/apm/version-dependencies-postgresql.xql 3 Sep 2024 15:37:29 -0000 1.4 @@ -1,42 +1,42 @@ - postgresql7.1 + postgresql7.1 - - - - select package_key, pretty_name, version_name, installed_p - from apm_package_version_info + + + + select package_key, pretty_name, version_name, installed_p + from apm_package_version_info where version_id = :version_id - + - - - - - select dependency_id, service_uri, service_version - from apm_package_dependencies - where version_id = :version_id - and dependency_type = :dependency_type_prep - order by service_uri - - + + + + + select dependency_id, service_uri, service_version + from apm_package_dependencies + where version_id = :version_id + and dependency_type = :dependency_type_prep + order by service_uri + + - - - + + + select t.pretty_name as dep_pretty_name, v.version_name as dep_version_name, v.version_id as dep_version_id, d.dependency_type as dep_type from apm_package_versions v, apm_package_dependencies d, apm_package_types t where d.service_uri = :service_uri and d.dependency_type in ($other_dependency_in) and d.version_id = v.version_id - and t.package_key = v.package_key + 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) - +