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