Index: openacs-4/packages/evaluation-portlet/lib/evaluations-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation-portlet/lib/evaluations-chunk-postgresql.xql,v
diff -u -r1.5.2.2 -r1.5.2.3
--- openacs-4/packages/evaluation-portlet/lib/evaluations-chunk-postgresql.xql	8 Jun 2005 22:23:37 -0000	1.5.2.2
+++ openacs-4/packages/evaluation-portlet/lib/evaluations-chunk-postgresql.xql	24 Aug 2005 15:11:36 -0000	1.5.2.3
@@ -8,7 +8,8 @@
 
 	select et.task_name, 
 	round(et.weight,2) as task_weight,
-        et.task_id, (select perfect_score from evaluation_tasks where task_id=et.task_id) as perfect_score, online_p
+        et.task_id, 
+        coalesce(et.perfect_score,0) as perfect_score, online_p
 	from evaluation_tasksi et, cr_items cri
 	where grade_item_id = :grade_item_id
 	  and cri.live_revision = et.task_id
@@ -40,7 +41,8 @@
 	et.online_p,
 	et.due_date,
 	et.late_submit_p,
-        et.task_id, (select perfect_score from evaluation_tasks where task_id=et.task_id) as perfect_score
+        et.task_id, 
+	coalesce(et.perfect_score,0) as perfect_score
 	from evaluation_grades eg,
 	evaluation_tasksi et,
 	cr_items cri