Author: danydb Date: 2011-12-19 11:03:59 +0100 (Mon, 19 Dec 2011) New Revision: 4627
Modified: phpcompta/trunk/sql/upgrade.sql Log: Update jrnx: remove comment if it is the comment in jrn table Modified: phpcompta/trunk/sql/upgrade.sql =================================================================== --- phpcompta/trunk/sql/upgrade.sql 2011-12-19 09:55:42 UTC (rev 4626) +++ phpcompta/trunk/sql/upgrade.sql 2011-12-19 10:03:59 UTC (rev 4627) @@ -1,28 +1 @@ -CREATE OR REPLACE FUNCTION comptaproc.get_menu_dependency(profile_menu_id int) - RETURNS SETOF int AS -$BODY$ -declare - i int; - x int; - e int; -begin - for x in select pm_id,me_code - from profile_menu - where me_code_dep in (select me_code from profile_menu where pm_id=profile_menu_id) - and p_id = (select p_id from profile_menu where pm_id=profile_menu_id) - loop - return next x; - - for e in select * from comptaproc.get_menu_dependency_pm(x) - loop - return next e; - end loop; - - end loop; - return; -end; -$BODY$ -LANGUAGE plpgsql; - -delete from profile_menu where p_id=2 and me_code_dep='DIVPARM'; -delete from profile_menu where p_id=2 and me_code_dep='MOD'; +update jrnx set j_text = null from jrn where jr_grpt_id=j_grpt and j_text=jr_comment; _______________________________________________ Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
