[SQL] SQL equivalent to nested loop

[Markus Bertheau ☭]

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 ☭ <[EMAIL PROTECTED]>


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings