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 -r1.6 -r1.7 --- openacs-4/packages/acs-events/sql/postgresql/oracle-compat-create.sql 7 Aug 2017 23:47:56 -0000 1.6 +++ openacs-4/packages/acs-events/sql/postgresql/oracle-compat-create.sql 31 Mar 2018 11:29:28 -0000 1.7 @@ -40,21 +40,21 @@ when 'SUNDAY' then 1 when 'SUN' then 1 when 'MONDAY' then 2 - when 'MON' then 2 - when 'TUESDAY' then 3 - when 'TUES' then 3 - when 'TUE' then 3 + when 'MON' then 2 + when 'TUESDAY' then 3 + when 'TUES' then 3 + when 'TUE' then 3 when 'WEDNESDAY' then 4 - when 'WED' then 4 - when 'WEDS' then 4 + when 'WED' then 4 + when 'WEDS' then 4 when 'THURSDAY' then 5 - when 'THURS' then 5 - when 'THUR' then 5 - when 'THU' then 5 - when 'FRIDAY' then 6 - when 'FRI' then 6 - when 'SATURDAY' then 7 - when 'SAT' then 7 + when 'THURS' then 5 + when 'THUR' then 5 + when 'THU' then 5 + when 'FRIDAY' then 6 + when 'FRI' then 6 + when 'SATURDAY' then 7 + when 'SAT' then 7 else -1 end) into v_dow from dual;