Index: openacs.org-dev/packages/acs-events/sql/postgresql/oracle-compat-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/acs-events/sql/postgresql/oracle-compat-create.sql,v diff -u -r1.1.1.1 -r1.1.1.2 --- openacs.org-dev/packages/acs-events/sql/postgresql/oracle-compat-create.sql 9 Jul 2002 17:34:58 -0000 1.1.1.1 +++ openacs.org-dev/packages/acs-events/sql/postgresql/oracle-compat-create.sql 25 Jul 2002 18:46:46 -0000 1.1.1.2 @@ -78,14 +78,14 @@ integer, varchar ) -returns interval as ' +returns timespan 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 || '''''''' || ''::interval''; + return ('''''''' || interval__number || '' '' || interval__units || '''''''')::timespan; end;' language 'plpgsql';