form of an array of <type>regtype</type>. The OID corresponding

to an element of this array can be obtained by casting the

<type>regtype</type> value to <type>oid</type>.

If the prepared statement does not provide a result (e.g., a DML

statement), then this field will be null.

</para></entry>

</row>

while ((prep_stmt=hash_seq_search(&hash_seq))!=NULL)

{

TupleDescresult_desc;

Oid*result_types;

Datumvalues[8];

boolnulls[8];

result_desc=prep_stmt->plansource->resultDesc;

result_types= (Oid*)palloc(result_desc->natts*sizeof(Oid));

for (inti=0;i<result_desc->natts;i++)

result_types[i]=result_desc->attrs[i].atttypid;

MemSet(nulls,0,sizeof(nulls));

values[2]=TimestampTzGetDatum(prep_stmt->prepare_time);

values[3]=build_regtype_array(prep_stmt->plansource->param_types,

prep_stmt->plansource->num_params);

values[4]=build_regtype_array(result_types,result_desc->natts);

if (result_desc)

{

Oid*result_types;

result_types= (Oid*)palloc(result_desc->natts*sizeof(Oid));

for (inti=0;i<result_desc->natts;i++)

result_types[i]=result_desc->attrs[i].atttypid;

values[4]=build_regtype_array(result_types,result_desc->natts);

}

{

nulls[4]= true;

}

values[5]=BoolGetDatum(prep_stmt->from_sql);

values[6]=Int64GetDatumFast(prep_stmt->plansource->num_generic_plans);

values[7]=Int64GetDatumFast(prep_stmt->plansource->num_custom_plans);

SELECT * FROM tenk1 WHERE unique1 = $1 AND stringu1 = $2;

PREPARE q7(unknown) AS

SELECT * FROM road WHERE thepath = $1;

-- DML statements

PREPARE q8 AS

UPDATE tenk1 SET stringu1 = $2 WHERE unique1 = $1;

SELECT name, statement, parameter_types, result_types FROM pg_prepared_statements

ORDER BY name;

name | statement | parameter_types | result_types

| SELECT * FROM tenk1 WHERE unique1 = $1 AND stringu1 = $2; | |

q7 | PREPARE q7(unknown) AS +| {path} | {text,path}

| SELECT * FROM road WHERE thepath = $1; | |

(5 rows)

q8 | PREPARE q8 AS +| {integer,name} |

| UPDATE tenk1 SET stringu1 = $2 WHERE unique1 = $1; | |

(6 rows)

-- test DEALLOCATE ALL;

DEALLOCATE ALL;

PREPARE q7(unknown)AS

SELECT*FROM roadWHERE thepath= $1;

PREPARE q8AS

UPDATE tenk1SET stringu1= $2WHERE unique1= $1;

SELECT name, statement, parameter_types, result_typesFROM pg_prepared_statements

ORDER BY name;