Index: openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql 29 Oct 2002 01:51:42 -0000 1.1.2.1 +++ openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql 21 Jan 2003 13:45:54 -0000 1.1.2.2 @@ -64,13 +64,13 @@ 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';