PL/SQL question

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,

Responses

Browse pgsql-general by date

  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