Thread: Problem with PL/pgSQL in 7.03

Problem with PL/pgSQL in 7.03

From
"Dmitry Chernikov"
Date:
Hi
I migrated from version 6.5 to 7.03
My function (see below) doesn't work in 7.03, but it works in 6.5 .
 
CREATE FUNCTION "projects_update_function" ( ) RETURNS opaque AS '
 begin
   if TG_OP=''UPDATE'' then
     NEW."Last Modify":=''now'';
     return NEW;
   end if;
 end;
' LANGUAGE 'plpgsql';
 
CREATE TRIGGER "Projects_Update" BEFORE UPDATE ON "Projects" 
        FOR EACH ROW EXECUTE PROCEDURE "projects_гpdate_function" ();
 
 
NOTICE:  plpgsql: ERROR during compile of projects_update_function near line 2
ERROR:  unterminated "
 
Dmitry Chernikov  cher@beltel.ru