Index: openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql,v
diff -u -N -r1.12 -r1.13
--- openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql	26 May 2006 15:52:15 -0000	1.12
+++ openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql	5 Jun 2006 11:57:30 -0000	1.13
@@ -402,6 +402,17 @@
     </querytext>
   </fullquery>
 
+   <fullquery name="pm::project::subprojects.subprojects">
+         <querytext>
+
+	    select i.item_id as project_item_id
+	    from cr_items i, pm_projects p
+	    where p.project_id = i.latest_revision
+	    and i.parent_id in ([join $project_list ,])
+
+         </querytext>
+   </fullquery>
+
 <fullquery name="pm::project::get_all_subprojects_not_cached.get_subprojects">
     <querytext>
 	select