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

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

Responses

Browse pgsql-hackers by date

  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?)