Hi all, I have a query that is something like this:
SELECT DISTINCT ON ( x ) x, foo(x) FROM ...
now what do I see is that for each different x value the foo is executed more than once, I guess this is because the distinct filter out the rows after executing the query.
Is this behaviour the normal one? Shall be not documented ?
Regards Gaetano Mendola
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
