Re: PL/SQL question

On Tue, 20 Apr 2004, Froggy / Froggy Corp. wrote:

> 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"

Record set returning functions aren't called as:
select foo();
but instead as
select * from foo() AS foo(<columns>);

However, since you're not apparently actually returning a set of anything
in the function you may just want to change the return type.