Index: openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	29 Jan 2002 00:11:46 -0000	1.4
+++ openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	26 May 2002 04:36:50 -0000	1.5
@@ -1,7 +1,10 @@
 <?xml version="1.0"?>
 
 <queryset>
-  <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+  <rdbms>
+    <type>postgresql</type>
+    <version>7.1</version>
+  </rdbms>
 
   <partialquery name="ec_gift_certificate_expires_widget.now">
     <querytext>
@@ -27,8 +30,8 @@
       s.subcategory_id, s.subcategory_name,
       ss.subsubcategory_id, ss.subsubcategory_name
       from ec_categories c
-      LEFT JOIN ec_subcategories s using (category_id)
-      LEFT JOIN ec_subsubcategories ss on (s.subcategory_id = ss.subcategory_id)
+      left join ec_subcategories s using (category_id)
+      left join ec_subsubcategories ss on (s.subcategory_id = ss.subcategory_id)
       order by c.sort_key, s.sort_key, ss.sort_key
     </querytext>
   </fullquery>
@@ -37,9 +40,9 @@
     <querytext>
       select c.category_id, c.category_name, s.subcategory_id, s.subcategory_name, ss.subsubcategory_id, ss.subsubcategory_name
       from ec_cat_mailing_lists m
-      LEFT JOIN ec_categories c on (m.category_id=c.category_id)
-      LEFT JOIN ec_subcategories s on (m.subcategory_id=s.subcategory_id)
-      LEFT JOIN ec_subsubcategories ss on (m.subsubcategory_id=ss.subsubcategory_id)
+      left join ec_categories c on (m.category_id=c.category_id)
+      left join ec_subcategories s on (m.subcategory_id=s.subcategory_id)
+      left join ec_subsubcategories ss on (m.subsubcategory_id=ss.subsubcategory_id)
       order by 
       case when c.category_id is null then 0 else c.sort_key end, 
       case when s.subcategory_id is null then 0 else s.sort_key end,