conni Mon Jun 6 08:28:05 2005 EDT
Modified files:
/phpdoc/en/reference/pgsql/functions pg-convert.xml
Log:
corrected description and added a note
http://cvs.php.net/diff.php/phpdoc/en/reference/pgsql/functions/pg-convert.xml?r1=1.11&r2=1.12&ty=u
Index: phpdoc/en/reference/pgsql/functions/pg-convert.xml
diff -u phpdoc/en/reference/pgsql/functions/pg-convert.xml:1.11
phpdoc/en/reference/pgsql/functions/pg-convert.xml:1.12
--- phpdoc/en/reference/pgsql/functions/pg-convert.xml:1.11 Sat May 14
08:56:54 2005
+++ phpdoc/en/reference/pgsql/functions/pg-convert.xml Mon Jun 6 08:28:05 2005
@@ -1,11 +1,11 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.11 $ -->
+<!-- $Revision: 1.12 $ -->
<!-- splitted from ./en/functions/pgsql.xml, last change in rev 1.80 -->
<refentry id='function.pg-convert'>
<refnamediv>
<refname>pg_convert</refname>
<refpurpose>
- Convert associative array value into suitable for SQL statement
+ Convert associative array values into suitable for SQL statement
</refpurpose>
</refnamediv>
@@ -23,11 +23,19 @@
<parameter>assoc_array</parameter> into suitable values for use in a SQL
statement. Precondition for <function>pg_convert</function> is the existence
of a table <parameter>table_name</parameter> which has at least as many
columns
- as <parameter>assoc_array</parameter> has elements. The fieldnames as well
as
- the fieldvalues in <parameter>table_name</parameter> must match the indices
and
- values of <parameter>assoc_array</parameter>. Returns an array with the
converted
- values on success, &false; otherwise.
+ as <parameter>assoc_array</parameter> has elements. The fieldnames in
+ <parameter>table_name</parameter> must match the indices in
<parameter>assoc_array</parameter>
+ and the corresponding datatypes must be compatible. Returns an array with
+ the converted values on success, &false; otherwise.
</para>
+ <note>
+ <para>
+ If there are boolean fields in <parameter>table_name</parameter> don't use
the
+ constant TRUE in <parameter>assoc_array</parameter>. It will be
converted to the
+ string 'TRUE' which is no valid entry for boolean fields in PostgreSQL.
Use one
+ of t, true, 1, y, yes instead.
+ </para>
+ </note>
&warn.experimental.func;
</refsect1>
