chriskl Tue Mar 22 03:59:00 2005 EDT
Modified files:
/phpdoc/en/reference/pgsql/functions pg-result-error-field.xml
Log:
List possible diagnostic codes
http://cvs.php.net/diff.php/phpdoc/en/reference/pgsql/functions/pg-result-error-field.xml?r1=1.1&r2=1.2&ty=u
Index: phpdoc/en/reference/pgsql/functions/pg-result-error-field.xml
diff -u phpdoc/en/reference/pgsql/functions/pg-result-error-field.xml:1.1
phpdoc/en/reference/pgsql/functions/pg-result-error-field.xml:1.2
--- phpdoc/en/reference/pgsql/functions/pg-result-error-field.xml:1.1 Sun Mar
20 03:54:31 2005
+++ phpdoc/en/reference/pgsql/functions/pg-result-error-field.xml Tue Mar
22 03:58:58 2005
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.1 $ -->
+<!-- $Revision: 1.2 $ -->
<!-- splitted from ./en/functions/pgsql.xml, last change in rev 1.58 -->
<refentry id='function.pg-result-error-field'>
<refnamediv>
@@ -28,7 +28,38 @@
<function>pg_get_result</function> to get the result handle.
</para>
<para>
- Possible <parameter>fieldcode</parameter> values are:
+ Possible <parameter>fieldcode</parameter> values are:
<literal>PGSQL_DIAG_SEVERITY</literal>,
+ <literal>PGSQL_DIAG_SQLSTATE</literal>,
<literal>PGSQL_DIAG_MESSAGE_PRIMARY</literal>, x
+ <literal>PGSQL_DIAG_MESSAGE_DETAIL</literal>,
+ <literal>PGSQL_DIAG_MESSAGE_HINT</literal>,
<literal>PGSQL_DIAG_STATEMENT_POSITION</literal>,
+ <literal>PGSQL_DIAG_INTERNAL_POSITION</literal> (PostgreSQL 8.0+ only),
+ <literal>PGSQL_DIAG_INTERNAL_QUERY</literal> (PostgreSQL 8.0+ only),
+ <literal>PGSQL_DIAG_CONTEXT</literal>,
<literal>PGSQL_DIAG_SOURCE_FILE</literal>,
+ <literal>PGSQL_DIAG_SOURCE_LINE</literal> or
+ <literal>PGSQL_DIAG_SOURCE_FUNCTION</literal>.
+ </para>
+ </refsect1>
+
+ <refsect1 role="examples">
+ &reftitle.examples;
+ <para>
+ <example>
+ <title><function>pg_result_error_field</function> example</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+ $dbconn = pg_connect("dbname=publisher") or die("Could not connect");
+
+ if (!pg_connection_busy($dbconn)) {
+ pg_send_query($dbconn, "select * from doesnotexist;");
+ }
+
+ $res1 = pg_get_result($dbconn);
+ echo pg_result_error_field($res1, PGSQL_DIAG_SQLSTATE);
+?>
+]]>
+ </programlisting>
+ </example>
</para>
</refsect1>
