Index: openacs-4/packages/ref-timezones/sql/postgresql/ref-timezones-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-timezones/sql/postgresql/ref-timezones-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ref-timezones/sql/postgresql/ref-timezones-create.sql	16 Oct 2001 01:35:32 -0000	1.3
+++ openacs-4/packages/ref-timezones/sql/postgresql/ref-timezones-create.sql	20 Feb 2002 20:43:31 -0000	1.4
@@ -103,7 +103,7 @@
 declare
   p_raw_date alias for $1;
 begin
-  return timestamp (p_raw_date || ''+00'');
+  return cast (p_raw_date || ''+00'' as timestamp);
 end;' language 'plpgsql';
 
 create function timezone__new (varchar, varchar) returns integer as '
@@ -168,15 +168,15 @@
 foo varchar;
 begin
 
-  select timestamp (p_local_varchar || substr(gmt_offset,1,5)) into v_base_time
+  select cast (p_local_varchar || substr(gmt_offset,1,5) as timestamp) into v_base_time
   from timezones
   where tz_id = p_tz_id;
 
   if not found then
-    return timestamp (p_local_varchar || ''+00'');
+    return cast (p_local_varchar || ''+00'' as timestamp);
   end if;
 
-  return timestamp (p_local_varchar || ''+00'') - interval (gmt_offset || ''seconds'')
+  return cast (p_local_varchar || ''+00'' as timestamp) - interval (gmt_offset || ''seconds'')
   from   timezone_rules
   where  tz_id = p_tz_id and v_base_time between utc_start and utc_end;