Index: openacs-4/packages/ecommerce/www/product-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/product-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/ecommerce/www/product-postgresql.xql 10 Jul 2001 20:42:02 -0000 1.1 +++ openacs-4/packages/ecommerce/www/product-postgresql.xql 11 Jul 2001 04:52:05 -0000 1.2 @@ -5,7 +5,6 @@ - FIX ME ROWNUM select * from (select category_id, @@ -18,7 +17,7 @@ from ec_category_product_map m where product_id = :product_id order by subcount, subsubcount, category_id) - where rownum = 1 + limit 1