Re: Altering a plan

Please keep the list cc'd.

Shruthi A wrote:
> On 7/17/07, Heikki Linnakangas <heikki(at)enterprisedb(dot)com> wrote:
>> Shruthi A wrote:
>> >> > I want to take a plan generated by the postgres optimizer and insert
>> a
>> >> > constant in place of another constant in the plan. There is a
>> function
>> >> > OidOutputFunctionCall( ) to get the constant. Similarly, is there
>> any
>> >> > function to set the value of the constant? Also what does
>> >> > OidInputFunctionCall( ) do?
>>
>> Why?
>>
> Actually i'm trying to write a function where the plan which is optimal for
> one query is enforced for another query (and the 2 queries differ only in a
> constant value of a predicate).

How about using a parameter instead of a constant?

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