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.5 -r1.6
--- openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql 26 May 2002 04:36:50 -0000 1.5
+++ openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql 12 Sep 2002 22:10:27 -0000 1.6
@@ -6,6 +6,14 @@
7.1
+
+
+ select c.category_id, s.subcategory_id, category_name, subcategory_name
+ from ec_categories c left
+ outer join ec_subcategories s using (category_id)
+
+
+
current_timestamp