Index: openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/message/Attic/threads-chunk-postgresql.xql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql	14 Jun 2007 06:46:41 -0000	1.6
+++ openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql	15 Jun 2007 18:58:54 -0000	1.7
@@ -49,10 +49,25 @@
         </querytext>
     </partialquery>
 
-    <partialquery name="unread_or_new_query">
-	case when fm.last_child_post > (now() - interval '1 day') then 't' else 'f' end as unread_p
+    <partialquery name="unread_query">
+        <querytext>
+	case when fi.reading_date is null then 't' else 'f' end as unread_p
+        </querytext>
     </partialquery>
 
+    <partialquery name="unread_join">
+        <querytext>
+	left join forums_reading_info fi on fm.message_id=fi.root_message_id and fi.user_id = :user_id
+        </querytext>
+    </partialquery>
 
+    <partialquery name="new_query">
+        <querytext>
+	case when fm.last_child_post > (now() - interval '1 day') then 't' else 'f' end as new_p
+        </querytext>
+    </partialquery>
 
+
+
+
 </queryset>