Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql,v diff -u -r1.7.2.1 -r1.7.2.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql 4 Oct 2002 08:08:20 -0000 1.7.2.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql 21 Jan 2003 13:45:03 -0000 1.7.2.2 @@ -120,7 +120,7 @@ -- The Oracle version does allow a non-image type to be specified, as does my -- alternative down below. This needs a little more straightening out. -create function image__new (varchar,integer,integer,integer,varchar,integer,varchar,varchar,varchar,varchar,boolean,timestamp,varchar,integer,integer,integer +create function image__new (varchar,integer,integer,integer,varchar,integer,varchar,varchar,varchar,varchar,boolean,timestamp with time zone,varchar,integer,integer,integer ) returns integer as ' declare new__name alias for $1; @@ -284,7 +284,7 @@ return v_item_id; end; ' language 'plpgsql'; -create function image__new_revision(integer, integer, varchar, varchar, timestamp, varchar, varchar, +create function image__new_revision(integer, integer, varchar, varchar, timestamp with time zone, varchar, varchar, integer, varchar, integer, integer) returns integer as ' declare p_item_id alias for $1;