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.4.2.2 -r1.4.2.3 --- openacs-4/packages/forums/www/forum-view-postgresql.xql 21 Jan 2003 13:51:14 -0000 1.4.2.2 +++ openacs-4/packages/forums/www/forum-view-postgresql.xql 16 May 2003 09:17:46 -0000 1.4.2.3 @@ -36,7 +36,6 @@ 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, 'Mon DD YYYY HH24:MI:SS') as last_child_post, - 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