summaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
authorNeil Conway2007-04-28 23:54:59 +0000
committerNeil Conway2007-04-28 23:54:59 +0000
commitf2321a3f37b74b42d20ec787afb7ee4a29655a3e (patch)
tree7bd72dce472a841133f9082104c5b0f26860c492 /src/test
parentbbbe825f5f46d7ead60502f43d3b414719a41aa5 (diff)
Add support for IN as alternative to FROM in PL/PgSQL's FETCH statement,
for consistency with the backend's FETCH command. Patch from Pavel Stehule, reviewed by Neil Conway.
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/plpgsql.out2
-rw-r--r--src/test/regress/sql/plpgsql.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/plpgsql.out b/src/test/regress/expected/plpgsql.out
index 02ef15c6770..669077edee7 100644
--- a/src/test/regress/expected/plpgsql.out
+++ b/src/test/regress/expected/plpgsql.out
@@ -2245,7 +2245,7 @@ select refcursor_test1('test1');
test1
(1 row)
-fetch next from test1;
+fetch next in test1;
a
---
5
diff --git a/src/test/regress/sql/plpgsql.sql b/src/test/regress/sql/plpgsql.sql
index 1cc9df2de2d..33637d9e798 100644
--- a/src/test/regress/sql/plpgsql.sql
+++ b/src/test/regress/sql/plpgsql.sql
@@ -1918,7 +1918,7 @@ $$ language plpgsql;
begin;
select refcursor_test1('test1');
-fetch next from test1;
+fetch next in test1;
select refcursor_test1('test2');
fetch all from test2;