Re: Index on immutable function call - Mailing list pgsql-general

From Tore Halvorsen
Subject Re: Index on immutable function call
Date
Msg-id 50e97fa71001190137t319af2c5tec055076ec56fcce@mail.gmail.com
Whole thread Raw
In response to Re: Index on immutable function call  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Index on immutable function call
Next
From: "A. Kretschmer"
Date:
Subject: Re: Index on immutable function call