Index: openacs-4/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/www/Attic/index-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/www/index-postgresql.xql	30 Jan 2003 22:51:28 -0000	1.2
+++ openacs-4/www/index-postgresql.xql	7 Apr 2003 12:16:41 -0000	1.3
@@ -7,14 +7,17 @@
 
   <fullquery name="site_nodes">
     <querytext>
-  select site_node__url(node_id) as url, acs_object__name(object_id) as name
-      from site_nodes
+  select site_node__url(node_id) as url, acs_object__name(object_id) as name,
+         apm_package_types.initial_install_p  
+      from site_nodes, apm_packages, apm_package_types
       where parent_id = site_node__node_id('/',NULL)
       and object_id is not null
       and acs_permission__permission_p(
           object_id, 
           coalesce(:user_id, acs__magic_object_id('the_public')), 
           'read') = 't'
+      and apm_packages.package_id = site_nodes.object_id
+      and apm_package_types.package_key = apm_packages.package_key
     </querytext>
   </fullquery>