1 QUERY: CREATE TABLE temp (initial int4);
2 QUERY: ALTER TABLE temp ADD COLUMN a int4;
3 QUERY: ALTER TABLE temp ADD COLUMN b char16;
4 QUERY: ALTER TABLE temp ADD COLUMN c text;
5 QUERY: ALTER TABLE temp ADD COLUMN d float8;
6 QUERY: ALTER TABLE temp ADD COLUMN e float4;
7 QUERY: ALTER TABLE temp ADD COLUMN f int2;
8 QUERY: ALTER TABLE temp ADD COLUMN g polygon;
9 QUERY: ALTER TABLE temp ADD COLUMN h abstime;
10 QUERY: ALTER TABLE temp ADD COLUMN i char;
11 QUERY: ALTER TABLE temp ADD COLUMN j abstime[];
12 QUERY: ALTER TABLE temp ADD COLUMN k dt;
13 ERROR: type name lookup of dt failed
14 QUERY: ALTER TABLE temp ADD COLUMN l tid;
15 QUERY: ALTER TABLE temp ADD COLUMN m xid;
16 QUERY: ALTER TABLE temp ADD COLUMN n oid8;
17 QUERY: ALTER TABLE temp ADD COLUMN p smgr;
18 QUERY: ALTER TABLE temp ADD COLUMN q point;
19 QUERY: ALTER TABLE temp ADD COLUMN r lseg;
20 QUERY: ALTER TABLE temp ADD COLUMN s path;
21 QUERY: ALTER TABLE temp ADD COLUMN t box;
22 QUERY: ALTER TABLE temp ADD COLUMN u tinterval;
23 QUERY: ALTER TABLE temp ADD COLUMN v oidint4;
24 QUERY: ALTER TABLE temp ADD COLUMN w oidname;
25 QUERY: ALTER TABLE temp ADD COLUMN x float8[];
26 QUERY: ALTER TABLE temp ADD COLUMN y float4[];
27 QUERY: ALTER TABLE temp ADD COLUMN z int2[];
28 QUERY: INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u,
30 VALUES (4, 'char16', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)',
31 'Mon May 1 00:30:30 1995', 'c', '{Mon May 1 00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}',
33 '1 2 3 4 5 6 7 8', 'magnetic disk', '(1.1,1.1)', '(4.1,4.1,3.1,3.1)',
34 '(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]',
35 '1/3', '1,char16', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
36 ERROR: Relation temp does not have attribute k
37 QUERY: SELECT * FROM temp;
38 initial|a|b|c|d|e|f|g|h|i|j|l|m|n|p|q|r|s|t|u|v|w|x|y|z
39 -------+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
42 QUERY: DROP TABLE temp;
43 QUERY: CREATE TABLE temp (
46 QUERY: ALTER TABLE temp ADD COLUMN a int4;
47 QUERY: ALTER TABLE temp ADD COLUMN b char16;
48 QUERY: ALTER TABLE temp ADD COLUMN c text;
49 QUERY: ALTER TABLE temp ADD COLUMN d float8;
50 QUERY: ALTER TABLE temp ADD COLUMN e float4;
51 QUERY: ALTER TABLE temp ADD COLUMN f int2;
52 QUERY: ALTER TABLE temp ADD COLUMN g polygon;
53 QUERY: ALTER TABLE temp ADD COLUMN h abstime;
54 QUERY: ALTER TABLE temp ADD COLUMN i char;
55 QUERY: ALTER TABLE temp ADD COLUMN j abstime[];
56 QUERY: ALTER TABLE temp ADD COLUMN k dt;
57 ERROR: type name lookup of dt failed
58 QUERY: ALTER TABLE temp ADD COLUMN l tid;
59 QUERY: ALTER TABLE temp ADD COLUMN m xid;
60 QUERY: ALTER TABLE temp ADD COLUMN n oid8;
61 QUERY: ALTER TABLE temp ADD COLUMN p smgr;
62 QUERY: ALTER TABLE temp ADD COLUMN q point;
63 QUERY: ALTER TABLE temp ADD COLUMN r lseg;
64 QUERY: ALTER TABLE temp ADD COLUMN s path;
65 QUERY: ALTER TABLE temp ADD COLUMN t box;
66 QUERY: ALTER TABLE temp ADD COLUMN u tinterval;
67 QUERY: ALTER TABLE temp ADD COLUMN v oidint4;
68 QUERY: ALTER TABLE temp ADD COLUMN w oidname;
69 QUERY: ALTER TABLE temp ADD COLUMN x float8[];
70 QUERY: ALTER TABLE temp ADD COLUMN y float4[];
71 QUERY: ALTER TABLE temp ADD COLUMN z int2[];
72 QUERY: INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u,
74 VALUES (4, 'char16', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)',
75 'Mon May 1 00:30:30 1995', 'c', '{Mon May 1 00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}',
77 '1 2 3 4 5 6 7 8', 'magnetic disk', '(1.1,1.1)', '(4.1,4.1,3.1,3.1)',
78 '(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]',
79 '1/3', '1,char16', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
80 ERROR: Relation temp does not have attribute k
81 QUERY: SELECT * FROM temp;
82 initial|a|b|c|d|e|f|g|h|i|j|l|m|n|p|q|r|s|t|u|v|w|x|y|z
83 -------+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
86 QUERY: DROP TABLE temp;
87 QUERY: ALTER TABLE tenk1 RENAME TO ten_k;
88 QUERY: SELECT unique1 FROM ten_k WHERE unique1 < 20;
113 QUERY: SELECT unique2 FROM ten_k WHERE unique2 < 20;
138 QUERY: SELECT hundred FROM ten_k WHERE hundred = 50;
243 QUERY: ALTER TABLE ten_k RENAME TO tenk1;
244 QUERY: SELECT unique1 FROM tenk1 WHERE unique1 < 5;