I have a query that is something like this:
SELECT DISTINCT ON ( x ) x, foo(x)
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 ?
pgsql-hackers by date
|Next:||From: Mark Cave-Ayland||Date: 2005-01-31 12:34:02|
|Subject: 7.3.8 under FC3 takes excessive semaphores?|
|Previous:||From: Manfred Koizar||Date: 2005-01-31 11:19:18|
|Subject: Re: Refactoring|