PG_RESULT_STATUS(3)													       PG_RESULT_STATUS(3)

pg_result_status - Get status of query result

SYNOPSIS

       mixed pg_result_status (resource  $result, [int	$type = PGSQL_STATUS_LONG])

DESCRIPTION

       pg_result_status(3) returns the status of a result resource, or the PostgreSQL command completion tag associated with the result

PARAMETERS

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

	      o $type
		-  Either  PGSQL_STATUS_LONG  to return the numeric status of the $result, or PGSQL_STATUS_STRING to return the command tag of the
		$result. If not specified, PGSQL_STATUS_LONG is the default.

RETURN VALUES

	Possible return values	are  PGSQL_EMPTY_QUERY,  PGSQL_COMMAND_OK,  PGSQL_TUPLES_OK,  PGSQL_COPY_OUT,  PGSQL_COPY_IN,  PGSQL_BAD_RESPONSE,
       PGSQL_NONFATAL_ERROR  and PGSQL_FATAL_ERROR if PGSQL_STATUS_LONG is specified. Otherwise, a string containing the PostgreSQL command tag is
       returned.

EXAMPLES

       Example #1

	      pg_result_status(3) example

	      <?php

	      // Connect to the database
	      $conn = pg_pconnect("dbname=publisher");

	      // Execute a COPY
	      $result = pg_query($conn, "COPY authors FROM STDIN;");

	      // Get the result status
	      $status = pg_result_status($result);

	      // Determine status
	      if ($status == PGSQL_COPY_IN)
		 echo "Copy began.";
	      else
		 echo "Copy failed.";

	      ?>

	      The above example will output:

	      Copy began.

SEE ALSO

       pg_connection_status(3).

PHP Documentation Group 												       PG_RESULT_STATUS(3)