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.5 -r1.6
--- openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql	22 May 2007 09:42:08 -0000	1.5
+++ openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql	14 Jun 2007 06:46:41 -0000	1.6
@@ -27,7 +27,7 @@
                    $replies as n_messages,
                    to_char(fm.last_child_post, 'YYYY-MM-DD HH24:MI:SS') as last_child_post_ansi,
 	           u.screen_name,
-		   $unread_or_new_query                   
+		   $unread_or_new_query_clause                   
             from   forums_messages_approved fm $unread_join,
 		   users u
             where fm.forum_id = :forum_id
@@ -49,4 +49,10 @@
         </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>
+
+
+
 </queryset>