Index: openacs-4/packages/news/tcl/news-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/tcl/news-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/news/tcl/news-procs-postgresql.xql	15 Oct 2001 13:41:03 -0000	1.1
+++ openacs-4/packages/news/tcl/news-procs-postgresql.xql	25 Oct 2001 11:39:29 -0000	1.2
@@ -32,5 +32,16 @@
       </querytext>
 </fullquery>
 
+
+<fullquery name="news_util_get_url.get_url_stub">
+      <querytext>
+
+	  select site_node__url(node_id) as url_stub
+          from site_nodes
+          where object_id=:package_id      
+	
+      </querytext>
+</fullquery>
+
  
 </queryset>