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.11 -r1.12
--- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	26 Feb 2004 15:15:41 -0000	1.11
+++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	12 Mar 2004 13:44:44 -0000	1.12
@@ -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,12 @@
         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,
+        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,