SPI_GETARGTYPEID(3)

💖 NAME

Okay so bestie, this is SPI_GETARGTYPEID(3) — the PostgreSQL helper that returns the data type OID for an argument of a statement prepared by SPI_prepare. It’s giving “type detective” energy, fr fr. 🎀

✨ SYNOPSIS

Oid SPI_getargtypeid(SPIPlanPtr plan, int argIndex)

🦋 DESCRIPTION

SPI_getargtypeid returns the OID representing the type for the argIndex'th argument of a statement prepared by SPI_prepare. First argument is at index zero — yes bestie, zero-based indexing is the main character here, periodt. ✨

🌸 ARGUMENTS

• SPIPlanPtr plan — the prepared statement (returned by SPI_prepare). This is the vibe check target, iykyk. 💅
• int argIndex — zero based index of the argument. Not one based, bestie — zero based. 🙈

👑 RETURN VALUE

The type OID of the argument at the given index. Easy, iconic. But if plan is NULL or invalid, or argIndex is less than 0 or not less than the number of arguments declared for the plan, then SPI_result is set to SPI_ERROR_ARGUMENT and InvalidOid is returned. Not me getting an error case — handle it, bestie. 😭

Cute sign-off: this page is from the PostgreSQL 15.19 docs, dated 2026. Hope that slayed for you, bestie — mwah 💋