Index: openacs-4/packages/workflow/www/admin/workflow-clone-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/www/admin/workflow-clone-postgresql.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/workflow/www/admin/workflow-clone-postgresql.xql	4 Jan 2007 09:04:10 -0000	1.2
@@ -0,0 +1,17 @@
+<?xml version="1.0"?>
+ <queryset>
+   <rdbms><type>postgresql</type><version>7.2</version></rdbms>
+ 	 
+         <fullquery name="get_packages">
+ 	         <querytext>
+ 	                 select n.name,
+ 	                 n.object_id,
+ 	                 n.name as rawname,
+ 	                 tree_level(n2.tree_sortkey) as level
+ 	                 from site_nodes n, site_nodes n2
+ 	                 where n.name is not null
+ 	                 and n.tree_sortkey between n2.tree_sortkey and tree_right(n2.tree_sortkey)
+ 	                 and n.object_id in (select s.object_id from site_nodes s where s.parent_id is null)
+ 	         </querytext>
+         </fullquery>
+ </queryset>