Index: openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql,v
diff -u -r1.15 -r1.16
--- openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql	15 May 2007 20:14:15 -0000	1.15
+++ openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql	27 Sep 2007 13:21:22 -0000	1.16
@@ -1273,7 +1273,7 @@
                          -- This is where we add the event
                          v_event_id := acs_event__new_instance(
                               insert_instances__event_id,					   -- event_id
-                              date_trunc(''day'',v_week_date) - date_trunc(''day'',v_event_date)    -- offset
+                              date_trunc(''day'',v_week_date :: timestamp) - date_trunc(''day'',v_event_date :: timestamp)    -- offset
                          );
                          v_last_date_done := v_week_date;
 
