5 CREATE TABLE tmp (initial int4);
7 ALTER TABLE tmp ADD COLUMN a int4;
9 ALTER TABLE tmp ADD COLUMN b name;
11 ALTER TABLE tmp ADD COLUMN c text;
13 ALTER TABLE tmp ADD COLUMN d float8;
15 ALTER TABLE tmp ADD COLUMN e float4;
17 ALTER TABLE tmp ADD COLUMN f int2;
19 ALTER TABLE tmp ADD COLUMN g polygon;
21 ALTER TABLE tmp ADD COLUMN h abstime;
23 ALTER TABLE tmp ADD COLUMN i char;
25 ALTER TABLE tmp ADD COLUMN j abstime[];
27 ALTER TABLE tmp ADD COLUMN k dt;
29 ALTER TABLE tmp ADD COLUMN l tid;
31 ALTER TABLE tmp ADD COLUMN m xid;
33 ALTER TABLE tmp ADD COLUMN n oid8;
35 --ALTER TABLE tmp ADD COLUMN o lock;
36 ALTER TABLE tmp ADD COLUMN p smgr;
38 ALTER TABLE tmp ADD COLUMN q point;
40 ALTER TABLE tmp ADD COLUMN r lseg;
42 ALTER TABLE tmp ADD COLUMN s path;
44 ALTER TABLE tmp ADD COLUMN t box;
46 ALTER TABLE tmp ADD COLUMN u tinterval;
48 ALTER TABLE tmp ADD COLUMN v datetime;
50 ALTER TABLE tmp ADD COLUMN w timespan;
52 ALTER TABLE tmp ADD COLUMN x float8[];
54 ALTER TABLE tmp ADD COLUMN y float4[];
56 ALTER TABLE tmp ADD COLUMN z int2[];
58 INSERT INTO tmp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u,
60 VALUES (4, 'name', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)',
61 'Mon May 1 00:30:30 1995', 'c', '{Mon May 1 00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}',
63 '1 2 3 4 5 6 7 8', 'magnetic disk', '(1.1,1.1)', '(4.1,4.1,3.1,3.1)',
64 '(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]',
65 '1/3', '1,name', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
71 -- the wolf bug - schema mods caused inconsistent row descriptors
76 ALTER TABLE tmp ADD COLUMN a int4;
78 ALTER TABLE tmp ADD COLUMN b name;
80 ALTER TABLE tmp ADD COLUMN c text;
82 ALTER TABLE tmp ADD COLUMN d float8;
84 ALTER TABLE tmp ADD COLUMN e float4;
86 ALTER TABLE tmp ADD COLUMN f int2;
88 ALTER TABLE tmp ADD COLUMN g polygon;
90 ALTER TABLE tmp ADD COLUMN h abstime;
92 ALTER TABLE tmp ADD COLUMN i char;
94 ALTER TABLE tmp ADD COLUMN j abstime[];
96 ALTER TABLE tmp ADD COLUMN k dt;
98 ALTER TABLE tmp ADD COLUMN l tid;
100 ALTER TABLE tmp ADD COLUMN m xid;
102 ALTER TABLE tmp ADD COLUMN n oid8;
104 --ALTER TABLE tmp ADD COLUMN o lock;
105 ALTER TABLE tmp ADD COLUMN p smgr;
107 ALTER TABLE tmp ADD COLUMN q point;
109 ALTER TABLE tmp ADD COLUMN r lseg;
111 ALTER TABLE tmp ADD COLUMN s path;
113 ALTER TABLE tmp ADD COLUMN t box;
115 ALTER TABLE tmp ADD COLUMN u tinterval;
117 ALTER TABLE tmp ADD COLUMN v datetime;
119 ALTER TABLE tmp ADD COLUMN w timespan;
121 ALTER TABLE tmp ADD COLUMN x float8[];
123 ALTER TABLE tmp ADD COLUMN y float4[];
125 ALTER TABLE tmp ADD COLUMN z int2[];
127 INSERT INTO tmp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u,
129 VALUES (4, 'name', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)',
130 'Mon May 1 00:30:30 1995', 'c', '{Mon May 1 00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}',
131 314159, '(1,1)', 512,
132 '1 2 3 4 5 6 7 8', 'magnetic disk', '(1.1,1.1)', '(4.1,4.1,3.1,3.1)',
133 '(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]',
134 '1/3', '1,name', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
143 -- should preserve indices
145 ALTER TABLE tenk1 RENAME TO ten_k;
148 SELECT unique1 FROM ten_k WHERE unique1 < 20;
151 SELECT unique2 FROM ten_k WHERE unique2 < 20;
153 -- 100 values, sorted
154 SELECT hundred FROM ten_k WHERE hundred = 50;
156 ALTER TABLE ten_k RENAME TO tenk1;
159 SELECT unique1 FROM tenk1 WHERE unique1 < 5;