	О проекте
	Руководство php

pg_result_status

(PHP 4 >= 4.2.0, PHP 5)

pg_result_status -- Get status of query result

Описание

mixed pg_result_status ( resource result [, int type] )

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

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

result: PostgreSQL query result resource, returned by pg_query(), pg_query_params() or pg_execute() (among others).
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.

Возвращаемые значения

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.

Примеры

Пример 1. pg_result_status() 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."; ?>
Результат выполнения данного примера:
Copy began.

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

pg_connection_status()

add a note User Contributed Notes
pg_result_status

Meej Vaj
08-Jun-2005 06:45


If on "accident" your program passes pg_result_status a variable that is NOT a actual pg resource, it will return an empty string.

(This is important to know if you want to make sure a pg resource is "good" before attempting some operation on it).

romix at gmx dot de
16-Oct-2002 06:29


0 = PGSQL_EMPTY_QUERY

1 = PGSQL_COMMAND_OK

2 = PGSQL_TUPLES_OK

3 = PGSQL_COPY_TO

4 = PGSQL_COPY_FROM

5 = PGSQL_BAD_RESPONSE

6 = PGSQL_NONFATAL_ERROR

7 = PGSQL_FATAL_ERROR

add a note

pg_select

pg_result_seek

Last updated: Sat, 27 Jan 2007

This mirror generously provided by: Yahoo! Inc.
Last updated: Sun Nov 4 15:20:50 2007 PST

Новости

11 июля 2007
Сайт запущен