ru_php/ext/pgsql/tests/16pg_result_status.phpt

32 lines
680 B
PHP

--TEST--
PostgreSQL pg_result_status()
--EXTENSIONS--
pgsql
--SKIPIF--
<?php include("inc/skipif.inc"); ?>
--FILE--
<?php
include 'inc/config.inc';
$table_name = "table_16pg_result_status";
$db = pg_connect($conn_str);
pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)");
$sql = "SELECT * FROM ".$table_name." WHERE num = -2";
$result = pg_query($db, "BEGIN;END");
echo pg_result_status($result)."\n";
echo pg_result_status($result, PGSQL_STATUS_STRING)."\n";
?>
--CLEAN--
<?php
include('inc/config.inc');
$table_name = "table_16pg_result_status";
$db = pg_connect($conn_str);
pg_query($db, "DROP TABLE IF EXISTS {$table_name}");
?>
--EXPECT--
1
COMMIT