Index: openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql	28 Nov 2001 18:39:39 -0000	1.3
+++ openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql	7 Dec 2001 22:46:40 -0000	1.4
@@ -68,5 +68,15 @@
       </querytext>
 </fullquery>
 
+<fullquery name="children_count">      
+      <querytext>
+      
+	select count(*) as num_children
+	from acs_objects o
+	where context_id = :object_id and
+            acs_permission__permission_p(o.object_id, :user_id, 'admin') = 't'
+
+      </querytext>
+</fullquery>
  
 </queryset>