Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql,v
diff -u -r1.39.2.2 -r1.39.2.3
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	27 Feb 2003 13:44:55 -0000	1.39.2.2
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	1 Mar 2003 21:21:20 -0000	1.39.2.3
@@ -54,7 +54,7 @@
 
 
 -- function new
-create function content_item__new (varchar,integer,integer,varchar,timestamp with time zone,integer,integer,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar)
+create function content_item__new (varchar,integer,integer,varchar,timestamptz,integer,integer,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar)
 returns integer as '
 declare
   new__name                   alias for $1;  
@@ -212,7 +212,7 @@
  
 end;' language 'plpgsql';
 
-create function content_item__new (varchar,integer,integer,varchar,timestamp with time zone,integer,integer,varchar,varchar,varchar,varchar,varchar,varchar,varchar,integer)
+create function content_item__new (varchar,integer,integer,varchar,timestamptz,integer,integer,varchar,varchar,varchar,varchar,varchar,varchar,varchar,integer)
 returns integer as '
 declare
   new__name                   alias for $1;  
@@ -416,7 +416,7 @@
 
 -- function new -- sets security_inherit_p to FALSE -DaveB
 
-create function content_item__new ( integer, varchar, integer, varchar, timestamp with time zone, integer, integer, varchar, boolean, varchar, text, varchar, boolean, varchar,varchar,varchar)
+create function content_item__new ( integer, varchar, integer, varchar, timestamptz, integer, integer, varchar, boolean, varchar, text, varchar, boolean, varchar,varchar,varchar)
 
 returns integer as '
 declare
@@ -1605,7 +1605,7 @@
 
 
 -- procedure set_release_period
-create function content_item__set_release_period (integer, timestamp with time zone, timestamp with time zone)
+create function content_item__set_release_period (integer, timestamptz, timestamptz)
 returns integer as '
 declare
   set_release_period__item_id                alias for $1;  
@@ -1984,7 +1984,7 @@
 
 -- function get_publish_date
 create function content_item__get_publish_date (integer,boolean)
-returns timestamp as '
+returns timestamptz as '
 declare
   get_publish_date__item_id                alias for $1;  
   get_publish_date__is_live                alias for $2;  -- default ''f''