SPI_GETVALUE(3)

💖 SPI_GETVALUE(3) — the bestie edition 💖

Straight out of the PostgreSQL 13.23 Documentation, it's SPI_GETVALUE(3) 💅 and we're getting into it.

🌸 NAME 🌸

SPI_getvalue — return the string value of the specified column. Periodt. ✨

✨ SYNOPSIS ✨

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

💅 DESCRIPTION 💅

Okay so SPI_getvalue returns the string representation of the value of the specified column. That's the whole vibe. 🫶

The result comes back in memory allocated using palloc. (You can use pfree to release that memory when you don't need it anymore.) No cap. 🎀

🎀 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, or NULL if any of these is true:

• the column is null
• colnumber is out of range (SPI_result is set to SPI_ERROR_NOATTRIBUTE)
• no output function is available (SPI_result is set to SPI_ERROR_NOOUTFUNC)

Made with 💖 for PostgreSQL 13.23 · 2025 · SPI_GETVALUE(3) — mwah 💅✨