Re: ORDER BY vs. volatile functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ORDER BY vs. volatile functions
Дата
Msg-id 22884.1258393955@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ORDER BY vs. volatile functions  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Список pgsql-hackers
Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> If you try it using nextval(), you'll notice that the function does
> in fact get called twice per row, but one of the results is thrown
> away and replaced with the other one.

Yeah.  The problem is that setrefs.c is generating a tlist for the
hashagg node in which both output expressions point to the first
output of the underlying scan node, because it's just relying on
equal() to match up the expressions.  I'm testing a fix now ...
        regards, tom lane


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

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: ORDER BY vs. volatile functions
Следующее
От: Alex Hunsaker
Дата:
Сообщение: Re: ALTER TABLE...ALTER COLUMN vs inheritance