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 EnterpriseDB http://www.enterprisedb.com ---------------------------(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 match