chriskl         Sun Jul  3 06:03:51 2005 EDT

  Modified files:              
    /phpdoc/en/reference/pgsql/functions        pg-delete.xml 
                                                pg-escape-bytea.xml 
                                                pg-escape-string.xml 
                                                pg-free-result.xml 
                                                pg-get-notify.xml 
                                                pg-get-pid.xml pg-insert.xml 
                                                pg-update.xml 
  Log:
  Convert several more pgsql extension doc pages to the new format.
  
http://cvs.php.net/diff.php/phpdoc/en/reference/pgsql/functions/pg-delete.xml?r1=1.14&r2=1.15&ty=u
Index: phpdoc/en/reference/pgsql/functions/pg-delete.xml
diff -u phpdoc/en/reference/pgsql/functions/pg-delete.xml:1.14 
phpdoc/en/reference/pgsql/functions/pg-delete.xml:1.15
--- phpdoc/en/reference/pgsql/functions/pg-delete.xml:1.14      Fri Jun 24 
05:11:45 2005
+++ phpdoc/en/reference/pgsql/functions/pg-delete.xml   Sun Jul  3 06:03:51 2005
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.14 $ -->
+<!-- $Revision: 1.15 $ -->
 <!-- splitted from ./en/functions/pgsql.xml, last change in rev 1.80 -->
 <refentry id='function.pg-delete'>
  <refnamediv>
@@ -19,17 +19,66 @@
    <methodparam 
choice="opt"><type>int</type><parameter>options</parameter></methodparam>
   </methodsynopsis>
   <para>
-   <function>pg_delete</function> deletes record condition specified by
-   <parameter>assoc_array</parameter> which has
-   <literal>field=>value</literal>. If <parameter>options</parameter> is
+   <function>pg_delete</function> deletes records from a table specified by
+   the keys and values in <parameter>assoc_array</parameter>. If 
<parameter>options</parameter> is
    specified, <function>pg_convert</function> is applied
-   to <parameter>assoc_array</parameter> with specified option.
-   &return.success;
-   If <constant>PGSQL_DML_STRING</constant> is part of the
-   <parameter>options</parameter> then query string is returned.
+   to <parameter>assoc_array</parameter> with the specified options.
   </para>
  </refsect1>
 
+<refsect1 role="parameters">
+  &reftitle.parameters;
+  <para>
+   <variablelist>
+    <varlistentry>
+     <term><parameter>connection</parameter></term>
+     <listitem>
+      <para>
+       PostgreSQL database connection resource.
+      </para>
+     </listitem>
+    </varlistentry>
+    <varlistentry>
+     <term><parameter>table_name</parameter></term>
+     <listitem>
+      <para>
+       Name of the table from which to delete rows.
+      </para>
+     </listitem>
+    </varlistentry>
+    <varlistentry>
+     <term><parameter>assoc_array</parameter></term>
+     <listitem>
+      <para>
+       An <type>array</type> whose keys are field names in the table 
<parameter>table_name</parameter>,
+       and whose values are the values of those fields that are to be deleted.
+      </para>
+     </listitem>
+    </varlistentry>
+    <varlistentry>
+     <term><parameter>options</parameter></term>
+     <listitem>
+      <para>
+       Any number of <constant>PGSQL_CONV_FORCE_NULL</constant>, 
+       <constant>PGSQL_DML_NO_CONV</constant>,
+       <constant>PGSQL_DML_EXEC</constant> or
+       <constant>PGSQL_DML_STRING</constant> combined. If 
<constant>PGSQL_DML_STRING</constant> is part of the
+       <parameter>options</parameter> then query string is returned.
+      </para>
+     </listitem>
+    </varlistentry>
+   </variablelist>
+  </para>
+ </refsect1>
+
+ <refsect1 role="returnvalues">
+  &reftitle.returnvalues;
+  <para>
+   &return.success;  Returns <type>string</type> if 
<constant>PGSQL_DML_STRING</constant> is passed
+   via <parameter>options</parameter>.
+  </para>
+ </refsect1>
+ 
  <refsect1 role="examples">
   &reftitle.examples;
   <para>
http://cvs.php.net/diff.php/phpdoc/en/reference/pgsql/functions/pg-escape-bytea.xml?r1=1.7&r2=1.8&ty=u
Index: phpdoc/en/reference/pgsql/functions/pg-escape-bytea.xml
diff -u phpdoc/en/reference/pgsql/functions/pg-escape-bytea.xml:1.7 
phpdoc/en/reference/pgsql/functions/pg-escape-bytea.xml:1.8
--- phpdoc/en/reference/pgsql/functions/pg-escape-bytea.xml:1.7 Fri Mar 11 
11:03:25 2005
+++ phpdoc/en/reference/pgsql/functions/pg-escape-bytea.xml     Sun Jul  3 
06:03:51 2005
@@ -1,11 +1,11 @@
 <?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.7 $ -->
+<!-- $Revision: 1.8 $ -->
 <!-- splitted from ./en/functions/pgsql.xml, last change in rev 1.61 -->
 <refentry id='function.pg-escape-bytea'>
  <refnamediv>
   <refname>pg_escape_bytea</refname>
   <refpurpose>
-   Escape binary for bytea type
+   Escape a string for insertion into a bytea field
   </refpurpose>
  </refnamediv>
 
@@ -21,22 +21,72 @@
   </para>
   <note>
    <para>
-    When you SELECT bytea type, PostgreSQL returns octal byte value
-    prefixed by \ (e.g. \032). Users are supposed to convert back to
-    binary format by yourself.
+    When you <literal>SELECT</select> a bytea type, PostgreSQL returns octal 
byte values
+    prefixed with '\' (e.g. \032). Users are supposed to convert back to
+    binary format manually.
    </para>
    <para>
     This function requires PostgreSQL 7.2 or later. With PostgreSQL
-    7.2.0 and 7.2.1, bytea type must be casted when you enable
+    7.2.0 and 7.2.1, bytea values must be cast when you enable
     multi-byte support. i.e. <literal>INSERT INTO test_table (image)
     VALUES ('$image_escaped'::bytea);</literal> PostgreSQL 7.2.2 or
-    later does not need cast. Exception is when client and backend
-    character encoding does not match, there may be multi-byte
-    stream error. User must cast to bytea to avoid this error.
+    later does not need a cast. The exception is when the client and backend
+    character encoding does not match, and there may be multi-byte
+    stream error. User must then cast to bytea to avoid this error.
    </para>
   </note>
  </refsect1>
 
+<refsect1 role="parameters">
+  &reftitle.parameters;
+  <para>
+   <variablelist>
+    <varlistentry>
+     <term><parameter>data</parameter></term>
+     <listitem>
+      <para>
+       A <type>string</type> containing text or binary data to be inserted 
into a bytea
+       column.
+      </para>
+     </listitem>
+    </varlistentry>
+   </variablelist>
+  </para>
+ </refsect1>
+
+ <refsect1 role="returnvalues">
+  &reftitle.returnvalues;
+  <para>
+   A <type>string</type> containing the escaped data.
+  </para>
+ </refsect1>
+
+ <refsect1 role="examples">
+  &reftitle.examples;
+  <para>
+   <example>
+    <title><function>pg_escape_bytea</function> example</title>
+    <programlisting role="php">
+<![CDATA[
+<?php 
+  // Connect to the database
+  $dbconn = pg_connect('dbname=foo');
+  
+  // Read in a binary file
+  $data = file_get_contents('image1.jpg');
+  
+  // Escape the binary data
+  $escaped = pg_escape_bytea($data);
+  
+  // Insert it into the database
+  pg_query("INSERT INTO gallery (name, data) VALUES ('Pine trees', 
'{$escaped}')";
+?>
+]]>
+    </programlisting>
+   </example>
+  </para>
+ </refsect1>
+ 
  <refsect1 role="seealso">
   &reftitle.seealso;
   <para>
http://cvs.php.net/diff.php/phpdoc/en/reference/pgsql/functions/pg-escape-string.xml?r1=1.5&r2=1.6&ty=u
Index: phpdoc/en/reference/pgsql/functions/pg-escape-string.xml
diff -u phpdoc/en/reference/pgsql/functions/pg-escape-string.xml:1.5 
phpdoc/en/reference/pgsql/functions/pg-escape-string.xml:1.6
--- phpdoc/en/reference/pgsql/functions/pg-escape-string.xml:1.5        Fri Mar 
11 11:03:25 2005
+++ phpdoc/en/reference/pgsql/functions/pg-escape-string.xml    Sun Jul  3 
06:03:51 2005
@@ -1,11 +1,11 @@
 <?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.5 $ -->
+<!-- $Revision: 1.6 $ -->
 <!-- splitted from ./en/functions/pgsql.xml, last change in rev 1.61 -->
 <refentry id='function.pg-escape-string'>
  <refnamediv>
   <refname>pg_escape_string</refname>
   <refpurpose>
-   Escape string for text/char type
+   Escape a string for insertion into a text field
   </refpurpose>
  </refnamediv>
 
@@ -16,10 +16,12 @@
    <methodparam><type>string</type><parameter>data</parameter></methodparam>
   </methodsynopsis>
   <para>
-   <function>pg_escape_string</function> escapes string for
-   text/char datatype.  It returns escaped string for
-   PostgreSQL. Use of this function is recommended instead of
-   <function>addslashes</function>.
+   <function>pg_escape_string</function> escapes a string for
+   insertion into the database.  It returns an escaped string in the
+   PostgreSQL format. Use of this function is recommended instead of
+   <function>addslashes</function>.  If the type of the column
+   is bytea, <function>pg_escape_bytea</function> must be used
+   instead.
   </para>
   <note>
    <para>
@@ -28,6 +30,55 @@
   </note>
  </refsect1>
 
+<refsect1 role="parameters">
+  &reftitle.parameters;
+  <para>
+   <variablelist>
+    <varlistentry>
+     <term><parameter>data</parameter></term>
+     <listitem>
+      <para>
+       A <type>string</type> containing text to be escaped.
+      </para>
+     </listitem>
+    </varlistentry>
+   </variablelist>
+  </para>
+ </refsect1>
+
+ <refsect1 role="returnvalues">
+  &reftitle.returnvalues;
+  <para>
+   A <type>string</type> containing the escaped data.
+  </para>
+ </refsect1>
+
+ <refsect1 role="examples">
+  &reftitle.examples;
+  <para>
+   <example>
+    <title><function>pg_escape_string</function> example</title>
+    <programlisting role="php">
+<![CDATA[
+<?php 
+  // Connect to the database
+  $dbconn = pg_connect('dbname=foo');
+  
+  // Read in a text file (containing apostrophes and backslashes)
+  $data = file_get_contents('letter.txt');
+  
+  // Escape the text data
+  $escaped = pg_escape_string($data);
+  
+  // Insert it into the database
+  pg_query("INSERT INTO correspondence (name, data) VALUES ('My letter', 
'{$escaped}')";
+?>
+]]>
+    </programlisting>
+   </example>
+  </para>
+ </refsect1>
+ 
  <refsect1 role="seealso">
   &reftitle.seealso;
   <para>
http://cvs.php.net/diff.php/phpdoc/en/reference/pgsql/functions/pg-free-result.xml?r1=1.7&r2=1.8&ty=u
Index: phpdoc/en/reference/pgsql/functions/pg-free-result.xml
diff -u phpdoc/en/reference/pgsql/functions/pg-free-result.xml:1.7 
phpdoc/en/reference/pgsql/functions/pg-free-result.xml:1.8
--- phpdoc/en/reference/pgsql/functions/pg-free-result.xml:1.7  Thu Apr 21 
05:29:05 2005
+++ phpdoc/en/reference/pgsql/functions/pg-free-result.xml      Sun Jul  3 
06:03:51 2005
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.7 $ -->
+<!-- $Revision: 1.8 $ -->
 <!-- splitted from ./en/functions/pgsql.xml, last change in rev 1.2 -->
 <refentry id="function.pg-free-result">
  <refnamediv>
@@ -14,14 +14,13 @@
    
<methodparam><type>resource</type><parameter>result</parameter></methodparam>
   </methodsynopsis>
   <para>
-   <function>pg_free_result</function> only needs to be called if you
-   are worried about using too much memory while your script is
-   running. All result memory will automatically be freed when the
-   script is finished. But, if you are sure you are not going to
-   need the result data anymore in a script, you may call
-   <function>pg_free_result</function> with the
-   <parameter>result</parameter> resource as an argument and the
-   associated result memory will be freed. &return.success;
+   <function>pg_free_result</function> frees the memory and data associated 
with the
+   specified PostgreSQL query result <type>resource</type>.
+  </para>
+  <para>
+   This function need only be called if memory
+   consumption during script execution is a problem.   Otherwise, all result 
memory will 
+   be automatically freed when the script ends.
   </para>
   <note>
    <para>
@@ -30,11 +29,68 @@
   </note>
  </refsect1>
 
+ <refsect1 role="parameters">
+  &reftitle.parameters;
+  <para>
+   <variablelist>
+    <varlistentry>
+     <term><parameter>result</parameter></term>
+     <listitem>
+      <para>
+       PostgreSQL query result resource, returned by 
<function>pg_query</function>,
+       <function>pg_query_params</function> or <function>pg_execute</function>
+       (among others).
+      </para>
+     </listitem>
+    </varlistentry>
+   </variablelist>
+  </para>
+ </refsect1>
+
+ <refsect1 role="returnvalues">
+  &reftitle.returnvalues;
+  <para>
+   &return.success;
+  </para>
+ </refsect1>
+
+ <refsect1 role="examples">
+  &reftitle.examples;
+  <para>
+   <example>
+    <title><function>pg_free_result</function> example</title>
+    <programlisting role="php">
+<![CDATA[
+<?php
+$db = pg_connect("dbname=users user=me") || die();
+
+$res = pg_query($db, "SELECT 1 UNION ALL SELECT 2");
+
+$val = pg_fetch_result($res, 1, 0);
+
+echo "First field in the second row is: ", $val, "\n";
+
+pg_free_result($res);
+?>
+]]>
+    </programlisting>
+    &example.outputs;
+    <screen>
+<![CDATA[
+First field in the second row is: 2
+]]>
+    </screen>
+   </example>
+  </para>
+ </refsect1>
+
  <refsect1 role="seealso">
   &reftitle.seealso;
   <para>
    <simplelist>
     <member><function>pg_query</function></member>
+    <member><function>pg_query_params</function></member>
+    <member><function>pg_execute</function></member>
    </simplelist>
   </para>
  </refsect1>
http://cvs.php.net/diff.php/phpdoc/en/reference/pgsql/functions/pg-get-notify.xml?r1=1.11&r2=1.12&ty=u
Index: phpdoc/en/reference/pgsql/functions/pg-get-notify.xml
diff -u phpdoc/en/reference/pgsql/functions/pg-get-notify.xml:1.11 
phpdoc/en/reference/pgsql/functions/pg-get-notify.xml:1.12
--- phpdoc/en/reference/pgsql/functions/pg-get-notify.xml:1.11  Sun May 15 
21:17:54 2005
+++ phpdoc/en/reference/pgsql/functions/pg-get-notify.xml       Sun Jul  3 
06:03:51 2005
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.11 $ -->
+<!-- $Revision: 1.12 $ -->
 <refentry id="function.pg-get-notify">
  <refnamediv>
   <refname>pg_get_notify</refname>
@@ -14,15 +14,54 @@
    <methodparam 
choice="opt"><type>int</type><parameter>result_type</parameter></methodparam>
   </methodsynopsis>
   <para>
-   <function>pg_get_notify</function> gets notify message sent by
-   <literal>NOTIFY</literal> SQL command. To receive notify
-   messages, <literal>LISTEN</literal> SQL command must be
-   issued. If there is notify message on the connection, array
-   contains message name and backend PID is returned. If there is no
-   message, &false; is returned.
+   <function>pg_get_notify</function> gets notifications generated by a
+   <literal>NOTIFY</literal> SQL command. To receive notifications,
+   the <literal>LISTEN</literal> SQL command must be
+   issued.
   </para>
  </refsect1>
- 
+
+<refsect1 role="parameters">
+  &reftitle.parameters;
+  <para>
+   <variablelist>
+    <varlistentry>
+     <term><parameter>connection</parameter></term>
+     <listitem>
+      <para>
+       PostgreSQL database connection resource.
+      </para>
+     </listitem>
+    </varlistentry>
+    <varlistentry>
+     <term><parameter>result_type</parameter></term>
+     <listitem>
+      <para>
+       An optional parameter that controls
+       how the returned <type>array</type> is indexed.
+       <parameter>result_type</parameter> is a constant and can take the
+       following values: <constant>PGSQL_ASSOC</constant>, 
+       <constant>PGSQL_NUM</constant> and <constant>PGSQL_BOTH</constant>.
+       Using <constant>PGSQL_NUM</constant>, <function>pg_get_notify</function>
+       will return an array with numerical indices, using
+       <constant>PGSQL_ASSOC</constant> it will return only associative indices
+       while <constant>PGSQL_BOTH</constant>, the default, will return both
+       numerical and associative indices.
+      </para>
+     </listitem>
+    </varlistentry>
+   </variablelist>
+  </para>
+ </refsect1>
+
+ <refsect1 role="returnvalues">
+  &reftitle.returnvalues;
+  <para>
+   An <type>array</type> containing the <literal>NOTIFY</literal> message name 
and backend PID.
+   Otherwise if no </literal>NOTIFY</literal> is waiting, then &false; is 
returned.
+  </para>
+ </refsect1>
+
  <refsect1 role="examples">
   &reftitle.examples;
   <para>
http://cvs.php.net/diff.php/phpdoc/en/reference/pgsql/functions/pg-get-pid.xml?r1=1.5&r2=1.6&ty=u
Index: phpdoc/en/reference/pgsql/functions/pg-get-pid.xml
diff -u phpdoc/en/reference/pgsql/functions/pg-get-pid.xml:1.5 
phpdoc/en/reference/pgsql/functions/pg-get-pid.xml:1.6
--- phpdoc/en/reference/pgsql/functions/pg-get-pid.xml:1.5      Sat May 14 
17:11:17 2005
+++ phpdoc/en/reference/pgsql/functions/pg-get-pid.xml  Sun Jul  3 06:03:51 2005
@@ -1,9 +1,9 @@
 <?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.5 $ -->
+<!-- $Revision: 1.6 $ -->
 <refentry id="function.pg-get-pid">
  <refnamediv>
   <refname>pg_get_pid</refname>
-  <refpurpose>Gets backend's process ID</refpurpose>
+  <refpurpose>Gets the backend's process ID</refpurpose>
  </refnamediv>
 
  <refsect1 role="description">
@@ -13,12 +13,36 @@
    
<methodparam><type>resource</type><parameter>connection</parameter></methodparam>
   </methodsynopsis>
   <para>
-   <function>pg_get_pid</function> gets backend (database server
-   process) PID. PID is useful to check if <literal>NOTIFY</literal>
-   message is sent from other process or not.
+   <function>pg_get_pid</function> gets the backend's (database server
+   process) PID. The PID is useful to determine whether or not a 
<literal>NOTIFY</literal>
+   message received via <function>pg_get_notify</function> is sent from 
another process
+   or not.
   </para>
  </refsect1>
 
+<refsect1 role="parameters">
+  &reftitle.parameters;
+  <para>
+   <variablelist>
+    <varlistentry>
+     <term><parameter>connection</parameter></term>
+     <listitem>
+      <para>
+       PostgreSQL database connection resource.
+      </para>
+     </listitem>
+    </varlistentry>
+   </variablelist>
+  </para>
+ </refsect1>
+
+ <refsect1 role="returnvalues">
+  &reftitle.returnvalues;
+  <para>
+   The backend database process ID.
+  </para>
+ </refsect1>
+ 
  <refsect1 role="examples">
   &reftitle.examples;
   <para>
http://cvs.php.net/diff.php/phpdoc/en/reference/pgsql/functions/pg-insert.xml?r1=1.15&r2=1.16&ty=u
Index: phpdoc/en/reference/pgsql/functions/pg-insert.xml
diff -u phpdoc/en/reference/pgsql/functions/pg-insert.xml:1.15 
phpdoc/en/reference/pgsql/functions/pg-insert.xml:1.16
--- phpdoc/en/reference/pgsql/functions/pg-insert.xml:1.15      Fri Jun 24 
05:11:45 2005
+++ phpdoc/en/reference/pgsql/functions/pg-insert.xml   Sun Jul  3 06:03:51 2005
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.15 $ -->
+<!-- $Revision: 1.16 $ -->
 <!-- splitted from ./en/functions/pgsql.xml, last change in rev 1.80 -->
 <refentry id='function.pg-insert'>
  <refnamediv>
@@ -21,18 +21,68 @@
   <para>
    <function>pg_insert</function> inserts the values of 
<parameter>assoc_array</parameter> 
    into the table specified by <parameter>table_name</parameter>.
-   <parameter>table_name</parameter> must at least have as many columns as 
-   <parameter>assoc_array</parameter> has elements. The fieldnames in
-   <parameter>table_name</parameter> must match the indices of 
<parameter>assoc_array</parameter>.
-   &return.success;
-   If <parameter>options</parameter> is specified, 
<function>pg_insert</function>
-   is applied to <parameter>assoc_array</parameter> with specified option.
-   If <constant>PGSQL_DML_STRING</constant> is part of the
-   <parameter>options</parameter> then query string is returned.
+   If <parameter>options</parameter> is
+   specified, <function>pg_convert</function> is applied
+   to <parameter>assoc_array</parameter> with the specified options.
   </para>
   &warn.experimental.func;
  </refsect1>
 
+<refsect1 role="parameters">
+  &reftitle.parameters;
+  <para>
+   <variablelist>
+    <varlistentry>
+     <term><parameter>connection</parameter></term>
+     <listitem>
+      <para>
+       PostgreSQL database connection resource.
+      </para>
+     </listitem>
+    </varlistentry>
+    <varlistentry>
+     <term><parameter>table_name</parameter></term>
+     <listitem>
+      <para>
+       Name of the table into which to insert rows.  The table 
<parameter>table_name</parameter> must at least 
+       have as many columns as <parameter>assoc_array</parameter> has elements.
+      </para>
+     </listitem>
+    </varlistentry>
+    <varlistentry>
+     <term><parameter>assoc_array</parameter></term>
+     <listitem>
+      <para>
+       An <type>array</type> whose keys are field names in the table 
<parameter>table_name</parameter>,
+       and whose values are the values of those fields that are to be inserted.
+      </para>
+     </listitem>
+    </varlistentry>
+    <varlistentry>
+     <term><parameter>options</parameter></term>
+     <listitem>
+      <para>
+       Any number of <constant>PGSQL_CONV_OPTS</constant>, 
+       <constant>PGSQL_DML_NO_CONV</constant>,
+       <constant>PGSQL_DML_EXEC</constant>,
+       <constant>PGSQL_DML_ASYNC</constant> or
+       <constant>PGSQL_DML_STRING</constant> combined. If 
<constant>PGSQL_DML_STRING</constant> is part of the
+       <parameter>options</parameter> then query string is returned.
+      </para>
+     </listitem>
+    </varlistentry>
+   </variablelist>
+  </para>
+ </refsect1>
+
+ <refsect1 role="returnvalues">
+  &reftitle.returnvalues;
+  <para>
+   &return.success;  Returns <type>string</type> if 
<constant>PGSQL_DML_STRING</constant> is passed
+   via <parameter>options</parameter>.
+  </para>
+ </refsect1>
+ 
  <refsect1 role="examples">
   &reftitle.examples;
   <para>
http://cvs.php.net/diff.php/phpdoc/en/reference/pgsql/functions/pg-update.xml?r1=1.13&r2=1.14&ty=u
Index: phpdoc/en/reference/pgsql/functions/pg-update.xml
diff -u phpdoc/en/reference/pgsql/functions/pg-update.xml:1.13 
phpdoc/en/reference/pgsql/functions/pg-update.xml:1.14
--- phpdoc/en/reference/pgsql/functions/pg-update.xml:1.13      Fri Mar 11 
11:03:26 2005
+++ phpdoc/en/reference/pgsql/functions/pg-update.xml   Sun Jul  3 06:03:51 2005
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.13 $ -->
+<!-- $Revision: 1.14 $ -->
 <!-- splitted from ./en/functions/pgsql.xml, last change in rev 1.80 -->
 <refentry id='function.pg-update'>
  <refnamediv>
@@ -29,6 +29,69 @@
   &warn.experimental.func;
  </refsect1>
 
+<refsect1 role="parameters">
+  &reftitle.parameters;
+  <para>
+   <variablelist>
+    <varlistentry>
+     <term><parameter>connection</parameter></term>
+     <listitem>
+      <para>
+       PostgreSQL database connection resource.
+      </para>
+     </listitem>
+    </varlistentry>
+    <varlistentry>
+     <term><parameter>table_name</parameter></term>
+     <listitem>
+      <para>
+       Name of the table into which to insert rows.  The table 
<parameter>table_name</parameter> must at least 
+       have as many columns as <parameter>condition</parameter> has elements.
+      </para>
+     </listitem>
+    </varlistentry>
+    <varlistentry>
+     <term><parameter>data</parameter></term>
+     <listitem>
+      <para>
+       An <type>array</type> whose keys are field names in the table 
<parameter>table_name</parameter>,
+       and whose values are what matched rows are to be updated to.
+      </para>
+     </listitem>
+    </varlistentry>
+    <varlistentry>
+     <term><parameter>condition</parameter></term>
+     <listitem>
+      <para>
+       An <type>array</type> whose keys are field names in the table 
<parameter>table_name</parameter>,
+       and whose values are the conditions that a row must meet to be updated.
+      </para>
+     </listitem>
+    </varlistentry>
+    <varlistentry>
+     <term><parameter>options</parameter></term>
+     <listitem>
+      <para>
+       Any number of <constant>PGSQL_CONV_OPTS</constant>, 
+       <constant>PGSQL_DML_NO_CONV</constant>,
+       <constant>PGSQL_DML_EXEC</constant> or
+       <constant>PGSQL_DML_STRING</constant> combined. If 
<constant>PGSQL_DML_STRING</constant> is part of the
+       <parameter>options</parameter> then query string is returned.
+      </para>
+     </listitem>
+    </varlistentry>
+   </variablelist>
+  </para>
+ </refsect1>
+
+ <refsect1 role="returnvalues">
+  &reftitle.returnvalues;
+  <para>
+   &return.success;  Returns <type>string</type> if 
<constant>PGSQL_DML_STRING</constant> is passed
+   via <parameter>options</parameter>.
+  </para>
+ </refsect1>
+ 
  <refsect1 role="examples">
   &reftitle.examples;
   <para>

Reply via email to