Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

weird behaviour on DISTINCT ON

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема weird behaviour on DISTINCT ON
Дата
Msg-id ctl4im$iib$1@floppy.pyrenet.fr
обсуждение исходный текст
Ответы Re: weird behaviour on DISTINCT ON
Список pgsql-hackers
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





В списке pgsql-hackers по дате отправления: