From: | "MauMau" <maumau307(at)gmail(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | [9.3 doc fix] ECPG VAR command does not describe the actual specification |
Date: | 2013-06-27 11:53:24 |
Message-ID: | 7B77843070A64FA281BC9E8F07C0B92A@maumau |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
Attachment | Content-Type | Size |
---|---|---|
ecpg_var_doc.patch | application/octet-stream | 1.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2013-06-27 12:16:51 | Re: Min value for port |
Previous Message | Dimitri Fontaine | 2013-06-27 11:34:44 | Re: in-catalog Extension Scripts and Control parameters (templates?) |