Index: openacs-4/packages/dotlrn/sql/postgresql/communities-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/communities-package-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/dotlrn/sql/postgresql/communities-package-create.sql	12 Jul 2002 21:26:48 -0000	1.3
+++ openacs-4/packages/dotlrn/sql/postgresql/communities-package-create.sql	15 Jul 2002 18:32:24 -0000	1.4
@@ -307,7 +307,7 @@
 DECLARE
         p_community_id                    alias for $1;
         p_party_id                        alias for $2;
-        v_rv				  char(1);
+        r_rv				  char(1);
 BEGIN
 	-- THIS NEEDS TO BE CHECKED!
 	-- chak, 2002-07-01
@@ -336,7 +336,7 @@
         where dotlrn_communities_all.community_id = p_community_id
         and site_nodes.object_id = dotlrn_communities_all.package_id;
 
-	return v_node_id;
+	return site_node__url(v_node_id);
 
 --        exception
 --            when no_data_found then
@@ -349,7 +349,7 @@
 returns varchar as '
 DECLARE
 	p_community_id		alias for $1;
-	v_rv char(1);
+	r_rv char(1);
 BEGIN
 	select CASE
 		WHEN count(*) = 0