Re: Index on immutable function call

On Tue, Jan 19, 2010 at 10:22 AM, Alban Hertroys
<dalroi@solfertje.student.utwente.nl> wrote:
>
> On 19 Jan 2010, at 8:26, A. Kretschmer wrote:
>> The planner doesn't know the actual parameter for the function, so he
>> picked out the wrong plan. You can force the planner to re-planning with
>> a dynamical statement within the function and EXECUTE that.
>
>
> There are no queries in his function, I think you misread his post.

Perhaps this might work?

create index transform_index on indexed_table(serial)
where data1 > this_is_a_long_transformation(data2);

--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
<demo> 2010 Tore Halvorsen || +052 0553034554