Index: openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/project-manager-procs-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql	11 Jun 2004 21:11:53 -0000	1.1
@@ -0,0 +1,49 @@
+<?xml version="1.0"?>
+<!--  -->
+<!-- @author Jade Rubick (jader@bread.com) -->
+<!-- @creation-date 2004-06-11 -->
+<!-- @arch-tag: 9a0aca80-2974-4b08-a211-25482d8419b5 -->
+<!-- @cvs-id $Id: project-manager-procs-postgresql.xql,v 1.1 2004/06/11 21:11:53 jader Exp $ -->
+
+<queryset>
+  
+  <rdbms>
+    <type>postgresql</type>
+    <version>7.3</version>
+  </rdbms>
+  
+  <fullquery name="pm::util::category_selects_helper.get_categories">
+    <querytext>
+    select 
+    t.name as cat_name, 
+    t.category_id as cat_id, 
+    tm.tree_id 
+    from 
+    category_tree_map tm, 
+    categories c, 
+    category_translations t 
+    where 
+    c.tree_id      = tm.tree_id and 
+    c.category_id  = t.category_id and 
+    tm.object_id   = :package_id and
+    c.deprecated_p = 'f'
+    order 
+    by t.name
+    </querytext>
+  </fullquery>
+
+  <fullquery name="pm::util::category_selects_helper.get_category_trees">
+    <querytext>
+    select 
+    tt.name as tree_name, 
+    tt.tree_id 
+    from 
+    category_tree_map tm, 
+    category_tree_translations tt 
+    where 
+    tm.object_id = :package_id and 
+    tm.tree_id = tt.tree_id
+    </querytext>
+  </fullquery>
+  
+</queryset>