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(at)bluetwanger(dot)de>