Supported Versions: Current (13) / 12 / 11 / 10 / 9.6
Development Versions: devel
Unsupported versions: 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.



SPI_getargtypeid -- return the data type OID for an argument of a plan prepared by SPI_prepare


Oid SPI_getargtypeid(void * plan, int argIndex)


SPI_getargtypeid returns the OID representing the type id for the argIndex'th argument of a plan prepared by SPI_prepare. First argument is at index zero.


void * plan

execution plan (returned by SPI_prepare)

int argIndex

zero based index of the argument

Return Value

The type id of the argument at the given index, or SPI_ERROR_ARGUMENT if the plan is NULL or argIndex is less than 0 or not less than the number of arguments declared for the plan