Index: openacs-4/packages/project-manager/sql/postgresql/project-manager-functions-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/sql/postgresql/project-manager-functions-create.sql,v diff -u -r1.8 -r1.9 --- openacs-4/packages/project-manager/sql/postgresql/project-manager-functions-create.sql 25 Jun 2005 13:45:24 -0000 1.8 +++ openacs-4/packages/project-manager/sql/postgresql/project-manager-functions-create.sql 19 Jul 2005 06:26:55 -0000 1.9 @@ -13,22 +13,6 @@ -- can be identified. Now we have to build that function. In this case, -- we'll return a field called title as the name. -select define_function_args('pm_project__name', 'project_id'); - -create or replace function pm_project__name (integer) -returns varchar as ' -declare - p_pm_project_id alias for $1; - v_pm_project_name pm_projectsx.name%TYPE; -begin - select name || ''_'' || p_pm_project_id into v_pm_project_name - from pm_projectsx - where item_id = p_pm_project_id; - return v_pm_project_name; -end; -' language 'plpgsql'; - - -- Create a new root folder select define_function_args('pm_project__new_root_folder', 'package_id');