Index: openacs-4/packages/cms/www/modules/items/status-edit-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/items/status-edit-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/cms/www/modules/items/status-edit-postgresql.xql 26 Sep 2002 02:28:39 -0000 1.3 +++ openacs-4/packages/cms/www/modules/items/status-edit-postgresql.xql 21 Dec 2002 22:29:31 -0000 1.4 @@ -40,7 +40,7 @@ select coalesce(publish_status, 'production') as publish_status, to_char(coalesce(start_when, current_timestamp), 'YYYY MM DD HH24 MI SS') as start_when, - to_char(coalesce(end_when, current_timestamp + 365), 'YYYY MM DD HH24 MI SS') as end_when + to_char(coalesce(end_when, current_timestamp + interval '365 days'), 'YYYY MM DD HH24 MI SS') as end_when from cr_items i left outer join cr_release_periods r using (item_id) where