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.3 -r1.4
--- openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	20 Jul 2001 21:53:59 -0000	1.3
+++ openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	29 Jan 2002 00:11:46 -0000	1.4
@@ -1,51 +1,50 @@
 <?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="ec_date_widget.date_widget_select">      
-      <querytext>
-      select to_char(current_timestamp, 'YYYY-MM-DD') 
-      </querytext>
-</fullquery>
+  <partialquery name="ec_gift_certificate_expires_widget.now">
+    <querytext>
+      current_timestamp
+    </querytext>
+  </partialquery>
 
- 
-<fullquery name="ec_time_widget.time_widget_select">      
-      <querytext>
+  <fullquery name="ec_date_widget.date_widget_select">      
+    <querytext>
+      select to_char(current_timestamp, 'YYYY-MM-DD') 
+    </querytext>
+  </fullquery>
+  
+  <fullquery name="ec_time_widget.time_widget_select">      
+    <querytext>
       select to_char(current_timestamp, 'HH24:MI:SS') 
-      </querytext>
-</fullquery>
+    </querytext>
+  </fullquery>
 
-
-<fullquery name="ec_category_widget.get_category_info_joined_w_children">
-      <querytext>
-
-    select c.category_id, c.category_name,
-           s.subcategory_id, s.subcategory_name,
-           ss.subsubcategory_id, ss.subsubcategory_name
+  <fullquery name="ec_category_widget.get_category_info_joined_w_children">
+    <querytext>
+      select c.category_id, c.category_name,
+      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)
-  order by c.sort_key, s.sort_key, ss.sort_key
+      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>
 
-      </querytext>
-</fullquery>
-
-
-<fullquery name="ec_mailing_list_widget.get_category_children">
-      <querytext>
-
-    select c.category_id, c.category_name, s.subcategory_id, s.subcategory_name, ss.subsubcategory_id, ss.subsubcategory_name
+  <fullquery name="ec_mailing_list_widget.get_category_children">
+    <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)
-    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, 
-	case when ss.subcategory_id is null then 0 else ss.sort_key end
-
-      </querytext>
-</fullquery>
- 
+      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, 
+      case when ss.subcategory_id is null then 0 else ss.sort_key end
+    </querytext>
+  </fullquery>
+  
 </queryset>