Zeoslib Portal

I have used the script bellow CREATE OR REPLACE FUNCTION ano_mes_b_ins_upd_f() RETURNS "trigger" AS BEGIN IF NEW.mes is not null THEN IF (NEW.mes<1) or (NEW.MES> 12) THEN raise exception 'O campo mês deve ser um vlr valido(entre 1 e 12)' END IF END IF END And Setting ZSQLProcessor1.Delimit...

I have used like bellow: CREATE OR REPLACE FUNCTION ano_mes_b_ins_upd_f() RETURNS "trigger" AS BEGIN IF NEW.mes is not null THEN IF (NEW.mes<1) or (NEW.MES> 12) THEN raise exception 'O campo mes deve ser um valor valido(entre 1 e 12)'; END IF; END IF; END; but the error continue

I am new user of Postgresql and ZeosLib. The problem is that Im trying to change DDL of my database using Zsqlprocessor Actually, trying to create the function bellow. CREATE OR REPLACE FUNCTION ano_mes_b_ins_f() RETURNS "trigger" AS $BODY$ BEGIN IF NEW.mes is not null THEN IF (NEW.mes<1) ...

I am new user of Postgresql and ZeosLib. The problem is that Im trying to change DDL of my database using Zsqlprocessor Actually, trying to create the function bellow. CREATE OR REPLACE FUNCTION ano_mes_b_ins_f() RETURNS "trigger" AS $BODY$ BEGIN IF NEW.mes is not null THEN IF (NEW.mes<1) ...