summaryrefslogtreecommitdiff
path: root/src/interfaces/ecpg/test/sql/fetch.pgc
diff options
context:
space:
mode:
authorMichael Meskes <meskes@postgresql.org>2007-08-14 10:01:54 +0000
committerMichael Meskes <meskes@postgresql.org>2007-08-14 10:01:54 +0000
commit635a0b9a8640bb7f2944a3f77ddc370f8dd7b010 (patch)
treed54146b2416fecd2a544f3bf786108079b879cfc /src/interfaces/ecpg/test/sql/fetch.pgc
parentb83bd31bd953b6daa22bcbdaee5ade2a27ec7324 (diff)
- Finished major rewrite to use new protocol version
- Really prepare statements - Added more regression tests - Added auto-prepare mode - Use '$n' for positional variables, '?' is still possible via ecpg option - Cleaned up the sources a little bit
Diffstat (limited to 'src/interfaces/ecpg/test/sql/fetch.pgc')
-rw-r--r--src/interfaces/ecpg/test/sql/fetch.pgc4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/interfaces/ecpg/test/sql/fetch.pgc b/src/interfaces/ecpg/test/sql/fetch.pgc
index 936a4f8cd2d..a65d393748e 100644
--- a/src/interfaces/ecpg/test/sql/fetch.pgc
+++ b/src/interfaces/ecpg/test/sql/fetch.pgc
@@ -7,7 +7,7 @@ EXEC SQL INCLUDE ../regression;
int main(int argc, char* argv[]) {
EXEC SQL BEGIN DECLARE SECTION;
char str[25];
- int i, how_many = 1;
+ int i;
EXEC SQL END DECLARE SECTION;
ECPGdebug(1, stderr);
@@ -36,7 +36,7 @@ int main(int argc, char* argv[]) {
EXEC SQL WHENEVER NOT FOUND CONTINUE;
EXEC SQL MOVE BACKWARD 2 IN C;
- EXEC SQL FETCH :how_many IN C INTO :i, :str;
+ EXEC SQL FETCH 1 IN C INTO :i, :str;
printf("%d: %s\n", i, str);
EXEC SQL CLOSE C;