summaryrefslogtreecommitdiff
path: root/src/interfaces/ecpg/test
diff options
context:
space:
mode:
authorMichael Meskes <meskes@postgresql.org>2000-01-07 08:01:18 +0000
committerMichael Meskes <meskes@postgresql.org>2000-01-07 08:01:18 +0000
commit33d71e3037da7ddc85e71bc43d605244473bd7ff (patch)
tree8b2c3d520f9aed286cd6165b331c134b12297928 /src/interfaces/ecpg/test
parent5633e22e2cca0fb8cd3a2664a50b269d862e4f51 (diff)
*** empty log message ***
Diffstat (limited to 'src/interfaces/ecpg/test')
-rw-r--r--src/interfaces/ecpg/test/test1.pgc2
-rw-r--r--src/interfaces/ecpg/test/test3.pgc6
2 files changed, 4 insertions, 4 deletions
diff --git a/src/interfaces/ecpg/test/test1.pgc b/src/interfaces/ecpg/test/test1.pgc
index 6ace9d57624..be3a2fc61ed 100644
--- a/src/interfaces/ecpg/test/test1.pgc
+++ b/src/interfaces/ecpg/test/test1.pgc
@@ -82,7 +82,7 @@ exec sql end declare section;
for (i=0, j=sqlca.sqlerrd[2]; i<j; i++)
printf("name[%d]=%8.8s\tamount[%d]=%d\tletter[%d]=%c\n", i, name[i], i, amount[i],i, letter[i][0]);
- exec sql at pm select name, amount, letter into :name, :amount, :letter from "Test";
+ exec sql at pm select * into :name, :amount, :letter from "Test";
for (i=0, j=sqlca.sqlerrd[2]; i<j; i++)
printf("name[%d]=%8.8s\tamount[%d]=%d\tletter[%d]=%c\n", i, name[i], i, amount[i],i, letter[i][0]);
diff --git a/src/interfaces/ecpg/test/test3.pgc b/src/interfaces/ecpg/test/test3.pgc
index 12e3e07dd21..12a7e3f9e27 100644
--- a/src/interfaces/ecpg/test/test3.pgc
+++ b/src/interfaces/ecpg/test/test3.pgc
@@ -19,7 +19,7 @@ exec sql begin declare section;
int ind_children;
str *married = NULL;
char *wifesname="Petra";
- char *query="select name, born, age, married, children from meskes where name = :var1";
+ char *query="select * from meskes where name = :var1";
exec sql end declare section;
exec sql declare cur cursor for
@@ -41,8 +41,8 @@ exec sql end declare section;
exec sql insert into meskes(name, married, children) values (:wifesname, '19900404', 3);
exec sql insert into meskes(name, born, age, married, children) values ('Michael', 19660117, 33, '19900404', 3);
exec sql insert into meskes(name, born, age) values ('Carsten', 19910103, 8);
- exec sql insert into meskes(name, born, age) values ('Marc', 19930907, 5);
- exec sql insert into meskes(name, born, age) values ('Chris', 19970923, 1);
+ exec sql insert into meskes(name, born, age) values ('Marc', 19930907, 6);
+ exec sql insert into meskes(name, born, age) values ('Chris', 19970923, 2);
strcpy(msg, "commit");
exec sql commit;