Index: openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-packages.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-packages.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-packages.sql	9 Mar 2002 02:00:02 -0000	1.7
+++ openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-packages.sql	13 Mar 2002 22:50:53 -0000	1.8
@@ -274,21 +274,19 @@
 end;
 ' language 'plpgsql';
 
-
 create function bboard_category__name (integer)
 returns varchar as '
 declare
-    category_id      alias for $1;
-    v_category_name   varchar;
+   p_category_id     alias for $1;
+   v_category_name   varchar;
 begin
-    select short_name into v_category_name
-        from bboard_categories
-	    where category_id = name.category_id;
-    return v_category_name;
+   select short_name into v_category_name
+       from bboard_categories
+       where category_id = p_category_id;
+   return v_category_name;
 end;
 ' language 'plpgsql';
 
-
 --------------- bboard_message package ----------------
 
 create function bboard_message__new (integer, integer, timestamp, integer,