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.6 -r1.7
--- openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	12 Sep 2002 22:10:27 -0000	1.6
+++ openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	13 Jan 2005 13:57:56 -0000	1.7
@@ -11,6 +11,7 @@
       select c.category_id, s.subcategory_id, category_name, subcategory_name 
       from ec_categories c left
       outer join ec_subcategories s using (category_id)
+      order by c.sort_key, s.sort_key
     </querytext>
   </fullquery>