From: | "Froggy / Froggy Corp(dot)" <froggy(at)froggycorp(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | PL/SQL question |
Date: | 2004-04-20 19:51:02 |
Message-ID: | 40857F26.D724C7E0@froggycorp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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,
From | Date | Subject | |
---|---|---|---|
Next Message | Lee Harr | 2004-04-20 20:24:27 | Re: convert result to uppercase |
Previous Message | Han Holl | 2004-04-20 19:48:42 | Index on computed column |