Index: openacs-4/packages/spam/sql/postgresql/spam-packages.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/spam/sql/postgresql/spam-packages.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/spam/sql/postgresql/spam-packages.sql 21 Dec 2002 22:27:03 -0000 1.2 +++ openacs-4/packages/spam/sql/postgresql/spam-packages.sql 17 May 2003 11:36:10 -0000 1.3 @@ -2,7 +2,7 @@ -- -create function spam__new (integer,varchar,timestamp,text,varchar,text,varchar,varchar,integer,timestamp with time zone,integer,varchar,varchar,boolean,varchar,timestamp with time zone) +create function spam__new (integer,varchar,timestamptz,text,varchar,text,varchar,varchar,integer,timestamptz,integer,varchar,varchar,boolean,varchar,timestamptz) returns integer as ' declare p_spam_id alias for $1; -- default null @@ -124,7 +124,7 @@ -- procedure edit -create function spam__edit (integer,text,varchar,varchar,varchar,timestamp with time zone) returns integer as ' +create function spam__edit (integer,text,varchar,varchar,varchar,timestamptz) returns integer as ' declare p_spam_id alias for $1; -- spam_messages.spam_id%TYPE, p_title alias for $2; -- acs_mail_bodies.header_subject%TYPE default null @@ -249,7 +249,7 @@ -create function spam__new_content (integer,timestamp with time zone,integer,varchar,varchar,varchar,varchar,integer) +create function spam__new_content (integer,timestamptz,integer,varchar,varchar,varchar,varchar,integer) returns integer as ' declare context_id alias for $1; -- acs_objects.context_id%TYPE