[Phpcompta-dev] r5452 - phpcompta/trunk/sql

[phpcompta-dev]

Author: danydb
Date: 2013-10-01 17:18:09 +0200 (Tue, 01 Oct 2013)
New Revision: 5452

Modified:
   phpcompta/trunk/sql/upgrade.sql
Log:
Add limit op_predef.od_description

Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql     2013-10-01 14:12:44 UTC (rev 5451)
+++ phpcompta/trunk/sql/upgrade.sql     2013-10-01 15:18:09 UTC (rev 5452)
@@ -261,3 +261,18 @@
 $BODY$
   LANGUAGE plpgsql VOLATILE
 
+create or replace function comptaproc.opd_limit_description() 
+returns trigger
+as
+$BEGIN$
+       declare
+               sDescription text;
+       begin
+       sDescription := NEW.od_description;
+       NEW.od_description := substr(sDescription,1,80);
+       return NEW;
+       end;
+$BEGIN$
+LANGUAGE plpgsql;
+
+create trigger opd_limit_description before update or insert on op_predef 
execute procedure for each row comptaproc.opd_limit_description();



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu