The following bug has been logged on the website:
Bug reference: 13557
Logged by: yang
Email address: haiyi_yang@163.com
PostgreSQL version: 9.4.0
Operating system: Linux 6
Description:
Step:
1. In postgres database create a table and insert a record.
(1). create table ff (a char(20), b numeric(38,0), c date, d char(20));
(2). insert into ff values(NULL, 123, DATE'2011-02-03 04:05:06', 'AAAAAA');
2. Edit ESQL program, use ecpg compile.
EXEC SQL BEGIN DECLARE SECTION;
char cv[64];
char vcv[64];
char ncv[64];
double bind;
EXEC SQL END DECLARE SECTIEXEC SQL CONNECT TO
'postgres@192.168.2.119:266666' USER 'postgre' IDENTIFIED BY '123456';
EXEC SQL SELECT a, b, c, d INTO :cv, :bind, :vcv, :ncv FROM ff where b=123;
printf("a = %s, b = %lf, c = %s, d = %s\n", cv, bind, vcv, ncv);
EXEC SQL DISCONNECT ALL;
Output:
a = , b = 0.000000, c = , d =