diff options
| author | Michael Meskes <meskes@postgresql.org> | 2013-11-26 17:15:15 +0100 |
|---|---|---|
| committer | Michael Meskes <meskes@postgresql.org> | 2013-11-26 17:42:32 +0100 |
| commit | 1ec4c56e76714d3894cfc301212ec98674720e3b (patch) | |
| tree | a00830507b4a152d3afbcdceb02fd1980ab7397a /src/interfaces/ecpg/test/sql/fetch.pgc | |
| parent | db58e8ff7cec9a14418d6dccd33bbe186d10c1f4 (diff) | |
ECPG: Add EXEC SQL CLOSE C to the tests.
Patch by Boszormenyi Zoltan <zb@cybertec.at>
Diffstat (limited to 'src/interfaces/ecpg/test/sql/fetch.pgc')
| -rw-r--r-- | src/interfaces/ecpg/test/sql/fetch.pgc | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/interfaces/ecpg/test/sql/fetch.pgc b/src/interfaces/ecpg/test/sql/fetch.pgc index e280d27f4e5..aade678efbe 100644 --- a/src/interfaces/ecpg/test/sql/fetch.pgc +++ b/src/interfaces/ecpg/test/sql/fetch.pgc @@ -39,6 +39,8 @@ int main() { EXEC SQL FETCH :count IN C INTO :i, :str; printf("%d: %s\n", i, str); + EXEC SQL CLOSE C; + EXEC SQL DECLARE D CURSOR FOR SELECT * FROM My_Table WHERE Item1 = $1; EXEC SQL OPEN D using 1; |