Re: BUG #11671: UNACCENT call with constant arg evaluated for each row

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #11671: UNACCENT call with constant arg evaluated for each row
Дата
Msg-id 11263.1413312030@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #11671: UNACCENT call with constant arg evaluated for each row  (t.chaumeny@gmail.com)
Ответы Re: BUG #11671: UNACCENT call with constant arg evaluated for each row  (Thomas <t.chaumeny@gmail.com>)
Re: BUG #11671: UNACCENT call with constant arg evaluated for each row  (David G Johnston <david.g.johnston@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
t.chaumeny@gmail.com writes:
> Since UNACCENT function is defined as STABLE, I would expect its result to
> be evaluated only once in the second query.

The system does not promise any such thing for stable functions.
STABLE is a marker that it is *safe* to evaluate the function fewer
times than naive SQL semantics would suggest; it is not a requirement.

            regards, tom lane

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

Предыдущее
От: t.chaumeny@gmail.com
Дата:
Сообщение: BUG #11671: UNACCENT call with constant arg evaluated for each row
Следующее
От: Thomas
Дата:
Сообщение: Re: BUG #11671: UNACCENT call with constant arg evaluated for each row