← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to src/test/regress/expected/portals_p2.out

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
Import upstream version 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
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;