Index: openacs-4/packages/forums/www/forum-view-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/forum-view-postgresql.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/forums/www/forum-view-postgresql.xql	30 Nov 2002 17:35:39 -0000	1.6
+++ openacs-4/packages/forums/www/forum-view-postgresql.xql	21 Dec 2002 22:28:07 -0000	1.7
@@ -15,7 +15,7 @@
                     where fm1.forum_id = :forum_id
                     and fm1.tree_sortkey between tree_left(fm.tree_sortkey) and tree_right(fm.tree_sortkey)) as n_messages,
                    to_char(fm.last_child_post, 'YYYY-MM-DD HH24:MI:SS') as last_child_post_ansi,
-                   case when fm.last_child_post > (now() - 1) then 't' else 'f' end as new_p                   
+                   case when fm.last_child_post > (now() - interval '1 day') then 't' else 'f' end as new_p                   
             from forums_messages_approved fm
             where fm.forum_id = :forum_id
             and fm.parent_id is null
@@ -36,7 +36,7 @@
                     where fm1.forum_id = :forum_id
                     and fm1.tree_sortkey between tree_left(fm.tree_sortkey) and tree_right(fm.tree_sortkey)) as n_messages,
                    to_char(fm.last_child_post, 'YYYY-MM-DD HH24:MI:SS') as last_child_post_ansi,
-                   case when fm.last_child_post > (now() - 1) then 't' else 'f' end as new_p                   
+                   case when fm.last_child_post > (now() - interval '1 day') then 't' else 'f' end as new_p                   
             from forums_messages_approved fm
             where fm.forum_id = :forum_id
             and fm.parent_id is null