Re: Nested CASE-WHEN scoping

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Nested CASE-WHEN scoping
Дата
Msg-id 4DFA6714.2070609@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Nested CASE-WHEN scoping  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
On 16.06.2011 22:46, Pavel Stehule wrote:
> I have a query - should be ExpressionParam used for removing a
> multiple function call when composite result is expanded?
>
> With some similar optimization a SELECT (fce(x)).* FROM tab will be optimal

Hmm, I don't think it will work as is for that purpose, as each 
targetlist item is a separate expression, and ExpressionParams only work 
within an expression.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Boolean operators without commutators vs. ALL/ANY
Следующее
От: Alexey Klyukin
Дата:
Сообщение: Re: proposal: a validator for configuration files