Re: Recursive SETOF function

>     SELECT INTO cid count(*) FROM providers WHERE uid =child_provider;
Hey, hey.Better :
SELECT blablah FROM providers WHERE uid = child_provider LIMIT 1;IF NOT FOUND THEN exit with error ELSE do your stuff
Why scan more than 1 row when you just need existence ?Or :
SELECT INTO cid parent_id FROM providers WHERE uid=cid;WHILE FOUND    RETURN NEXT cid;    SELECT INTO cid parent_id
FROMproviders WHERE uid=cid;END;
 
Not sure about the While syntax but you get the idea.