From c5b4a507fe940e9fd2767df55b2c9c6efec9fd2f Mon Sep 17 00:00:00 2001
From: Yasuo Ohgaki <yohgaki@php.net>
Date: Thu, 25 Apr 2002 07:52:01 +0000
Subject: [PATCH] Added test for pg_fetch_*() functions

---
 ext/pgsql/tests/17result.phpt | 40 +++++++++++++++++++++++++++++++++++
 ext/pgsql/tests/result.inc    | 21 ++++++++++++++++++
 2 files changed, 61 insertions(+)
 create mode 100644 ext/pgsql/tests/17result.phpt
 create mode 100644 ext/pgsql/tests/result.inc

diff --git a/ext/pgsql/tests/17result.phpt b/ext/pgsql/tests/17result.phpt
new file mode 100644
index 0000000000..33acb3a682
--- /dev/null
+++ b/ext/pgsql/tests/17result.phpt
@@ -0,0 +1,40 @@
+--TEST--
+PostgreSQL pg_fetch_*() functions
+--SKIPIF--
+<?php include("skipif.inc"); ?>
+--FILE--
+<?php
+include("result.inc");
+?>
+--EXPECT--
+object(stdClass)(3) {
+  ["num"]=>
+  string(1) "1"
+  ["str"]=>
+  string(3) "ABC"
+  ["bin"]=>
+  NULL
+}
+array(6) {
+  [0]=>
+  string(1) "1"
+  ["num"]=>
+  string(1) "1"
+  [1]=>
+  string(3) "ABC"
+  ["str"]=>
+  string(3) "ABC"
+  [2]=>
+  NULL
+  ["bin"]=>
+  NULL
+}
+array(3) {
+  [0]=>
+  string(1) "1"
+  [1]=>
+  string(3) "ABC"
+  [2]=>
+  NULL
+}
+Ok
diff --git a/ext/pgsql/tests/result.inc b/ext/pgsql/tests/result.inc
new file mode 100644
index 0000000000..6982a84493
--- /dev/null
+++ b/ext/pgsql/tests/result.inc
@@ -0,0 +1,21 @@
+<?php
+error_reporting(E_ALL);
+
+include 'config.inc';
+
+$db = pg_connect($conn_str);
+
+$sql = "SELECT * FROM $table_name";
+$result = pg_query($db, $sql) or die('Cannot qeury db');
+$rows = pg_num_rows($result);
+
+$rec = pg_fetch_object($result, 1);
+var_dump($rec);
+$rec = pg_fetch_array($result, 1);
+var_dump($rec);
+$rec = pg_fetch_row($result, 1);
+var_dump($rec);
+
+echo "Ok\n";
+
+?>
\ No newline at end of file
-- 
2.50.1