src/test/regress/expected/portals_p2.out

   1 --
   2 -- PORTALS_P2
   3 --
   4 BEGIN;
   5 DECLARE foo13 CURSOR FOR
   6    SELECT * FROM onek WHERE unique1 = 50;
   7 DECLARE foo14 CURSOR FOR
   8    SELECT * FROM onek WHERE unique1 = 51;
   9 DECLARE foo15 CURSOR FOR
  10    SELECT * FROM onek WHERE unique1 = 52;
  11 DECLARE foo16 CURSOR FOR
  12    SELECT * FROM onek WHERE unique1 = 53;
  13 DECLARE foo17 CURSOR FOR
  14    SELECT * FROM onek WHERE unique1 = 54;
  15 DECLARE foo18 CURSOR FOR
  16    SELECT * FROM onek WHERE unique1 = 55;
  17 DECLARE foo19 CURSOR FOR
  18    SELECT * FROM onek WHERE unique1 = 56;
  19 DECLARE foo20 CURSOR FOR
  20    SELECT * FROM onek WHERE unique1 = 57;
  21 DECLARE foo21 CURSOR FOR
  22    SELECT * FROM onek WHERE unique1 = 58;
  23 DECLARE foo22 CURSOR FOR
  24    SELECT * FROM onek WHERE unique1 = 59;
  25 DECLARE foo23 CURSOR FOR
  26    SELECT * FROM onek WHERE unique1 = 60;
  27 DECLARE foo24 CURSOR FOR
  28    SELECT * FROM onek2 WHERE unique1 = 50;
  29 DECLARE foo25 CURSOR FOR
  30    SELECT * FROM onek2 WHERE unique1 = 60;
  31 FETCH all in foo13;
  32  unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
  33 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
  34       50 |     253 |   0 |    2 |   0 |     10 |       0 |       50 |          50 |        50 |       50 |   0 |    1 | YBAAAA   | TJAAAA   | HHHHxx
  35 (1 row)
  36
  37 FETCH all in foo14;
  38  unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
  39 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
  40       51 |      76 |   1 |    3 |   1 |     11 |       1 |       51 |          51 |        51 |       51 |   2 |    3 | ZBAAAA   | YCAAAA   | AAAAxx
  41 (1 row)
  42
  43 FETCH all in foo15;
  44  unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
  45 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
  46       52 |     985 |   0 |    0 |   2 |     12 |       2 |       52 |          52 |        52 |       52 |   4 |    5 | ACAAAA   | XLBAAA   | HHHHxx
  47 (1 row)
  48
  49 FETCH all in foo16;
  50  unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
  51 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
  52       53 |     196 |   1 |    1 |   3 |     13 |       3 |       53 |          53 |        53 |       53 |   6 |    7 | BCAAAA   | OHAAAA   | AAAAxx
  53 (1 row)
  54
  55 FETCH all in foo17;
  56  unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
  57 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
  58       54 |     356 |   0 |    2 |   4 |     14 |       4 |       54 |          54 |        54 |       54 |   8 |    9 | CCAAAA   | SNAAAA   | AAAAxx
  59 (1 row)
  60
  61 FETCH all in foo18;
  62  unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
  63 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
  64       55 |     627 |   1 |    3 |   5 |     15 |       5 |       55 |          55 |        55 |       55 |  10 |   11 | DCAAAA   | DYAAAA   | VVVVxx
  65 (1 row)
  66
  67 FETCH all in foo19;
  68  unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
  69 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
  70       56 |      54 |   0 |    0 |   6 |     16 |       6 |       56 |          56 |        56 |       56 |  12 |   13 | ECAAAA   | CCAAAA   | OOOOxx
  71 (1 row)
  72
  73 FETCH all in foo20;
  74  unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
  75 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
  76       57 |     942 |   1 |    1 |   7 |     17 |       7 |       57 |          57 |        57 |       57 |  14 |   15 | FCAAAA   | GKBAAA   | OOOOxx
  77 (1 row)
  78
  79 FETCH all in foo21;
  80  unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
  81 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
  82       58 |     114 |   0 |    2 |   8 |     18 |       8 |       58 |          58 |        58 |       58 |  16 |   17 | GCAAAA   | KEAAAA   | OOOOxx
  83 (1 row)
  84
  85 FETCH all in foo22;
  86  unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
  87 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
  88       59 |     593 |   1 |    3 |   9 |     19 |       9 |       59 |          59 |        59 |       59 |  18 |   19 | HCAAAA   | VWAAAA   | HHHHxx
  89 (1 row)
  90
  91 FETCH all in foo23;
  92  unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
  93 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
  94       60 |     483 |   0 |    0 |   0 |      0 |       0 |       60 |          60 |        60 |       60 |   0 |    1 | ICAAAA   | PSAAAA   | VVVVxx
  95 (1 row)
  96
  97 FETCH all in foo24;
  98  unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
  99 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
 100       50 |     253 |   0 |    2 |   0 |     10 |       0 |       50 |          50 |        50 |       50 |   0 |    1 | YBAAAA   | TJAAAA   | HHHHxx
 101 (1 row)
 102
 103 FETCH all in foo25;
 104  unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
 105 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
 106       60 |     483 |   0 |    0 |   0 |      0 |       0 |       60 |          60 |        60 |       60 |   0 |    1 | ICAAAA   | PSAAAA   | VVVVxx
 107 (1 row)
 108
 109 CLOSE foo13;
 110 CLOSE foo14;
 111 CLOSE foo15;
 112 CLOSE foo16;
 113 CLOSE foo17;
 114 CLOSE foo18;
 115 CLOSE foo19;
 116 CLOSE foo20;
 117 CLOSE foo21;
 118 CLOSE foo22;
 119 CLOSE foo23;
 120 CLOSE foo24;
 121 CLOSE foo25;
 122 END;