SPI_GETVALUE(3)

💖 NAME 💖

okay so welcome to the SPI_GETVALUE(3) page, bestie — this is all about SPI_getvalue, the function that returns the string value of the specified column. 🎀

✨ SYNOPSIS ✨

char * SPI_getvalue(HeapTuple row, TupleDesc rowdesc, int colnumber)

🧚 DESCRIPTION 🧚

SPI_getvalue returns the string representation of the value of the specified column. slay. 💅

The result is returned in memory allocated using palloc. (You can use pfree to release that memory when you don't need it anymore, bestie — no leaks, periodt.) 🫶

🎀 ARGUMENTS 🎀

• HeapTuple row — input row to be examined. 👀
• TupleDesc rowdesc — input row description. it's giving context.
• int colnumber — column number (count starts at 1, iykyk). 🔢

🌸 RETURN VALUE 🌸

Column value, or NULL if:

• the column is null, 😭
• colnumber is out of range (SPI_result is set to SPI_ERROR_NOATTRIBUTE), 🚨
• or no output function is available (SPI_result is set to SPI_ERROR_NOOUTFUNC). 💀

xoxo, PostgreSQL 17.11 docs, 2026, page SPI_GETVALUE(3) — stay iconic 💅✨