postgres.git / summary / log / commit / refs

commit    703bc145f773835637a8a01f2fe4cfb864835bb1
Author:   Michael Meskes <meskes@postgresql.org>
Date:     Thu Jun 27 14:00:32 2013 +0000
First released in: 9.1.10, 9.2.5, 9.3.0

    Fixed incorrect description of EXEC SQL VAR command.
    
    Thanks to MauMau <maumau307@gmail.com> for finding and fixing this.


 doc/src/sgml/ecpg.sgml | 12 +++++++-----
 1 file changed, 7 insertions(+), 5 deletions(-)

diff --git a/doc/src/sgml/ecpg.sgml b/doc/src/sgml/ecpg.sgml
index 17800fc72fa..4ffffe96b37 100644
--- a/doc/src/sgml/ecpg.sgml
+++ b/doc/src/sgml/ecpg.sgml
@@ -7675,9 +7675,9 @@ VAR <replaceable>varname</replaceable> IS <replaceable>ctype</replaceable>
     <title>Description</title>
 
     <para>
-     The <command>VAR</command> command defines a host variable.  It
-     is equivalent to an ordinary C variable definition inside a
-     declare section.
+     The <command>VAR</command> command assigns a new C data type
+     to a host variable.  The host variable must be previously
+     declared in a declare section.
     </para>
    </refsect1>
 
@@ -7709,8 +7709,10 @@ VAR <replaceable>varname</replaceable> IS <replaceable>ctype</replaceable>
     <title>Examples</title>
 
 <programlisting>
-EXEC SQL VAR vc IS VARCHAR[10];
-EXEC SQL VAR boolvar IS bool;
+Exec sql begin declare section;
+short a;
+exec sql end declare section;
+EXEC SQL VAR a IS int;
 </programlisting>
    </refsect1>
 


[parent: ad4c625ee464]