Re: problem with pl/pgsql

Hi,

i think its really you whos confused *g*

Am Don, 2003-04-17 um 07.40 schrieb Ben:
<snip>
> The stored proc is:
> CREATE or REPLACE FUNCTION Fetch_ArtistSet_By_Artists(integer[]) RETURNS setof integer AS
> 'DECLARE
>         artists alias for $1;
>         index   integer := 1;
>         total   integer := 0;
>         r       record;
>         q       text := ''select setID from (select setID,count(*) as c from artistSet where'';
<snip>

ok, the proc returns a setof integer.

<snip>
>
>         for r in execute q
>         LOOP
>             RETURN next r;
>         END LOOP;
>         RETURN;
>     END;
<snip>

but this returns a record....so what you need here is

return next r.setID;

Hope this helps you!

Greetings
   Georg Steffers