blob: 11c0eccbe5f66179ebb9470c30fb796c83aabe67 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE INT4_TBL(f1 int4);
INSERT INTO INT4_TBL(f1) VALUES (' 0 ');
INSERT INTO INT4_TBL(f1) VALUES ('123456 ');
INSERT INTO INT4_TBL(f1) VALUES (' -123456');
INSERT INTO INT4_TBL(f1) VALUES ('2147483647');
INSERT INTO INT4_TBL(f1) VALUES ('-2147483647');
CREATE TABLE int4_tbl(f1 int4);
INSERT INTO int4_tbl
SELECT * FROM INT4_TBL;
|
