diff options
| author | Michael Meskes <meskes@postgresql.org> | 2000-04-05 15:51:28 +0000 |
|---|---|---|
| committer | Michael Meskes <meskes@postgresql.org> | 2000-04-05 15:51:28 +0000 |
| commit | a7b1ff6619413398d7e69b0888b6672d6b9413a6 (patch) | |
| tree | 60e24eed1e36610618df44c251fb5f2181a28937 /src/interfaces/ecpg/test | |
| parent | 6995c5fbad1f2e1e4e9dacbaf76ed2a235feb07a (diff) | |
| download | postgresql-a7b1ff6619413398d7e69b0888b6672d6b9413a6.tar.gz | |
*** empty log message ***
Diffstat (limited to 'src/interfaces/ecpg/test')
| -rw-r--r-- | src/interfaces/ecpg/test/test4.pgc | 15 |
1 files changed, 8 insertions, 7 deletions
diff --git a/src/interfaces/ecpg/test/test4.pgc b/src/interfaces/ecpg/test/test4.pgc index 10312b6944..0ac00008e4 100644 --- a/src/interfaces/ecpg/test/test4.pgc +++ b/src/interfaces/ecpg/test/test4.pgc @@ -14,6 +14,7 @@ EXEC SQL BEGIN DECLARE SECTION; char text[10] = "klmnopqrst"; char *t = "uvwxyz1234"; double f; + bool b = true; EXEC SQL END DECLARE SECTION; FILE *dbgs; @@ -28,24 +29,24 @@ EXEC SQL END DECLARE SECTION; EXEC SQL BEGIN WORK; - EXEC SQL CREATE TABLE test (f float, i int, a int[10], text char(10)); + EXEC SQL CREATE TABLE test (f float, i int, a int[10], text char(10), b bool); - EXEC SQL INSERT INTO test(f,i,a,text) VALUES(404.90,1,'{0,1,2,3,4,5,6,7,8,9}','abcdefghij'); + EXEC SQL INSERT INTO test(f,i,a,text,b) VALUES(404.90,1,'{0,1,2,3,4,5,6,7,8,9}','abcdefghij', 'f'); - EXEC SQL INSERT INTO test(f,i,a,text) VALUES(140787.0,2,:a,:text); + EXEC SQL INSERT INTO test(f,i,a,text,b) VALUES(140787.0,2,:a,:text,'t'); - EXEC SQL INSERT INTO test(f,i,a,text) VALUES(14.07,:did,:a,:t); + EXEC SQL INSERT INTO test(f,i,a,text,b) VALUES(14.07,:did,:a,:t,:b); EXEC SQL COMMIT; EXEC SQL BEGIN WORK; - EXEC SQL SELECT f,text - INTO :f,:text + EXEC SQL SELECT f,text,b + INTO :f,:text,:b FROM test WHERE i = 1; - printf("Found f=%f text=%10.10s\n", f, text); + printf("Found f=%f text=%10.10s b=%d\n", f, text, b); f=14.07; EXEC SQL SELECT a,text |
