Re: PL/SQL question

I allways get the same error :

ERROR: set-valued function called in context that cannot accept a set

It seems to not accept the "(''test'')". Maybe i made a mistake by
adding the plpgsql langage, but i follow the documentation about that.

If i try to change the insert by "INSERT INTO categorie (id_categorie)
VALUES (''test'');" i got an error msg that "test" is not an integer.
(id_categorie is the primary key of the table).

thx in advance,
regards,

Jeff Eckermann wrote:
>
> --- Mike Nolan <nolan(at)gw(dot)tssi(dot)com> wrote:
> > > In fact the problem seems to come from the
> > "INSERT INTO". I delete
> > > everything from the function and only keep the
> > "INSERT INTO" and get the
> > > same problem.
> >
> > Given that this is supposed to be a trigger
> > function, what's
> > your 'create trigger' statement look like?
> >
> > Part of the problem may be how your 'return null' is
> > being handled,
>
> AFAIK, returning null from a trigger function causes
> the whole operation (insert, update or delete) to be
> aborted, so the transaction is rolled back, including
> the insert inside the function. You want to return
> NEW instead.
>
> > and that can be related to when the trigger fires.
> > --
> > Mike Nolan
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 8: explain analyze is your friend
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Photos: High-quality 4x6 digital prints for 25¢
> http://photos.yahoo.com/ph/print_splash