Index: openacs-4/packages/acs-events/sql/postgresql/oracle-compat-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/oracle-compat-create.sql,v diff -u -N -r1.3 -r1.4 --- openacs-4/packages/acs-events/sql/postgresql/oracle-compat-create.sql 21 Dec 2002 22:32:10 -0000 1.3 +++ openacs-4/packages/acs-events/sql/postgresql/oracle-compat-create.sql 17 May 2003 09:46:57 -0000 1.4 @@ -101,10 +101,10 @@ -- -- @return The date of the next weekday that is later than somedate -- - timestamp, -- somedate + timestamptz, -- somedate varchar -- weekday ) -returns timestamp as ' +returns timestamptz as ' declare next_day__somedate alias for $1; next_day__weekday alias for $2; @@ -143,10 +143,10 @@ -- -- @return The date plus n_months full months -- - timestamp, + timestamptz, integer ) -returns timestamp as ' +returns timestamptz as ' declare add_months__somedate alias for $1; add_months__n_months alias for $2; @@ -167,15 +167,15 @@ -- -- @return The last day of the month containing somedate -- - timestamp + timestamptz ) -returns timestamp as ' +returns timestamptz as ' declare last_day__somedate alias for $1; v_month integer; v_targetmonth integer; - v_date timestamp; - v_targetdate timestamp; + v_date timestamptz; + v_targetdate timestamptz; begin -- Initial values