Index: openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql,v
diff -u -r1.14 -r1.15
--- openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql	24 Oct 2006 13:18:04 -0000	1.14
+++ openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql	14 Nov 2006 16:11:10 -0000	1.15
@@ -446,4 +446,35 @@
     </querytext>
 </fullquery>
 
+<fullquery name="pm::project::search.get_projects">
+    <querytext>
+	select 
+		i.item_id
+	from
+		cr_items i, cr_revisions r, pm_projects p
+	where
+		lower(r.title) like '%${keyword}%'
+		and i.latest_revision = r.revision_id
+		and r.revision_id = p.project_id
+	order by
+		r.title asc
+    </querytext>
+</fullquery>
+
+<fullquery name="pm::project::search.get_projects_by_code">
+    <querytext>
+	select 
+		item_id,
+		o.package_id as object_package_id
+	from
+		cr_items i, acs_objects o, pm_projects p
+	where
+		lower(p.project_code) like '%${keyword}%'
+		and i.latest_revision = o.object_id
+		and o.object_id = p.project_id
+	order by
+		title asc
+    </querytext>
+</fullquery>
+
 </queryset>