This page in other versions: Unsupported versions: 6.3
pg_result
PostgreSQL
Prev Next

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.


Prev Home Next
pg_select Up pg_lo_creat

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 | About PostgreSQL
Copyright © 1996-2016 The PostgreSQL Global Development Group