1 QUERY: CREATE TABLE INT4_TBL(f1 int4);
2 QUERY: INSERT INTO INT4_TBL(f1) VALUES ('0');
3 QUERY: INSERT INTO INT4_TBL(f1) VALUES ('123456');
4 QUERY: INSERT INTO INT4_TBL(f1) VALUES ('-123456');
5 QUERY: INSERT INTO INT4_TBL(f1) VALUES ('34.5');
6 WARN:pg_atoi: error in "34.5": can't parse ".5"
7 QUERY: INSERT INTO INT4_TBL(f1) VALUES ('2147483647');
8 QUERY: INSERT INTO INT4_TBL(f1) VALUES ('-2147483647');
9 QUERY: INSERT INTO INT4_TBL(f1) VALUES ('1000000000000');
10 WARN:pg_atoi: error reading "1000000000000": Math result not representable
11 QUERY: INSERT INTO INT4_TBL(f1) VALUES ('asdf');
12 WARN:pg_atoi: error in "asdf": can't parse "asdf"
13 QUERY: SELECT '' AS five, INT4_TBL.*;
23 QUERY: SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> '0'::int2;
32 QUERY: SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> '0'::int4;
41 QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE i.f1 = '0'::int2;
47 QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE i.f1 = '0'::int4;
53 QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 < '0'::int2;
60 QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 < '0'::int4;
67 QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= '0'::int2;
75 QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= '0'::int4;
83 QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 > '0'::int2;
90 QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 > '0'::int4;
97 QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 >= '0'::int2;
105 QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 >= '0'::int4;
113 QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE (i.f1 % '2'::int2) = '1'::int2;
119 QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE (i.f1 % '2'::int4) = '0'::int2;
127 QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int2 AS x FROM INT4_TBL i;
129 ----+-----------+-------
137 QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int4 AS x FROM INT4_TBL i;
139 ----+-----------+-------
147 QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int2 AS x FROM INT4_TBL i;
149 ----+-----------+-----------
153 | 2147483647|-2147483647
154 |-2147483647|-2147483645
157 QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int4 AS x FROM INT4_TBL i;
159 ----+-----------+-----------
163 | 2147483647|-2147483647
164 |-2147483647|-2147483645
167 QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int2 AS x FROM INT4_TBL i;
169 ----+-----------+----------
173 | 2147483647|2147483645
174 |-2147483647|2147483647
177 QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int4 AS x FROM INT4_TBL i;
179 ----+-----------+----------
183 | 2147483647|2147483645
184 |-2147483647|2147483647
187 QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int2 AS x FROM INT4_TBL i;
189 ----+-----------+-----------
193 | 2147483647| 1073741823
194 |-2147483647|-1073741823
197 QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int4 AS x FROM INT4_TBL i;
199 ----+-----------+-----------
203 | 2147483647| 1073741823
204 |-2147483647|-1073741823
207 QUERY: SELECT -2+3 AS one;
213 QUERY: SELECT 4-2 AS two;
219 QUERY: SELECT 2- -1 AS three;
225 QUERY: SELECT 2 - -2 AS four;
231 QUERY: SELECT '2'::int2 * '2'::int2 = '16'::int2 / '4'::int2 AS true;
237 QUERY: SELECT '2'::int4 * '2'::int2 = '16'::int2 / '4'::int4 AS true;
243 QUERY: SELECT '2'::int2 * '2'::int4 = '16'::int4 / '4'::int2 AS true;
249 QUERY: SELECT '1000'::int4 < '999'::int4 AS false;
255 QUERY: SELECT 4! AS twenty_four;
261 QUERY: SELECT !!3 AS six;
267 QUERY: SELECT 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 AS ten;
273 QUERY: SELECT 2 + 2 / 2 AS three;
279 QUERY: SELECT (2 + 2) / 2 AS two;
285 QUERY: SELECT dsqrt('64'::float8) AS eight;
291 QUERY: SELECT |/'64'::float8 AS eight;
297 QUERY: SELECT ||/'27'::float8 AS three;