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