SPI_GETVALUE(3)

💖 NAME 💖

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

🦋 SYNOPSIS 🦋

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

🌸 DESCRIPTION 🌸

SPI_getvalue returns the string representation of the value of the specified column. That's the whole vibe, no cap.

The result comes back in memory allocated using palloc. (You can use pfree to release the memory when you don't need it anymore — very demure, very mindful. 💅)

🎀 ARGUMENTS 🎀

• HeapTuple row — the input row to be examined.
• TupleDesc rowdesc — the input row description.
• int colnumber — the column number (count starts at 1).

👑 RETURN VALUE 👑

You get the column value back — icon behavior — or NULL if the column is null, if colnumber is out of range (SPI_result is set to SPI_ERROR_NOATTRIBUTE), or if no output function is available (SPI_result is set to SPI_ERROR_NOOUTFUNC). Not me getting a whole error code for those cases. 💀

with love and PostgreSQL 15.19 docs energy, your Unix bestie — dated 2026 🫶