11111

pg_field_size

Пред.

След.

pg_field_size

(PHP 4 >= 4.2.0, PHP 5)pg_field_size --

Returns the internal storage size of the named field

Описание

int pg_field_size (resource result, int field_number)

- pg_field_size() returns the internal storage

size (in bytes) of the field number in the given PostgreSQL

result.

Замечание:

This function used to be called pg_fieldsize().

Список параметров

-

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 internal field storage size (in bytes). -1 indicates a variable

length field. FALSE is returned on error.

Примеры

-

Пример 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\n";

$fieldname = pg_field_name($res, $j);

echo "fieldname: $fieldname\n";

echo "printed length: " . pg_field_prtlen($res, $fieldname). " characters\n";

echo "storage length: " . pg_field_size($res, $j). " bytes\n";

echo "field type: " . pg_field_type($res, $j). " \n\n";

}

?>

Результат выполнения данного примера:
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

Смотрите также

-

pg_field_prtlen()
pg_field_type()

Пред.

Начало

След.

pg_field_prtlen

Уровень выше

pg_field_type_oid 22222

Free Web Hosting