Index: openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/tasks-postgresql.xql,v diff -u -r1.4 -r1.5 --- openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql 26 Feb 2004 15:28:34 -0000 1.4 +++ openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql 12 Mar 2004 13:44:45 -0000 1.5 @@ -19,7 +19,8 @@ t.estimated_hours_work, t.estimated_hours_work_min, t.estimated_hours_work_max, - t.actual_hours_worked, + case when t.actual_hours_worked is null then 0 + else t.actual_hours_worked end as actual_hours_worked, to_char(t.earliest_start,'YYYY-MM-DD HH24:MI') as earliest_start, to_char(t.earliest_finish,'YYYY-MM-DD HH24:MI') as earliest_finish, to_char(t.latest_start,'YYYY-MM-DD HH24:MI') as latest_start,