PG_FIELD_IS_NULL(3) PG_FIELD_IS_NULL(3)
pg_field_is_null - Test if a field is SQL NULL
SYNOPSIS
int pg_field_is_null (resource $result, int $row, mixed $field)
DESCRIPTION
int pg_field_is_null (resource $result, mixed $field)
pg_field_is_null(3) tests if a field in a PostgreSQL result resource is SQL NULL or not.
Note
This function used to be called pg_fieldisnull(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 to fetch. Rows are numbered from 0 upwards. If omitted, current row is fetched.
o $field
- Field number (starting from 0) as an integer or the field name as a string.
RETURN VALUES
Returns 1 if the field in the given row is SQL NULL, 0 if not. FALSE is returned if the row is out of range, or upon any other error.
EXAMPLES
Example #1
pg_field_is_null(3) example
<?php
$dbconn = pg_connect("dbname=publisher") or die ("Could not connect");
$res = pg_query($dbconn, "select * from authors where author = 'Orwell'");
if ($res) {
if (pg_field_is_null($res, 0, "year") == 1) {
echo "The value of the field year is null.
";
}
if (pg_field_is_null($res, 0, "year") == 0) {
echo "The value of the field year is not null.
";
}
}
?>
PHP Documentation Group PG_FIELD_IS_NULL(3)
