Index: openacs-4/contrib/packages/project-manager/www/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/index-postgresql.xql,v diff -u -r1.8.2.5 -r1.8.2.6 --- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql 4 Feb 2004 20:17:19 -0000 1.8.2.5 +++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql 5 Feb 2004 23:57:49 -0000 1.8.2.6 @@ -16,6 +16,8 @@ p.ongoing_p, c.category_id, c.category_name, + p.earliest_finish_date - current_date as days_to_earliest_finish, + p.latest_finish_date - current_date as days_to_latest_finish, p.actual_hours_completed, p.estimated_hours_total, to_char(p.estimated_finish_date, 'MM/DD/YY') as estimated_finish_date,