SQL equivalent to nested loop

Hi,

I basically need the SQL equivalent of the following pseudo code:

BEGIN
FOR v IN SELECT * FROM f(4, 'foo') LOOP   FOR w IN SELECT * FROM f(v.id, 'bar') LOOP       RETURN NEXT W   END LOOP;
END LOOP;
RETURN;

Is that possible in SQL?

Markus

-- 
Markus Bertheau ☭ <twanger@bluetwanger.de>