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 -N -r1.1.4.1 -r1.1.4.2 --- openacs-4/packages/spam/sql/postgresql/spam-packages.sql 21 Jan 2003 13:53:25 -0000 1.1.4.1 +++ openacs-4/packages/spam/sql/postgresql/spam-packages.sql 2 Mar 2003 22:53:22 -0000 1.1.4.2 @@ -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