Index: openacs-4/contrib/packages/project-manager/www/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/one-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	4 Aug 2003 23:44:51 -0000	1.4
+++ openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	7 Aug 2003 23:08:45 -0000	1.5
@@ -75,11 +75,13 @@
 	SELECT
         t.item_id,
         t.title,
-	to_char(t.start_date,'MM/DD/YYYY') as start_date,
-	to_char(t.end_date,'MM/DD/YYYY') as end_date,
-        percent_complete
+	to_char(t.start_date,'MM/DD/YY') as start_date,
+	to_char(t.end_date,'MM/DD/YY') as end_date,
+        t.percent_complete,
+        c.parent_task_id,
+        c.const_type
 	FROM
-	pm_tasks_revisionsx t, cr_items i
+	pm_tasks_revisionsx t, cr_items i LEFT JOIN pm_task_constraints c ON i.item_id = c.task_id
 	WHERE
         t.parent_id = :item_id and
         t.revision_id = i.live_revision