PL/SQL question
| От | Froggy / Froggy Corp. |
|---|---|
| Тема | PL/SQL question |
| Дата | |
| Msg-id | 40857F26.D724C7E0@froggycorp.com обсуждение исходный текст |
| Ответы |
Re: PL/SQL question
|
| Список | pgsql-general |
Hello everyone,
I try to see if i can make a recursive function with a trigger set on
INSERT and doing an insert under my trigger function.
So i wrote a test function :
CREATE OR REPLACE FUNCTION testfunc() RETURNS SETOF RECORD AS '
DECLARE
use_t RECORD;
BEGIN
SELECT INTO use_t id_categorie FROM categorie ORDER BY id_categorie
DESC;
IF use_t.id_categorie<>50 THEN
INSERT INTO categorie (nom) VALUES (''test'');
END IF;
RETURN NULL;
END;
'LANGUAGE plpgsql;
The problem is that i can't exec this function to test it, psql return
the following error :
"ERROR: set-valued function called in context that cannot accept a set"
But my INSERT INTO works if i write it directly.
Someone get an idea ?
Thx in advance,
regards,
В списке pgsql-general по дате отправления: