Postgresql 中文操作指南

SPI_prepare_params

SPI_prepare_params — 准备好一条语句，但不执行

SPI_prepare_params — prepare a statement, without executing it yet

Synopsis

SPIPlanPtr SPI_prepare_params(const char * command,
                              ParserSetupHook parserSetup,
                              void * parserSetupArg,
                              int cursorOptions)

Description

SPI_prepare_params 创建并返回指定命令的准备语句，但不执行命令。此函数等效于 SPI_prepare_cursor ，另外调用者可以指定解析器挂钩函数来控制外部参数引用的解析。

SPI_prepare_params creates and returns a prepared statement for the specified command, but doesn’t execute the command. This function is equivalent to SPI_prepare_cursor, with the addition that the caller can specify parser hook functions to control the parsing of external parameter references.

此函数现已弃用，建议使用 SPI_prepare_extended 。

This function is now deprecated in favor of SPI_prepare_extended.

Arguments

  • const char * _command_

    • command string

  • ParserSetupHook _parserSetup_

    • Parser hook setup function

  • void * _parserSetupArg_

    • pass-through argument for parserSetup

  • int _cursorOptions_

    • integer bit mask of cursor options; zero produces default behavior

Return Value

SPI_prepare_params 具有与 SPI_prepare 相同的返回约定。

SPI_prepare_params has the same return conventions as SPI_prepare.