portals.out

关系型数据库 Postgresql 6.5.2

QUERY: BEGIN;
QUERY: DECLARE foo1 CURSOR FOR SELECT * FROM tenk1;
QUERY: DECLARE foo2 CURSOR FOR SELECT * FROM tenk2;
QUERY: DECLARE foo3 CURSOR FOR SELECT * FROM tenk1;
QUERY: DECLARE foo4 CURSOR FOR SELECT * FROM tenk2;
QUERY: DECLARE foo5 CURSOR FOR SELECT * FROM tenk1;
QUERY: DECLARE foo6 CURSOR FOR SELECT * FROM tenk2;
QUERY: DECLARE foo7 CURSOR FOR SELECT * FROM tenk1;
QUERY: DECLARE foo8 CURSOR FOR SELECT * FROM tenk2;
QUERY: DECLARE foo9 CURSOR FOR SELECT * FROM tenk1;
QUERY: DECLARE foo10 CURSOR FOR SELECT * FROM tenk2;
QUERY: DECLARE foo11 CURSOR FOR SELECT * FROM tenk1;
QUERY: DECLARE foo12 CURSOR FOR SELECT * FROM tenk2;
QUERY: DECLARE foo13 CURSOR FOR SELECT * FROM tenk1;
QUERY: DECLARE foo14 CURSOR FOR SELECT * FROM tenk2;
QUERY: DECLARE foo15 CURSOR FOR SELECT * FROM tenk1;
QUERY: DECLARE foo16 CURSOR FOR SELECT * FROM tenk2;
QUERY: DECLARE foo17 CURSOR FOR SELECT * FROM tenk1;
QUERY: DECLARE foo18 CURSOR FOR SELECT * FROM tenk2;
QUERY: DECLARE foo19 CURSOR FOR SELECT * FROM tenk1;
QUERY: DECLARE foo20 CURSOR FOR SELECT * FROM tenk2;
QUERY: DECLARE foo21 CURSOR FOR SELECT * FROM tenk1;
QUERY: DECLARE foo22 CURSOR FOR SELECT * FROM tenk2;
QUERY: DECLARE foo23 CURSOR FOR SELECT * FROM tenk1;
QUERY: FETCH 1 in foo1;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
   8800|      0|  0|   0|  0|     0|      0|     800|        800|     3800|    8800|  0|   1|MAAAAA  |AAAAAA  |AAAAxx 
(1 row)

QUERY: FETCH 2 in foo2;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
   8800|      0|  0|   0|  0|     0|      0|     800|        800|     3800|    8800|  0|   1|MAAAAA  |AAAAAA  |AAAAxx 
   1891|      1|  1|   3|  1|    11|     91|     891|       1891|     1891|    1891|182| 183|TUAAAA  |BAAAAA  |HHHHxx 
(2 rows)

QUERY: FETCH 3 in foo3;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
   8800|      0|  0|   0|  0|     0|      0|     800|        800|     3800|    8800|  0|   1|MAAAAA  |AAAAAA  |AAAAxx 
   1891|      1|  1|   3|  1|    11|     91|     891|       1891|     1891|    1891|182| 183|TUAAAA  |BAAAAA  |HHHHxx 
   3420|      2|  0|   0|  0|     0|     20|     420|       1420|     3420|    3420| 40|  41|OBAAAA  |CAAAAA  |OOOOxx 
(3 rows)

QUERY: FETCH 4 in foo4;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
   8800|      0|  0|   0|  0|     0|      0|     800|        800|     3800|    8800|  0|   1|MAAAAA  |AAAAAA  |AAAAxx 
   1891|      1|  1|   3|  1|    11|     91|     891|       1891|     1891|    1891|182| 183|TUAAAA  |BAAAAA  |HHHHxx 
   3420|      2|  0|   0|  0|     0|     20|     420|       1420|     3420|    3420| 40|  41|OBAAAA  |CAAAAA  |OOOOxx 
   9850|      3|  0|   2|  0|    10|     50|     850|       1850|     4850|    9850|100| 101|WOAAAA  |DAAAAA  |VVVVxx 
(4 rows)

QUERY: FETCH 5 in foo5;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
   8800|      0|  0|   0|  0|     0|      0|     800|        800|     3800|    8800|  0|   1|MAAAAA  |AAAAAA  |AAAAxx 
   1891|      1|  1|   3|  1|    11|     91|     891|       1891|     1891|    1891|182| 183|TUAAAA  |BAAAAA  |HHHHxx 
   3420|      2|  0|   0|  0|     0|     20|     420|       1420|     3420|    3420| 40|  41|OBAAAA  |CAAAAA  |OOOOxx 
   9850|      3|  0|   2|  0|    10|     50|     850|       1850|     4850|    9850|100| 101|WOAAAA  |DAAAAA  |VVVVxx 
   7164|      4|  0|   0|  4|     4|     64|     164|       1164|     2164|    7164|128| 129|OPAAAA  |EAAAAA  |AAAAxx 
(5 rows)

QUERY: FETCH 6 in foo6;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
   8800|      0|  0|   0|  0|     0|      0|     800|        800|     3800|    8800|  0|   1|MAAAAA  |AAAAAA  |AAAAxx 
   1891|      1|  1|   3|  1|    11|     91|     891|       1891|     1891|    1891|182| 183|TUAAAA  |BAAAAA  |HHHHxx 
   3420|      2|  0|   0|  0|     0|     20|     420|       1420|     3420|    3420| 40|  41|OBAAAA  |CAAAAA  |OOOOxx 
   9850|      3|  0|   2|  0|    10|     50|     850|       1850|     4850|    9850|100| 101|WOAAAA  |DAAAAA  |VVVVxx 
   7164|      4|  0|   0|  4|     4|     64|     164|       1164|     2164|    7164|128| 129|OPAAAA  |EAAAAA  |AAAAxx 
   8009|      5|  1|   1|  9|     9|      9|       9|          9|     3009|    8009| 18|  19|BWAAAA  |FAAAAA  |HHHHxx 
(6 rows)

QUERY: FETCH 7 in foo7;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
   8800|      0|  0|   0|  0|     0|      0|     800|        800|     3800|    8800|  0|   1|MAAAAA  |AAAAAA  |AAAAxx 
   1891|      1|  1|   3|  1|    11|     91|     891|       1891|     1891|    1891|182| 183|TUAAAA  |BAAAAA  |HHHHxx 
   3420|      2|  0|   0|  0|     0|     20|     420|       1420|     3420|    3420| 40|  41|OBAAAA  |CAAAAA  |OOOOxx 
   9850|      3|  0|   2|  0|    10|     50|     850|       1850|     4850|    9850|100| 101|WOAAAA  |DAAAAA  |VVVVxx 
   7164|      4|  0|   0|  4|     4|     64|     164|       1164|     2164|    7164|128| 129|OPAAAA  |EAAAAA  |AAAAxx 
   8009|      5|  1|   1|  9|     9|      9|       9|          9|     3009|    8009| 18|  19|BWAAAA  |FAAAAA  |HHHHxx 
   5057|      6|  1|   1|  7|    17|     57|      57|       1057|       57|    5057|114| 115|NMAAAA  |GAAAAA  |OOOOxx 
(7 rows)

QUERY: FETCH 8 in foo8;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
   8800|      0|  0|   0|  0|     0|      0|     800|        800|     3800|    8800|  0|   1|MAAAAA  |AAAAAA  |AAAAxx 
   1891|      1|  1|   3|  1|    11|     91|     891|       1891|     1891|    1891|182| 183|TUAAAA  |BAAAAA  |HHHHxx 
   3420|      2|  0|   0|  0|     0|     20|     420|       1420|     3420|    3420| 40|  41|OBAAAA  |CAAAAA  |OOOOxx 
   9850|      3|  0|   2|  0|    10|     50|     850|       1850|     4850|    9850|100| 101|WOAAAA  |DAAAAA  |VVVVxx 
   7164|      4|  0|   0|  4|     4|     64|     164|       1164|     2164|    7164|128| 129|OPAAAA  |EAAAAA  |AAAAxx 
   8009|      5|  1|   1|  9|     9|      9|       9|          9|     3009|    8009| 18|  19|BWAAAA  |FAAAAA  |HHHHxx 
   5057|      6|  1|   1|  7|    17|     57|      57|       1057|       57|    5057|114| 115|NMAAAA  |GAAAAA  |OOOOxx 
   6701|      7|  1|   1|  1|     1|      1|     701|        701|     1701|    6701|  2|   3|TXAAAA  |HAAAAA  |VVVVxx 
(8 rows)

QUERY: FETCH 9 in foo9;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
   8800|      0|  0|   0|  0|     0|      0|     800|        800|     3800|    8800|  0|   1|MAAAAA  |AAAAAA  |AAAAxx 
   1891|      1|  1|   3|  1|    11|     91|     891|       1891|     1891|    1891|182| 183|TUAAAA  |BAAAAA  |HHHHxx 
   3420|      2|  0|   0|  0|     0|     20|     420|       1420|     3420|    3420| 40|  41|OBAAAA  |CAAAAA  |OOOOxx 
   9850|      3|  0|   2|  0|    10|     50|     850|       1850|     4850|    9850|100| 101|WOAAAA  |DAAAAA  |VVVVxx 
   7164|      4|  0|   0|  4|     4|     64|     164|       1164|     2164|    7164|128| 129|OPAAAA  |EAAAAA  |AAAAxx 
   8009|      5|  1|   1|  9|     9|      9|       9|          9|     3009|    8009| 18|  19|BWAAAA  |FAAAAA  |HHHHxx 
   5057|      6|  1|   1|  7|    17|     57|      57|       1057|       57|    5057|114| 115|NMAAAA  |GAAAAA  |OOOOxx 
   6701|      7|  1|   1|  1|     1|      1|     701|        701|     1701|    6701|  2|   3|TXAAAA  |HAAAAA  |VVVVxx 
   4321|      8|  1|   1|  1|     1|     21|     321|        321|     4321|    4321| 42|  43|FKAAAA  |IAAAAA  |AAAAxx 
(9 rows)

QUERY: FETCH 10 in foo10;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
   8800|      0|  0|   0|  0|     0|      0|     800|        800|     3800|    8800|  0|   1|MAAAAA  |AAAAAA  |AAAAxx 
   1891|      1|  1|   3|  1|    11|     91|     891|       1891|     1891|    1891|182| 183|TUAAAA  |BAAAAA  |HHHHxx 
   3420|      2|  0|   0|  0|     0|     20|     420|       1420|     3420|    3420| 40|  41|OBAAAA  |CAAAAA  |OOOOxx 
   9850|      3|  0|   2|  0|    10|     50|     850|       1850|     4850|    9850|100| 101|WOAAAA  |DAAAAA  |VVVVxx 
   7164|      4|  0|   0|  4|     4|     64|     164|       1164|     2164|    7164|128| 129|OPAAAA  |EAAAAA  |AAAAxx 
   8009|      5|  1|   1|  9|     9|      9|       9|          9|     3009|    8009| 18|  19|BWAAAA  |FAAAAA  |HHHHxx 
   5057|      6|  1|   1|  7|    17|     57|      57|       1057|       57|    5057|114| 115|NMAAAA  |GAAAAA  |OOOOxx 
   6701|      7|  1|   1|  1|     1|      1|     701|        701|     1701|    6701|  2|   3|TXAAAA  |HAAAAA  |VVVVxx 
   4321|      8|  1|   1|  1|     1|     21|     321|        321|     4321|    4321| 42|  43|FKAAAA  |IAAAAA  |AAAAxx 
   3043|      9|  1|   3|  3|     3|     43|      43|       1043|     3043|    3043| 86|  87|BNAAAA  |JAAAAA  |HHHHxx 
(10 rows)

QUERY: FETCH 11 in foo11;
unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
   8800|      0|  0|   0|  0|     0|      0|     800|        800|     3800|    8800|  0|   1|MAAAAA  |AAAAAA  |AAAAxx 
   1891|      1|  1|   3|  1|    11|     91|     891|       1891|     1891|    1891|182| 183|TUAAAA  |BAAAAA  |HHHHxx 
   3420|      2|  0|   0|  0|     0|     20|     420|       1420|     3420|    3420| 40|  41|OBAAAA  |CAAAAA  |OOOOxx 
   9850|      3|  0|   2|  0|    10|     50|     850|       1850|     4850|    9850|100| 101|WOAAAA  |DAAAAA  |VVVVxx