[HACKERS] [9.3 doc fix] ECPG VAR command does not describe the actual specification

[MauMau]

Hello,





http://www.postgresql.org/docs/9.3/static/ecpg-sql-var.html

According to the description,

EXEC SQL VAR a IS int;

is equivalent to:

Exec sql begin declare section;
int a;
exec sql end declare section;

However, "ecpg var.pgc" produces the error:

var.pgc:1: ERROR: variable "a" is not declared



--------------------------------------------------
Exec sql begin declare section;
short a;
exec sql end declare section;
EXEC SQL VAR a IS int;

EXEC SQL SELECT c INTO :a FROM mytable;
--------------------------------------------------




Regards
MauMau

Looking around the 9.3 doc, I found a small, but not-insignificant error in the documentation. On the other hand, the following code can be preprocessed correctly, treating the host variable "a" as an int type. The attached patch fixes this documentation error. This is not specific to 9.3, so it needs to be backported. Could you commit this?

ecpg_var_doc.patch
Description: Binary data

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers