Re: [HACKERS] Altering a plan
On Monday 16 July 2007 22:32:07 Shruthi A wrote: Please reply soon, this is an emergency.. This may be obvious, but a quick reply might call for commercial support. Check out [1]. [1]http://www.postgresql.org/support/professional_support wt -- Warren Turkal (w00t) ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [HACKERS] Altering a plan
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? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Altering a plan
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
Re: [HACKERS] Altering a plan
Hi, 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? Please reply soon, this is an emergency.. Thanks a lot, Shruthi
