SPI_prepare's parameter

高健 wrote:

I am new to PostgreSQL's SPI(Server Programming Interface).

I can understand PostgreSQL's exampel of using SPI. But I am not sure about SPI_prepare's parameter.

void * SPI_prepare(const char * command, int nargs, Oid * argtypes)

Can somebody kindly give an example of using SPI_prepare ?

Untested:

Oid types[] = { INT4OID };
SPIPlanPtr planptr = SPI_prepare("SELECT val FROM tab WHERE id = $1", 1, types);

Yours,
Laurenz Albe