1- <!-- $PostgreSQL: pgsql/doc/src/sgml/ecpg.sgml,v 1.75 2006/09/21 09:10:27 meskes Exp $ -->
1+ <!-- $PostgreSQL: pgsql/doc/src/sgml/ecpg.sgml,v 1.76 2006/09/22 15:22:04 tgl Exp $ -->
22
33<chapter id="ecpg">
44 <title><application>ECPG</application> - Embedded <acronym>SQL</acronym> in C</title>
@@ -1137,7 +1137,7 @@ date PGTYPESdate_from_asc(char *str, char **endptr);
11371137 <para>
11381138 The following input formats are allowed:
11391139 <table>
1140- <title>Valid input formats for <function>PGTYPESdate_from_asc</function>.
1140+ <title>Valid input formats for <function>PGTYPESdate_from_asc</function></title>
11411141 <tgroup cols="2">
11421142 <thead>
11431143 <row>
@@ -1394,7 +1394,7 @@ int PGTYPESdate_fmt_asc(date dDate, char *fmtstring, char *outbuf);
13941394you an idea of how to use this function. All output lines are based on
13951395the same date: November, 23rd, 1959.
13961396 <table>
1397- <title>Valid input formats for <function>PGTYPESdate_fmt_asc</function>.
1397+ <title>Valid input formats for <function>PGTYPESdate_fmt_asc</function></title>
13981398 <tgroup cols="2">
13991399 <thead>
14001400 <row>
@@ -1484,7 +1484,7 @@ int PGTYPESdate_defmt_asc(date *d, char *fmt, char *str);
14841484The following table indicates a few possible formats. This will give
14851485you an idea of how to use this function.
14861486 <table>
1487- <title>Valid input formats for <function>rdefmtdate</function>.
1487+ <title>Valid input formats for <function>rdefmtdate</function></title>
14881488 <tgroup cols="2">
14891489 <thead>
14901490 <row>
@@ -1612,7 +1612,7 @@ timestamp PGTYPEStimestamp_from_asc(char *str, char **endptr);
16121612 <para>
16131613 The following table contains a few examples for input strings:
16141614 <table>
1615- <title>Valid input formats for <function>PGTYPEStimestamp_from_asc</function>.
1615+ <title>Valid input formats for <function>PGTYPEStimestamp_from_asc</function></title>
16161616 <tgroup cols="2">
16171617 <thead>
16181618 <row>
@@ -2272,7 +2272,6 @@ void PGTYPESdecimal_free(decimal *var);
22722272 </para>
22732273 </listitem>
22742274 </varlistentry>
2275- <variablelist>
22762275
22772276 <varlistentry>
22782277 <term><literal>PGTYPES_DATE_BAD_DATE</literal></term>
@@ -2282,7 +2281,6 @@ void PGTYPESdecimal_free(decimal *var);
22822281 </para>
22832282 </listitem>
22842283 </varlistentry>
2285- <variablelist>
22862284
22872285 <varlistentry>
22882286 <term><literal>PGTYPES_DATE_ERR_EARGS</literal></term>
@@ -2292,7 +2290,6 @@ void PGTYPESdecimal_free(decimal *var);
22922290 </para>
22932291 </listitem>
22942292 </varlistentry>
2295- <variablelist>
22962293
22972294 <varlistentry>
22982295 <term><literal>PGTYPES_DATE_ERR_ENOSHORTDATE</literal></term>
@@ -2302,7 +2299,6 @@ void PGTYPESdecimal_free(decimal *var);
23022299 </para>
23032300 </listitem>
23042301 </varlistentry>
2305- <variablelist>
23062302
23072303 <varlistentry>
23082304 <term><literal>PGTYPES_INTVL_BAD_INTERVAL</literal></term>
@@ -2312,7 +2308,6 @@ void PGTYPESdecimal_free(decimal *var);
23122308 </para>
23132309 </listitem>
23142310 </varlistentry>
2315- <variablelist>
23162311
23172312 <varlistentry>
23182313 <term><literal>PGTYPES_DATE_ERR_ENOTDMY</literal></term>
@@ -2322,7 +2317,6 @@ void PGTYPESdecimal_free(decimal *var);
23222317 </para>
23232318 </listitem>
23242319 </varlistentry>
2325- <variablelist>
23262320
23272321 <varlistentry>
23282322 <term><literal>PGTYPES_DATE_BAD_DAY</literal></term>
@@ -2332,7 +2326,6 @@ void PGTYPESdecimal_free(decimal *var);
23322326 </para>
23332327 </listitem>
23342328 </varlistentry>
2335- <variablelist>
23362329
23372330 <varlistentry>
23382331 <term><literal>PGTYPES_DATE_BAD_MONTH</literal></term>
@@ -2342,7 +2335,6 @@ void PGTYPESdecimal_free(decimal *var);
23422335 </para>
23432336 </listitem>
23442337 </varlistentry>
2345- <variablelist>
23462338
23472339 <varlistentry>
23482340 <term><literal>PGTYPES_TS_BAD_TIMESTAMP</literal></term>
@@ -2415,12 +2407,12 @@ void PGTYPESdecimal_free(decimal *var);
24152407 of ecpg. pgtypeslib maps SQL data types to data types within the C host
24162408 program and most of the additional functions of the Informix compatibility
24172409 mode allow you to operate on those C host program types. Note however that
2418- theextend of the compatibility is limited. It does not try to copy Informix
2419- behaviour but it allows you to do more or less the same operations and gives
2410+ theextent of the compatibility is limited. It does not try to copy Informix
2411+ behaviour; it allows you to do more or less the same operations and gives
24202412 you functions that have the same name and the same basic behavior but it is
24212413 no drop-in replacement if you are using Informix at the moment. Moreover,
24222414 some of the data types are different. For example,
2423- <productname>PostgreSQL's<productname> datetime and interval types do not
2415+ <productname>PostgreSQL's</ productname> datetime and interval types do not
24242416 know about ranges like for example <literal>YEAR TO MINUTE</> so you won't
24252417 find support in ecpg for that either.
24262418 </para>
@@ -2437,11 +2429,12 @@ void PGTYPESdecimal_free(decimal *var);
24372429synonym for ecpg's <literal>DISCONNECT CURRENT</>.
24382430<programlisting>
24392431 $CLOSE DATABASE; /* close the current connection */
2440- EXEC SQLClOSE DATABASE;
2432+ EXEC SQLCLOSE DATABASE;
24412433</programlisting>
24422434 </para>
24432435 </listitem>
24442436 </varlistentry>
2437+ </variablelist>
24452438 </para>
24462439 </sect2>
24472440
@@ -3452,6 +3445,8 @@ int rsetnull(int t, char *ptr);
34523445 </para>
34533446 </listitem>
34543447 </itemizedlist>
3448+ </para>
3449+
34553450 <para>
34563451 Here is an example of a call to this function:
34573452<programlisting>
@@ -4619,6 +4614,7 @@ EXEC SQL UPDATE Tbl SET col = MYNUMBER;
46194614 </listitem>
46204615 </varlistentry>
46214616 </variablelist>
4617+ </para>
46224618
46234619 <para>
46244620 Example: