SPI_FNUMBER(3)

💅 SPI_FNUMBER(3) 💅

okay bestie, gather round — this is the manual page for SPI_fnumber, and it's literally about finding which column number matches a column name. no cap.

✨ NAME ✨

SPI_fnumber — determine the column number for the specified column name. it's giving “where is that column at?” energy. 🎀

🌸 SYNOPSIS 🌸

int SPI_fnumber(TupleDesc rowdesc, const char * colname)

🦋 DESCRIPTION 🦋

SPI_fnumber returns the column number for the column with the specified name. that's the whole assignment, bestie.

If colname refers to a system column (e.g., ctid) then the appropriate negative column number will be returned. yes, negative — system columns are built different. 🫶

⚠️ caller bestie, be careful: test the return value for exact equality to SPI_ERROR_NOATTRIBUTE to detect an error. testing the result for less than or equal to 0 is not correct unless system columns should be rejected. do not do the lazy <= 0 check unless that is actually your vibe. 😭

🎀 ARGUMENTS 🎀

• TupleDesc rowdesc — input row description. it's the row's ID card, basically.
• const char * colname — column name. the name you're looking for, fr fr.

🔥 RETURN VALUE 🔥

Column number (count starts at 1 for user-defined columns), or SPI_ERROR_NOATTRIBUTE if the named column was not found. that's it. that's the tea. 👑

💖 that's the whole page, bestie! brought to you by PostgreSQL 17.11, dated 2026, and delivered with main-character energy. periodt. 🎀