Re: [BUGS] Too many function calls in view with LEFT JOIN

2006-06-01 Thread Andreas Heiduk
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

Re: [BUGS] Too many function calls in view with LEFT JOIN

2006-05-31 Thread Tom Lane
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

Re: [BUGS] Too many function calls in view with LEFT JOIN

2006-05-30 Thread Tom Lane
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