# E121-10: FETCH statement: implicit NEXT

onlyif Postgres
onlyif Postgres
statement ok
CREATE TABLE TABLE_E121_10_01_011 ( A INT );
CREATE TABLE TABLE_E121_10_01_012 ( A INT );
DECLARE CUR_E121_10_01_01 CURSOR FOR SELECT A FROM TABLE_E121_10_01_011;
OPEN CUR_E121_10_01_01;
FETCH ABSOLUTE 2 FROM CUR_E121_10_01_01 INTO TABLE_E121_10_01_012

onlyif Postgres
onlyif Postgres
statement ok
CREATE TABLE TABLE_E121_10_01_021 ( A INT );
CREATE TABLE TABLE_E121_10_01_022 ( A INT );
DECLARE CUR_E121_10_01_02 CURSOR FOR SELECT A FROM TABLE_E121_10_01_021;
OPEN CUR_E121_10_01_02;
FETCH CUR_E121_10_01_02 INTO TABLE_E121_10_01_022

onlyif Postgres
onlyif Postgres
statement ok
CREATE TABLE TABLE_E121_10_01_031 ( A INT );
CREATE TABLE TABLE_E121_10_01_032 ( A INT );
DECLARE CUR_E121_10_01_03 CURSOR FOR SELECT A FROM TABLE_E121_10_01_031;
OPEN CUR_E121_10_01_03;
FETCH FIRST FROM CUR_E121_10_01_03 INTO TABLE_E121_10_01_032

onlyif Postgres
onlyif Postgres
statement ok
CREATE TABLE TABLE_E121_10_01_041 ( A INT );
CREATE TABLE TABLE_E121_10_01_042 ( A INT );
DECLARE CUR_E121_10_01_04 CURSOR FOR SELECT A FROM TABLE_E121_10_01_041;
OPEN CUR_E121_10_01_04;
FETCH FROM CUR_E121_10_01_04 INTO TABLE_E121_10_01_042

onlyif Postgres
onlyif Postgres
statement ok
CREATE TABLE TABLE_E121_10_01_051 ( A INT );
CREATE TABLE TABLE_E121_10_01_052 ( A INT );
DECLARE CUR_E121_10_01_05 CURSOR FOR SELECT A FROM TABLE_E121_10_01_051;
OPEN CUR_E121_10_01_05;
FETCH LAST FROM CUR_E121_10_01_05 INTO TABLE_E121_10_01_052

onlyif Postgres
onlyif Postgres
statement ok
CREATE TABLE TABLE_E121_10_01_061 ( A INT );
CREATE TABLE TABLE_E121_10_01_062 ( A INT );
DECLARE CUR_E121_10_01_06 CURSOR FOR SELECT A FROM TABLE_E121_10_01_061;
OPEN CUR_E121_10_01_06;
FETCH NEXT FROM CUR_E121_10_01_06 INTO TABLE_E121_10_01_062

onlyif Postgres
onlyif Postgres
statement ok
CREATE TABLE TABLE_E121_10_01_071 ( A INT );
CREATE TABLE TABLE_E121_10_01_072 ( A INT );
DECLARE CUR_E121_10_01_07 CURSOR FOR SELECT A FROM TABLE_E121_10_01_071;
OPEN CUR_E121_10_01_07;
FETCH PRIOR FROM CUR_E121_10_01_07 INTO TABLE_E121_10_01_072

onlyif Postgres
onlyif Postgres
statement ok
CREATE TABLE TABLE_E121_10_01_081 ( A INT );
CREATE TABLE TABLE_E121_10_01_082 ( A INT );
DECLARE CUR_E121_10_01_08 CURSOR FOR SELECT A FROM TABLE_E121_10_01_081;
OPEN CUR_E121_10_01_08;
FETCH RELATIVE 2 FROM CUR_E121_10_01_08 INTO TABLE_E121_10_01_082
