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.2 -r1.3 --- openacs-4/packages/acs-events/sql/postgresql/oracle-compat-create.sql 22 Jul 2002 21:46:19 -0000 1.2 +++ openacs-4/packages/acs-events/sql/postgresql/oracle-compat-create.sql 21 Dec 2002 22:32:10 -0000 1.3 @@ -78,14 +78,14 @@ integer, varchar ) -returns timespan as ' +returns interval as ' declare interval__number alias for $1; interval__units alias for $2; begin -- We should probably do unit checking at some point - return ('''''''' || interval__number || '' '' || interval__units || '''''''')::timespan; + return ('''''''' || interval__number || '' '' || interval__units || '''''''')::interval; end;' language 'plpgsql';