SPI_GETARGTYPEID(3)

okay so welcome to SPI_GETARGTYPEID(3), bestie — this is one of those little PostgreSQL 17.11 documentation pages, and it's lowkey a tiny helper. Let's get into it 💅

💖 NAME 💖

SPI_getargtypeid — return the data type OID for an argument of a statement prepared by SPI_prepare

✨ 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. No cap, zero-based indexing is the main character here 🎀

🌸 ARGUMENTS 🌸

• SPIPlanPtr plan — the prepared statement, returned by SPI_prepare
• int argIndex — the zero based index of the argument

💜 RETURN VALUE 💜

The type OID of the argument at the given index.

but bestie, watch out: if the plan is NULL or invalid, or argIndex is less than 0 or not less than the number of arguments declared for the plan, SPI_result is set to SPI_ERROR_ARGUMENT and InvalidOid is returned 💀

signing off from the PostgreSQL 17.11 docs, dated 2026, on the SPI_GETARGTYPEID(3) page — slay and read your manpages responsibly 🫶✨