Index: openacs-4/packages/static-pages/www/admin/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/www/admin/index-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/static-pages/www/admin/index-postgresql.xql	27 Jul 2001 15:43:31 -0000	1.1
+++ openacs-4/packages/static-pages/www/admin/index-postgresql.xql	8 Dec 2001 01:18:00 -0000	1.2
@@ -4,13 +4,11 @@
 <fullquery name="count_static_pages">      
       <querytext>
       
-    select count(*) as n_static_pages from static_pages
-    where folder_id in (
-	select folder_id from sp_folders 
-		where tree_sortkey like ( select tree_sortkey || '%'
-		from sp_folders
-		where folder_id = :root_folder_id)
-    )
+    select count(*) as n_static_pages
+    from static_pages sp, sp_folders s1, sp_folders s2
+    where sp.folder_id = s1.folder_id
+      and s2.folder_id = :root_folder_id
+      and s1.tree_sortkey between s2.tree_sortkey and tree_right(s2.tree_sortkey)
 
       </querytext>
 </fullquery>