Index: openacs.org-dev/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql,v
diff -u -r1.1.1.1 -r1.1.1.2
--- openacs.org-dev/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	9 Jul 2002 17:35:05 -0000	1.1.1.1
+++ openacs.org-dev/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	8 Oct 2002 15:47:06 -0000	1.1.1.2
@@ -6,6 +6,14 @@
     <version>7.1</version>
   </rdbms>
 
+  <fullquery name="ec_combocategory_widget.get_combocategories">      
+    <querytext>
+      select c.category_id, s.subcategory_id, category_name, subcategory_name 
+      from ec_categories c left
+      outer join ec_subcategories s using (category_id)
+    </querytext>
+  </fullquery>
+  
   <partialquery name="ec_gift_certificate_expires_widget.now">
     <querytext>
       current_timestamp