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.1.2.5 -r1.1.2.6 --- openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql 5 Feb 2004 23:57:49 -0000 1.1.2.5 +++ openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql 6 Mar 2004 00:29:24 -0000 1.1.2.6 @@ -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,