[Noalyss-commit] [noalyss] 04/12: upgrade102 Adapt for postgres 9.0

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit d6464a1e8df80da7c2be2005602a6cf9501ce56a
Author: Dany De Bontridder <address@hidden>
Date:   Thu Mar 15 10:17:44 2018 +0100

    upgrade102 Adapt for postgres 9.0
---
 include/sql/patch/upgrade102.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

diff --git a/include/sql/patch/upgrade102.sql b/include/sql/patch/upgrade102.sql
index 9319d51..1271508 100644
--- a/include/sql/patch/upgrade102.sql
+++ b/include/sql/patch/upgrade102.sql
@@ -1,7 +1,7 @@
 begin;
 CREATE OR REPLACE FUNCTION comptaproc.check_balance(p_grpt integer)
   RETURNS numeric AS
-$BODY$
+$_$
 declare
        amount_jrnx_debit numeric;
        amount_jrnx_credit numeric;
@@ -34,8 +34,8 @@ begin
                end if;
        return 0;
 end;
-$BODY$
-  LANGUAGE plpgsql;
+$_$
+LANGUAGE plpgsql;
 
 update op_predef set od_direct='t' where od_jrn_type='ODS';
 
@@ -150,7 +150,7 @@ CREATE INDEX link_action_type_fki
 -- Trigger: trg_action_gestion_related on action_gestion_related
 CREATE OR REPLACE FUNCTION comptaproc.action_gestion_related_ins_up()
   RETURNS trigger AS
-$BODY$
+$_$
 declare
        nTmp bigint;
 begin
@@ -168,8 +168,8 @@ end if;
 return NEW;
 
 end;
-$BODY$
-  LANGUAGE plpgsql ;
+$_$
+  LANGUAGE plpgsql;
 -- DROP TRIGGER trg_action_gestion_related ON action_gestion_related;
 
 CREATE TRIGGER trg_action_gestion_related