php man page for pg_field_is_null

Query: pg_field_is_null

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

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)
Related Man Pages
pg_field_num(3) - php
pg_field_is_null(3) - php
pg_field_name(3) - php
pg_field_size(3) - php
pg_result_error_field(3) - php
Similar Topics in the Unix Linux Community
help with this one please
getting value from field dynamically
To verify whether the year has all the digits
To find the Row number
Awk command to replace specific position characters.