1--
2-- PORTALS_P2
3--
4BEGIN;
5DECLARE foo13 CURSOR FOR
6   SELECT * FROM onek WHERE unique1 = 50;
7DECLARE foo14 CURSOR FOR
8   SELECT * FROM onek WHERE unique1 = 51;
9DECLARE foo15 CURSOR FOR
10   SELECT * FROM onek WHERE unique1 = 52;
11DECLARE foo16 CURSOR FOR
12   SELECT * FROM onek WHERE unique1 = 53;
13DECLARE foo17 CURSOR FOR
14   SELECT * FROM onek WHERE unique1 = 54;
15DECLARE foo18 CURSOR FOR
16   SELECT * FROM onek WHERE unique1 = 55;
17DECLARE foo19 CURSOR FOR
18   SELECT * FROM onek WHERE unique1 = 56;
19DECLARE foo20 CURSOR FOR
20   SELECT * FROM onek WHERE unique1 = 57;
21DECLARE foo21 CURSOR FOR
22   SELECT * FROM onek WHERE unique1 = 58;
23DECLARE foo22 CURSOR FOR
24   SELECT * FROM onek WHERE unique1 = 59;
25DECLARE foo23 CURSOR FOR
26   SELECT * FROM onek WHERE unique1 = 60;
27DECLARE foo24 CURSOR FOR
28   SELECT * FROM onek2 WHERE unique1 = 50;
29DECLARE foo25 CURSOR FOR
30   SELECT * FROM onek2 WHERE unique1 = 60;
31FETCH 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
37FETCH 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
43FETCH 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
49FETCH 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
55FETCH 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
61FETCH 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
67FETCH 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
73FETCH 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
79FETCH 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
85FETCH 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
91FETCH 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
97FETCH 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
103FETCH 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
109CLOSE foo13;
110CLOSE foo14;
111CLOSE foo15;
112CLOSE foo16;
113CLOSE foo17;
114CLOSE foo18;
115CLOSE foo19;
116CLOSE foo20;
117CLOSE foo21;
118CLOSE foo22;
119CLOSE foo23;
120CLOSE foo24;
121CLOSE foo25;
122END;
123