| Subject | Re: Common Table Expressions (“WITH .. . AS ... SELECT”) |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2015-01-22T18:29:20Z |
22.01.2015 21:13, Svein Erling Tysvær wrote:
is always [re-]evaluated for the every outer row.
Dmitry
> I guess you'Re right in that the CTE is called once for each iteration.It's not about CTE, but about outer joins. Inner part of the left join
is always [re-]evaluated for the every outer row.
Dmitry