PG_FIELD_PRTLEN(3)														PG_FIELD_PRTLEN(3)

pg_field_prtlen - Returns the printed length

SYNOPSIS

       int pg_field_prtlen (resource  $result, int  $row_number, mixed	$field_name_or_number)

DESCRIPTION

       int pg_field_prtlen (resource  $result, mixed  $field_name_or_number)

       pg_field_prtlen(3)  returns  the  actual  printed  length (number of characters) of a specific value in a PostgreSQL $result. Row numbering
       starts at 0. This function will return FALSE on an error.

       $field_name_or_number can be passed either as an integer or as a string. If it is passed as an integer, PHP recognises it as the field num-
       ber, otherwise as field name.

	See the example given at the pg_field_name(3) page.

       Note

	       This function used to be called pg_fieldprtlen(3).

PARAMETERS

	      o $result
		- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).

	      o $row
		- Row number in result. Rows are numbered from 0 upwards. If omitted, current row is fetched.

RETURN VALUES

	The field printed length, or FALSE on error.

EXAMPLES

       Example #1

	      Getting information about fields

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

		$res = pg_query($dbconn, "select * from authors where author = 'Orwell'");
		$i = pg_num_fields($res);
		for ($j = 0; $j < $i; $j++) {
		    echo "column $j
";
		    $fieldname = pg_field_name($res, $j);
		    echo "fieldname: $fieldname
";
		    echo "printed length: " . pg_field_prtlen($res, $fieldname) . " characters
";
		    echo "storage length: " . pg_field_size($res, $j) . " bytes
";
		    echo "field type: " . pg_field_type($res, $j) . " 

";
		}
	      ?>

	      The above example will output:

	      column 0
	      fieldname: author
	      printed length: 6 characters
	      storage length: -1 bytes
	      field type: varchar

	      column 1
	      fieldname: year
	      printed length: 4 characters
	      storage length: 2 bytes
	      field type: int2

	      column 2
	      fieldname: title
	      printed length: 24 characters
	      storage length: -1 bytes
	      field type: varchar

SEE ALSO

       pg_field_size(3).

PHP Documentation Group 													PG_FIELD_PRTLEN(3)