SPI_GETTYPEID(3)

💅 NAME 💅

okay so bestie, welcome to SPI_GETTYPEID(3) from the PostgreSQL 16.15 Documentation — this one is literally about SPI_gettypeid, the function that returns the data type OID of the specified column. 👑✨

✨ SYNOPSIS ✨

Oid SPI_gettypeid(TupleDesc rowdesc, int colnumber)

🦋 DESCRIPTION 🦋

SPI_gettypeid returns the OID of the data type of the specified column. That's it, that's the whole serve: you give it a column, it hands back the data type's OID. no cap. 💅

🎀 ARGUMENTS 🎀

• TupleDesc rowdesc — the input row description, aka the row descriptor you're passing in. 🫶
• int colnumber — the column number. and yes, the count starts at 1 — not 0, bestie. iykyk. 💖

💖 RETURN VALUE 💖

It returns the OID of the data type of the specified column, or InvalidOid on error. 😭

On error, SPI_result is set to SPI_ERROR_NOATTRIBUTE. that's what gets set, fr fr. 🚩

mwah 💋 — this has been SPI_GETTYPEID(3) from PostgreSQL 16.15, dated 2026. now go slay those columns, bestie. 🌈👑🎀