Index: openacs-4/packages/assessment/lib/session-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/session-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/assessment/lib/session-postgresql.xql	21 Nov 2006 15:13:30 -0000	1.3
+++ openacs-4/packages/assessment/lib/session-postgresql.xql	2 Sep 2008 17:39:57 -0000	1.4
@@ -22,7 +22,8 @@
         and s.assessment_id in (select revision_id from cr_revisions where item_id= :assessment_id)
 	and o.object_id = cr.item_id
         and s.session_id = cr.revision_id
-	group by assessment_id, subject_id, session_id
+	group by assessment_id, subject_id, session_id, o.creation_date
+	order by o.creation_date desc
 	limit 1
     </querytext>
 </fullquery>