Re: [GENERAL] Filter sequence

2007-11-05 Thread Tom Lane
=?ISO-8859-1?Q?Andr=E9_Volpato?= <[EMAIL PROTECTED]> writes: > select u2.cod, u2.name > from > ( > select u.cod, u.name > from users u > where age between 0 and 44 and sex='F' > group by u.cod, u.name > ) u2 > group by u2.cod, u2.name > having > getSalaryPeriod(1997,1999,u2.cod)

[GENERAL] Filter sequence

2007-11-05 Thread André Volpato
Hi all, I´m experiencing an unexpected behaviour in the planner. I want the planner to apply a function in the results of a subquery, but its doing a filter in the hole table. The results between the mixed filters are the same in the end, but its taking ages. What I want is the planner to apll