Index: openacs-4/packages/assessment/www/session-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/session-postgresql.xql,v
diff -u -N -r1.1 -r1.1.8.1
--- openacs-4/packages/assessment/www/session-postgresql.xql	21 Feb 2005 14:32:56 -0000	1.1
+++ openacs-4/packages/assessment/www/session-postgresql.xql	8 Oct 2008 15:45:22 -0000	1.1.8.1
@@ -12,4 +12,19 @@
       </querytext>
 </fullquery>
 
+  <fullquery name="get_latest_session">
+    <querytext>
+      select max(o.creation_date), s.session_id 
+        from as_sessions s, 
+        acs_objects o,
+        cr_revisions cr
+      where s.subject_id=:user_id
+        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
+      limit 1
+    </querytext>
+  </fullquery>
+
 </queryset>