Please keep the list cc'd.
Shruthi A wrote:
> On 7/17/07, Heikki Linnakangas <heikki@enterprisedb.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