PostgreSQL :: Tecnisys Docs

SPI_getvalue
Prev	Up	47.2. Interface Support Functions	Home	Next

SPI_getvalue

SPI_getvalue — return 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.

The result is returned in memory allocated using palloc. (You can use pfree to release the memory when you don’t need it anymore.)

Arguments

`HeapTuple +`_`+row`_: input row to be examined
`TupleDesc +`_`+rowdesc`_: input row description
`int +`_`+colnumber`_: column number (count starts at 1)

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).

Prev	Up	Next
SPI_fnumber	Home	SPI_getbinval

Home

SPI_getbinval

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | Code of Conduct | About PostgreSQL | Contact