Problem with PL/pgSQL in 7.03

From: "Dmitry Chernikov" <cher(at)beltel(dot)ru>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Problem with PL/pgSQL in 7.03
Date: 2001-01-25 16:44:27
Message-ID: 004201c086f0$c6be30c0$6901a8c0@cherhome
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)beltel(dot)ru

Browse pgsql-general by date

  From Date Subject
Next Message Peter T Mount 2001-01-25 17:15:48 Re: Connection pooling
Previous Message Aggarwal , Ajay 2001-01-25 16:19:03 2 or more columns of type 'serial' in a table