Re: Nested CASE-WHEN scoping - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Nested CASE-WHEN scoping
Date
Msg-id 4DFA6714.2070609@enterprisedb.com
Whole thread Raw
In response to Re: Nested CASE-WHEN scoping  (Pavel Stehule <pavel.stehule@gmail.com>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Boolean operators without commutators vs. ALL/ANY
Next
From: Alexey Klyukin
Date:
Subject: Re: proposal: a validator for configuration files