PostgreSQL TO-DO List (fwd)
От | Bruce Momjian |
---|---|
Тема | PostgreSQL TO-DO List (fwd) |
Дата | |
Msg-id | 200203040255.g242tto08892@candle.pha.pa.us обсуждение исходный текст |
Ответы |
Re: PostgreSQL TO-DO List (fwd)
Re: PostgreSQL TO-DO List (fwd) |
Список | pgsql-docs |
Can someone comment on this? I don't understand it. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 Hi! Bruce, Many thanks to your great contributions to Pgsql projects. I cannot find the following to-fix bug in section "SERVER-SIDE LANGUAGES" in "PostgreSQL TO-DO List". Please also refer to: "Example 23-4. A PL/pgSQL Function on Composite Type" in integrated on-line document. Best Regards, CN ========================= create table test(f1 integer,f2 integer); CREATE FUNCTION fun1(test) RETURNS BOOLEAN AS ' DECLARE f1 FOR $1.f1; f2 FOR $1.f2; integer sum; BEGIN sum:=f1+f2; raise notice ''f1+f2'',sum; RETURN TRUE; END;' LANGUAGE 'plpgsql'; ----------------------- CREATE FUNCTION fun2() RETURNS OPAQUE AS ' BEGIN PERFORM fun1(NEW); RETURN NEW; END;' LANGUAGE 'plpgsql'; CREATE TRIGGER ttest AFTER INSERT ON test FOR EACH ROW EXECUTE PROCEDURE fun2(); insert into test values(1,2); NOTICE: Error occurred while executing PL/pgSQL function fun2 NOTICE: line 2 at assignment ERROR: NEW used in non-rule query -------------------------------------------------------- You too can have your own email address from Eurosport. http://www.eurosport.com
В списке pgsql-docs по дате отправления: