Index: openacs-4/packages/evaluation-portlet/www/evaluation-assignments-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation-portlet/www/evaluation-assignments-portlet-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/evaluation-portlet/www/evaluation-assignments-portlet-postgresql.xql	30 Aug 2004 08:41:52 -0000	1.3
+++ openacs-4/packages/evaluation-portlet/www/evaluation-assignments-portlet-postgresql.xql	30 Aug 2004 09:04:20 -0000	1.4
@@ -10,8 +10,8 @@
 		eg.grade_id,
 		eg.grade_item_id
    	 	from evaluation_gradesx eg, acs_objects ao
-		where (select count(*) from cr_items
-	            where live_revision = eg.grade_id) > 0
+		where exists (select 1 from cr_items
+	            where live_revision = eg.grade_id) 
 	          and eg.item_id = ao.object_id	
    		  and ao.context_id in  ([join $list_of_package_ids ,])
 		order by grade_plural_name desc
Index: openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql	30 Aug 2004 08:41:53 -0000	1.5
+++ openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql	30 Aug 2004 09:04:20 -0000	1.6
@@ -10,8 +10,8 @@
 		eg.grade_id,
 		eg.grade_item_id
    	 	from evaluation_gradesx eg, acs_objects ao
-		where (select count(*) from cr_items
-	            where live_revision = eg.grade_id) > 0
+		where exists (select 1 from cr_items
+	            where live_revision = eg.grade_id) 
         	  and eg.item_id = ao.object_id
    		  and ao.context_id in  ([join $list_of_package_ids ,])
 		order by grade_plural_name desc