Index: openacs-4/packages/ecommerce/tcl/ecommerce-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-procs-postgresql.xql,v
diff -u -r1.10.2.1 -r1.10.2.2
--- openacs-4/packages/ecommerce/tcl/ecommerce-procs-postgresql.xql 8 Dec 2002 21:38:13 -0000 1.10.2.1
+++ openacs-4/packages/ecommerce/tcl/ecommerce-procs-postgresql.xql 14 May 2003 19:52:45 -0000 1.10.2.2
@@ -40,6 +40,14 @@
+
+
+ select category_id, subcategory_id, subsubcategory_id, product_id
+ from ($common_sql) as dummy
+ limit 1
+
+
+
select case when current_timestamp > available_date then 1 when current_timestamp-available_date is NULL then 1 else 0 end as available_p,