Index: openacs-4/packages/calendar/tcl/cal-item-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/cal-item-procs-postgresql.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/calendar/tcl/cal-item-procs-postgresql.xql	3 Jul 2002 18:48:56 -0000	1.9
+++ openacs-4/packages/calendar/tcl/cal-item-procs-postgresql.xql	8 Jul 2002 20:54:34 -0000	1.10
@@ -61,8 +61,8 @@
 <fullquery name="cal_item_create.insert_timespan">      
       <querytext>
 	select timespan__new (    
-					timestamp :start_date,
-					timestamp :end_date
+					:start_date::timestamp,
+					:end_date::timestamp
 	) 
 
       </querytext>
@@ -108,8 +108,8 @@
       <querytext>
 	select time_interval__edit (
 					:interval_id,
-					timestamp :start_date,
-					timestamp :end_date
+					:start_date::timestamp,
+					:end_date::timestamp
 	)
 
       </querytext>
Index: openacs-4/packages/calendar/tcl/calendar-display-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/Attic/calendar-display-procs-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/calendar/tcl/calendar-display-procs-postgresql.xql	15 May 2002 22:34:57 -0000	1.4
+++ openacs-4/packages/calendar/tcl/calendar-display-procs-postgresql.xql	8 Jul 2002 20:54:34 -0000	1.5
@@ -35,9 +35,9 @@
 <querytext>
         select   to_char(to_date(:current_date, 'yyyy-mm-dd'), 'D') 
         as       day_of_the_week,
-        to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday')) 
+        to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')- '1 week'::timespan, 'Sunday'), 'D')
         as       sunday_of_the_week,
-        to_char(next_day(to_date(:current_date, 'yyyy-mm-dd'), 'Saturday')) 
+        to_char(next_day(to_date(:current_date, 'yyyy-mm-dd'), 'Saturday'), 'D')
         as       saturday_of_the_week
         from     dual
 </querytext>