SQL equivalent to nested loop - Mailing list pgsql-sql

From Markus Bertheau ☭
Subject SQL equivalent to nested loop
Date
Msg-id 1118076751.5506.17.camel@dicaprio.akademie1.de
Whole thread Raw
List pgsql-sql
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>



pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: How do write a query...
Next
From: KÖPFERL Robert
Date:
Subject: Re: SQL equivalent to nested loop