Index: openacs-4/contrib/packages/project-manager/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/index-postgresql.xql,v
diff -u -r1.8.2.6 -r1.8.2.7
--- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	5 Feb 2004 23:57:49 -0000	1.8.2.6
+++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	27 Feb 2004 22:46:13 -0000	1.8.2.7
@@ -1,8 +1,8 @@
 <?xml version="1.0"?>
 <queryset>
-<rdbms><type>postgresql</type><version>7.2</version></rdbms>
+  <rdbms><type>postgresql</type><version>7.3</version></rdbms>
 
-<fullquery name="project_folders">
+  <fullquery name="project_folders">
     <querytext>
         SELECT
         p.item_id as project_item_id,
@@ -23,10 +23,13 @@
         to_char(p.estimated_finish_date, 'MM/DD/YY') as estimated_finish_date,
         to_char(p.earliest_finish_date, 'MM/DD/YY') as earliest_finish_date,
         to_char(p.latest_finish_date, 'MM/DD/YY') as latest_finish_date,
-        case when o.name is null then '--no customer--' else o.name end as customer_name,
-        o.organization_id
+        case when o.name is null then '--no customer--' else o.name
+                end as customer_name,
+        case when f.name is null then '--no facility--' else f.name end as facility_name,
+        o.organization_id as customer_id
         FROM pm_projectsx p 
-             LEFT JOIN organizations o ON p.customer_id = o.organization_id 
+             LEFT JOIN organizations o ON p.customer_id =
+                o.organization_id 
              LEFT JOIN (
                         select 
                         om.category_id,