This page in other versions: 9.1 / 9.2 / 9.3 / 9.4  |  Development versions: devel / 9.5  |  Unsupported versions: 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4 / 9.0



SPI_getvalue -- return the string value of the specified column


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


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


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

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group