PostgreSQL Programmer's Guide
PrevNext

pg_result

Name

pg_result — get information about a query result

pg_result queryHandle resultOption

Inputs

queryHandle

The handle for a query result.

resultOption

Specifies one of several possible options.

Options

-status

the status of the result.

-oid

if the last query was an insert, returns the oid of the inserted tuple

-conn

the connection that produced the result

-assign arrayName

assign the results to an array

-numTuples

the number of tuples in the query

-attributes

returns a list of the name/type pairs of the tuple attributes

-getTuple tupleNumber

returns the values of the tuple in a list

-clear

clear the result buffer. Do not reuse after this

Outputs

queryHandle

the return result is either an error message or a handle for a query result.

Description

pg_result returns information about a query.


PrevHomeNext
pg_selectUppg_lo_creat