Hello!
Tom Lane <[EMAIL PROTECTED]> wrote
>
> Andreas Heiduk <[EMAIL PROTECTED]> writes:
> > If a view which calls a function is LEFT JOINed to a table but not all
> > result rows are matched by some criteria, then the function is called
> > for each row of the view nevertheless.
>
> > Note th
Andreas Heiduk <[EMAIL PROTECTED]> writes:
> But as far as I can tell both queries should always return the same
> results. So I don't understand why the STRICT does not matter in the
> first query but is necessary in the second one. Especially because the
> JOIN criterium is not affected by the fu
Andreas Heiduk <[EMAIL PROTECTED]> writes:
> If a view which calls a function is LEFT JOINed to a table but not all
> result rows are matched by some criteria, then the function is called
> for each row of the view nevertheless.
> Note that this seems to happen only for left joins, not for a inne
Hello!
If a view which calls a function is LEFT JOINed to a table but not all
result rows are matched by some criteria, then the function is called
for each row of the view nevertheless.
It is interesting, that the same query without using a view calls the
function only for those rows wich are r
