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