Hi All,<br />I am looking at usage of bound parameters.<br /><br />In functions SPI_cursor_open_with_args() and
SPI_cursor_open_with_args()parameters are flagged as constants and passed to the planner in following manner,<br
/>paramLI= _SPI_convert_params(nargs, argtypes,<br /> Values, Nulls,<br
/> PARAM_FLAG_CONST);<br /><br /> _SPI_prepare_plan(src, &plan, paramLI);<br /><br
/>Thebound params "paramLI" are then passed to the planner as boundParams. Before actually planning the query, these
parametersare evaluated duing constant evaluation (eval_const_expressions_mutator()), and the Param nodes are replaced
withConstant nodes.<br /> Further, while executing such queries we pass the paramLI structure to the execution routine
e.g._SPI_execute_plan(). These parameter values are stored in "EState" structure. But, since these parameters are
alreadyfolded into queries, it looks like parameter values stored in EState are never used.<br /><br />Is this correct?
Orsomewhere we use those parameter values?<br /><br clear="all" /><br />-- <br />Best Wishes,<br />Ashutosh Bapat<br
/>EntepriseDBCorporation<br />The Enterprise Postgres Company<br /><br />