blob: f4b4cac0cabce849a26c91fb125c6157b877111b (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE FLOAT8_TBL(f1 float8);
INSERT INTO FLOAT8_TBL(f1) VALUES (' 0.0 ');
INSERT INTO FLOAT8_TBL(f1) VALUES ('1004.30 ');
INSERT INTO FLOAT8_TBL(f1) VALUES (' -34.84');
INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e+200');
INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-200');
CREATE TABLE float8_tbl(f1 float8);
INSERT INTO float8_tbl
SELECT * FROM LOAT8_TBL;
|
