Please keep the list cc'd.

Shruthi A wrote:
> On 7/17/07, Heikki Linnakangas <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to