diff options
author | Michael Meskes <meskes@postgresql.org> | 2000-01-07 08:01:18 +0000 |
---|---|---|
committer | Michael Meskes <meskes@postgresql.org> | 2000-01-07 08:01:18 +0000 |
commit | 33d71e3037da7ddc85e71bc43d605244473bd7ff (patch) | |
tree | 8b2c3d520f9aed286cd6165b331c134b12297928 /src/interfaces/ecpg/test | |
parent | 5633e22e2cca0fb8cd3a2664a50b269d862e4f51 (diff) |
*** empty log message ***
Diffstat (limited to 'src/interfaces/ecpg/test')
-rw-r--r-- | src/interfaces/ecpg/test/test1.pgc | 2 | ||||
-rw-r--r-- | src/interfaces/ecpg/test/test3.pgc | 6 |
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; |