Index: openacs-4/packages/forums/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/index-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/forums/www/index-postgresql.xql	21 Dec 2002 22:28:07 -0000	1.5
+++ openacs-4/packages/forums/www/index-postgresql.xql	16 Jan 2003 13:49:30 -0000	1.6
@@ -9,7 +9,7 @@
                    (select count(*)
                     from forums_messages
                     where forums_messages.forum_id = forums_forums_enabled.forum_id
-                    and 1 = tree_level(forums_messages.tree_sortkey)) as n_threads,
+                    and parent_id is null) as n_threads,
                    to_char(last_post, 'YYYY-MM-DD HH24:MI:SS') as last_post_ansi,
                    case when last_post > (now() - interval '1 day') then 't' else 'f' end as new_p
             from forums_forums_enabled