Doubt about boundParams
От | Ashutosh Bapat |
---|---|
Тема | Doubt about boundParams |
Дата | |
Msg-id | CAFjFpRe36ZBZ-vEZxFYC+_b5acj74-2xyuWamAaqsNkHJz13dQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Doubt about boundParams
|
Список | pgsql-hackers |
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 />
В списке pgsql-hackers по дате отправления: