PHP5中文手册·Returns the type ID (OID) for the corresponding field number -- 追寻梦想＞编程乐园＞PHP 编程

说明

int pg_field_type_oid ( resource $result , int $field_number )

pg_field_type_oid() returns an integer containing the OID of the base type of the given field_number in the given PostgreSQL result resource.

You can get more information about the field type by querying PostgreSQL's pg_type system table using the OID obtained with this function. The PostgreSQL format_type() function will convert a type OID into an SQL standard type name.

Note: If the field uses a PostgreSQL domain (rather than a basic type), it is the OID of the domain's underlying type that is returned, rather than the OID of the domain itself.

参数

result: PostgreSQL query result resource, returned by pg_query(), pg_query_params() or pg_execute() (among others).
field_number: Field number, starting from 0.

返回值

The OID of the field's base type. FALSE is returned on error.

范例

Example#1 Getting information about fields


<?php
  $dbconn = pg_connect("dbname=publisher") or die("Could not connect");

  // Assume 'title' is a varchar type
  $res = pg_query($dbconn, "select title from authors where author = 'Orwell'");

  echo "Title field type OID: ", pg_field_type_oid($res, 0);
?>

上例将输出：

Title field type OID: 1043


	PHP5中文手册 pg_field_table pg_field_type PostgreSQL PHP Manual pg_field_type_oid (PHP 5 >= 5.1.0) pg_field_type_oid — Returns the type ID (OID) for the corresponding field number 说明 int pg_field_type_oid ( resource `$result` , int `$field_number` ) pg_field_type_oid() returns an integer containing the OID of the base type of the given `field_number` in the given PostgreSQL `result` resource. You can get more information about the field type by querying PostgreSQL's pg_type system table using the OID obtained with this function. The PostgreSQL format_type() function will convert a type OID into an SQL standard type name. Note: If the field uses a PostgreSQL domain (rather than a basic type), it is the OID of the domain's underlying type that is returned, rather than the OID of the domain itself. 参数 `result` PostgreSQL query result resource, returned by pg_query(), pg_query_params() or pg_execute() (among others). `field_number` Field number, starting from 0. 返回值 The OID of the field's base type. `FALSE` is returned on error. 范例 Example#1 Getting information about fields `<?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); // Assume 'title' is a varchar type $res = pg_query($dbconn, "select title from authors where author = 'Orwell'"); echo "Title field type OID: ", pg_field_type_oid($res, 0); ?>` 上例将输出： Title field type OID: 1043 参见 pg_field_type() pg_field_prtlen() pg_field_name() pg_field_table pg_field_type PostgreSQL PHP Manual

pg_field_type_oid

说明

参数

返回值

范例

参见