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.2 -r1.3
--- openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-postgresql.xql	27 Apr 2001 05:08:34 -0000	1.2
+++ openacs-4/packages/acs-subsite/www/admin/site-map/parameter-set-postgresql.xql	30 Apr 2001 20:11:24 -0000	1.3
@@ -1,32 +1,32 @@
 <?xml version="1.0"?>
+
 <queryset>
-<rdbms><type>postgresql</type><version>7.1</version></rdbms>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
-<fullquery name="package_info">
-  <querytext>
-
+<fullquery name="package_info">      
+      <querytext>
+      
     select package_key, acs_object__name(package_id) as instance_name
     from apm_packages
     where package_id = :package_id
 
-  </querytext>
+      </querytext>
 </fullquery>
 
-<fullquery name="parameter_table">
-  <querytext>
+ 
+<fullquery name="parameter_table">      
+      <querytext>
 
-        select p.parameter_id, p.parameter_name, 
-               coalesce(p.description, 'No Description') as description,
-	       coalesce(v.attr_value, 'No Value') as 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
-	      using (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, coalesce(p.description, 'No Description') as description,
+         coalesce(v.attr_value, 'No Value') as 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)
 
-  </querytext>
+      </querytext>
 </fullquery>
 
+ 
 </queryset>