PostgreSQL :: Tecnisys Docs

SPI_fnumber
Prev	Up	46.2. Interface Support Functions	Home	Next

SPI_fnumber

SPI_fnumber — determine the column number for the specified column name

Synopsis

int SPI_fnumber(TupleDesc rowdesc, const char * colname)

Description

SPI_fnumber returns the column number for the column with the specified name.

If `colname refers to a system column (e.g., `oid) then the appropriate negative column number will be returned. The caller should be careful to test the return value for exact equality to SPI_ERROR_NOATTRIBUTE to detect an error; testing the result for less than or equal to 0 is not correct unless system columns should be rejected.

Arguments

`TupleDesc +`_`+rowdesc`_: input row description
`const char * +`_`+colname`_: column name

Return Value

Column number (count starts at 1 for user-defined columns), or SPI_ERROR_NOATTRIBUTE if the named column was not found.

Prev	Up	Next
SPI_fname	Home	SPI_getvalue

Home

SPI_getvalue

Privacy Policy | Code of Conduct | About PostgreSQL | Contact