Index: openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql	9 Jul 2001 23:44:19 -0000	1.1
+++ openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql	16 Jul 2001 18:32:26 -0000	1.2
@@ -46,6 +46,17 @@
 END;
 ' language 'plpgsql';
 
+-- gilbertw
+-- timespan_days taken from OpenACS 3.2.5
+create function timespan_days(integer) returns interval as '
+DECLARE
+        n_days alias for $1;
+BEGIN
+        return (n_days || '' days'')::interval;
+END;
+' language 'plpgsql';
+
+
 -- I should have named this product_templates because now we
 -- have other kinds of templates.