Index: openacs-4/packages/acs-subsite/www/admin/applications/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/applications/index-postgresql.xql,v diff -u -N -r1.4 -r1.4.2.1 --- openacs-4/packages/acs-subsite/www/admin/applications/index-postgresql.xql 21 Oct 2018 17:36:23 -0000 1.4 +++ openacs-4/packages/acs-subsite/www/admin/applications/index-postgresql.xql 5 Oct 2022 13:42:56 -0000 1.4.2.1 @@ -3,7 +3,7 @@ postgresql7.1 - + select node_id from ( WITH RECURSIVE site_node_tree AS ( @@ -28,14 +28,14 @@ - + select node_id, name, package_id, instance_name, package_pretty_name, parameters_p, (char_length(url)-char_length(replace(url, '/', ''))-1) as treelevel from ( - select n.node_id, - n.name, + select n.node_id, + n.name, p.package_id, p.instance_name, site_node__url(n.node_id) as url, @@ -49,5 +49,5 @@ - +