trigger compile problem

Поиск
Список
Период
Сортировка
Искать
От
T.R.Missner@Level3.com
Тема
trigger compile problem
Дата
Msg-id
EBFCF3982143D511A77F0008C716807E0106DB2C@N0400IDC1.oss.level3.com
Список
Дерево обсуждения
Re: trigger compile problem T.R.Missner@Level3.com
Can anyone out there help me.
I have created a trigger and can't get it to run.
When it is invoked I get a compile error no matter what.
.I have changed the code in the trigger many times and it really doesn't 
matter what the code actually does it still won't compile.
I have stripped it down so all it does is return NEW and still the problem.

here is the error 

ERROR: parse error at or near ""

here is the code

CREATE FUNCTION "AANEW" () RETURNS opaque AS '
DECLARE myrec sipmsg_lu%ROWTYPE;
BEGIN
 SELECT INTO myrec * FROM sipmsg_lu WHERE callid=''NEW.callid'';
 IF NOT FOUND THEN 
  INSERT INTO sipmsg_lu VALUES (NEW.time , ''NEW.callid'');
 END IF; 
RETURN NEW;
END' LANGUAGE 'plpgsql';

any help would be great.

red hat 2.2 kernal
pgsql 7.1.3

t.r.  missner
В списке pgsql-general по дате отправления
От: Jan Wieck
Дата:
Сообщение: Re: Functions
От: Doug McNaught
Дата:
Сообщение: Re: trigger compile problem
FAQ