Index: openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/Attic/parameter-set-postgresql.xql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-postgresql.xql 20 Nov 2001 17:46:28 -0000 1.6 +++ openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-postgresql.xql 21 Jun 2002 19:08:33 -0000 1.7 @@ -1,35 +1,34 @@ - postgresql7.1 + postgresql7.1 - - - - select package_key, acs_object__name(package_id) as instance_name - from apm_packages - where package_id = :package_id + + + select package_key, + acs_object__name(package_id) as instance_name + from apm_packages + where package_id = :package_id + + - - + + + select p.parameter_id, + p.parameter_name, + p.package_key, + coalesce(p.description, 'No Description') as description, + v.attr_value, + coalesce(p.section_name, 'No Section Name') as section_name + from apm_parameters p left outer join + (select v.parameter_id, + v.attr_value + from apm_parameter_values v + where v.package_id = :package_id) v + on p.parameter_id = v.parameter_id + where p.package_key = (select package_key from apm_packages where package_id = :package_id) + $additional_sql + + - - - - -select p.parameter_id, p.parameter_name, p.package_key, - coalesce(p.description, 'No Description') as description, - v.attr_value, - coalesce(p.section_name, 'No Section Name') as section_name -from apm_parameters p left outer join (select parameter_id, attr_value - from apm_parameter_values v - where v.package_id = :package_id) v - on p.parameter_id = v.parameter_id -where p.package_key = (select package_key from apm_packages where package_id = :package_id) -$additional_sql - - - - -