2
.\" Title: SPI_getvalue
3
.\" Author: The PostgreSQL Global Development Group
4
.\" Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
6
.\" Manual: PostgreSQL 11beta1 Documentation
7
.\" Source: PostgreSQL 11beta1
10
.TH "SPI_GETVALUE" "3" "2018" "PostgreSQL 11beta1" "PostgreSQL 11beta1 Documentation"
11
.\" -----------------------------------------------------------------
12
.\" * Define some portability stuff
13
.\" -----------------------------------------------------------------
14
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
15
.\" http://bugs.debian.org/507673
16
.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
17
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
20
.\" -----------------------------------------------------------------
21
.\" * set default formatting
22
.\" -----------------------------------------------------------------
23
.\" disable hyphenation
25
.\" disable justification (adjust text to left margin only)
27
.\" -----------------------------------------------------------------
28
.\" * MAIN CONTENT STARTS HERE *
29
.\" -----------------------------------------------------------------
31
SPI_getvalue \- return the string value of the specified column
35
char * SPI_getvalue(HeapTuple \fIrow\fR, TupleDesc \fIrowdesc\fR, int \fIcolnumber\fR)
40
returns the string representation of the value of the specified column\&.
42
The result is returned in memory allocated using
43
\fBpalloc\fR\&. (You can use
45
to release the memory when you don\*(Aqt need it anymore\&.)
50
input row to be examined
53
TupleDesc \fIrowdesc\fR
60
column number (count starts at 1)
66
if the column is null,
68
is out of range (\fISPI_result\fR
70
SPI_ERROR_NOATTRIBUTE), or no output function is available (\fISPI_result\fR
72
SPI_ERROR_NOOUTFUNC)\&.