Index: openacs-4/packages/calendar/sql/postgresql/cal-item-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/postgresql/cal-item-create.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/calendar/sql/postgresql/cal-item-create.sql	17 May 2003 10:20:23 -0000	1.11
+++ openacs-4/packages/calendar/sql/postgresql/cal-item-create.sql	1 Feb 2004 16:51:07 -0000	1.12
@@ -208,55 +208,3 @@
     return 0;
 
 end;' LANGUAGE 'plpgsql';
-
-
--------------------------------------------------------------
--- the name function
--------------------------------------------------------------
-
-    -- function to return the name of the cal_item
-CREATE FUNCTION cal_item__name (
-    integer
-)
-RETURNS varchar AS '
-declare 
-    name__cal_item_id	alias for $1;
-    v_name	acs_activities.name%TYPE;
-begin
-    select  name 
-    into    v_name
-    from    acs_activities
-    where   activity_id = 
-    (
-	select  activity_id
-        from    acs_events
-        where   event_id = name__cal_item_id
-    );
-               
-    return v_name;
-
-end;' LANGUAGE 'plpgsql';
-
-
----------------------------------------------------------------
--- the on_which_calendar function
----------------------------------------------------------------
-
-    -- function to return the calendar that owns the cal_item
-CREATE FUNCTION cal_item__on_which_calendar (
-    integer
-)
-RETURNS integer AS '
-declare
-    on_which_calendar__cal_item_id	alias for $1;
-    v_calendar_id			calendars.calendar_id%TYPE;
-begin
-    select  on_which_calendar
-    into    v_calendar_id
-    from    cal_items
-    where   cal_item_id = on_which_calendar__cal_item_id;
-        
-    return  v_calendar_id;
-
-end;' LANGUAGE 'plpgsql';
-