Index: openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-one-postgresql.xql,v diff -u -r1.16.2.2 -r1.16.2.3 --- openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql 4 Feb 2004 20:17:19 -0000 1.16.2.2 +++ openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql 6 Mar 2004 00:29:24 -0000 1.16.2.3 @@ -1,28 +1,5 @@ - - - SELECT - t.item_id - FROM - pm_tasks_revisionsx t - WHERE - t.revision_id = :task_revision_id - - - - - - SELECT - t.revision_id as task_revision_id - FROM - pm_tasks_revisionsx t, cr_items i - WHERE - t.item_id = :task_id and - i.live_revision = t.revision_id - - - SELECT @@ -119,7 +96,7 @@ i.live_revision, d.parent_task_id, d.dependency_type, - d.task_id + d.task_id as d_task_id FROM pm_tasks_revisionsx t, cr_items i, pm_task_dependency d WHERE