SPI_GETTYPEID(3)

💖 NAME 💖

okay bestie, welcome to the SPI_GETTYPEID(3) page from the PostgreSQL 17.11 Documentation ✨ SPI_gettypeid — return the data type OID of the specified column. That's literally the whole assignment 🎀

🌸 SYNOPSIS 🌸

Oid SPI_gettypeid(TupleDesc rowdesc, int colnumber)

🦋 DESCRIPTION 🦋

okay so here's the tea: SPI_gettypeid returns the OID of the data type of the specified column. no cap, that's the whole function. iconic query energy 💅

💜 ARGUMENTS 💜

• TupleDesc rowdesc — input row description. yes, it's the row desc you're feeding in 🫶
• int colnumber — column number (count starts at 1). bestie, count starts at 1, noted 🌸

⭐ RETURN VALUE ⭐

The OID of the data type of the specified column or InvalidOid on error. On error, SPI_result is set to SPI_ERROR_NOATTRIBUTE. so if it's mad, you get InvalidOid, and SPI_result is set to SPI_ERROR_NOATTRIBUTE — fr fr, that's the error signal 😭

cute sign-off: this page is from PostgreSQL 17.11, dated 2026, and it's the SPI_GETTYPEID(3) manual page. slay, go call your OIDs bestie 💖🎀🦋