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
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
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
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 > >