PostgreSQL

PostgreSQL Elephant Logo

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

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 has the same return conventions as SPI_prepare.


Prev Up Next

SPI_prepare_cursor

Home

SPI_getargcount

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Copyright © 1996-2023 The PostgreSQL Global Development Group