Index: openacs-4/packages/acs-tcl/tcl/apm-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/apm-procs-postgresql.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/acs-tcl/tcl/apm-procs-postgresql.xql	29 May 2001 01:46:29 -0000	1.6
+++ openacs-4/packages/acs-tcl/tcl/apm-procs-postgresql.xql	28 Nov 2001 04:59:51 -0000	1.7
@@ -138,4 +138,15 @@
       </querytext>
 </fullquery>
 
+
+<fullquery name="apm_package_url_from_key_mem.apm_package_url_from_key">      
+      <querytext>
+      
+	select site_node__url(node_id) 
+          from site_nodes 
+         where object_id = :package_id
+    
+      </querytext>
+</fullquery>
+
 </queryset>