diff options
| author | Marc G. Fournier <scrappy@hub.org> | 1997-04-05 11:24:54 +0000 |
|---|---|---|
| committer | Marc G. Fournier <scrappy@hub.org> | 1997-04-05 11:24:54 +0000 |
| commit | 7956e606d6a6edced76204d7e0bb7d3511aea46c (patch) | |
| tree | 8e1f90b45ed593e4e0444319674434ae63f70be4 /src/test/regress/expected/float4.out | |
| parent | d108a310823c3a7a248cbcc52d4474b0992b4310 (diff) | |
| download | postgresql-7956e606d6a6edced76204d7e0bb7d3511aea46c.tar.gz | |
Add more expected.out results
Diffstat (limited to 'src/test/regress/expected/float4.out')
| -rw-r--r-- | src/test/regress/expected/float4.out | 148 |
1 files changed, 148 insertions, 0 deletions
diff --git a/src/test/regress/expected/float4.out b/src/test/regress/expected/float4.out new file mode 100644 index 0000000000..92cfe073af --- /dev/null +++ b/src/test/regress/expected/float4.out @@ -0,0 +1,148 @@ +QUERY: CREATE TABLE FLOAT4_TBL (f1 float4); +QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('0.0'); +QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('1004.30'); +QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('-34.84'); +QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('1.2345678901234e+20'); +QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('1.2345678901234e-20'); +QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('10e40'); +WARN: Bad float4 input format -- overflow + +QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e40'); +WARN: Bad float4 input format -- overflow + +QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('10e-40'); +WARN: Bad float4 input format -- underflow + +QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e-40'); +WARN: Bad float4 input format -- underflow + +QUERY: SELECT '' AS five, FLOAT4_TBL.*; +five|f1 +----+----------- + |0 + |1004.3 + |-34.84 + |1.23457e+20 + |1.23457e-20 +(5 rows) + +QUERY: SELECT '' AS four, f.* FROM FLOAT4_TBL f WHERE f.f1 <> '1004.3'; +four|f1 +----+----------- + |0 + |-34.84 + |1.23457e+20 + |1.23457e-20 +(4 rows) + +QUERY: SELECT '' AS one, f.* FROM FLOAT4_TBL f WHERE f.f1 = '1004.3'; +one| f1 +---+------ + |1004.3 +(1 row) + +QUERY: SELECT '' AS three, f.* FROM FLOAT4_TBL f WHERE '1004.3' > f.f1; +three| f1 +-----+----------- + | 0 + | -34.84 + |1.23457e-20 +(3 rows) + +QUERY: SELECT '' AS three, f.* FROM FLOAT4_TBL f WHERE f.f1 < '1004.3'; +three| f1 +-----+----------- + | 0 + | -34.84 + |1.23457e-20 +(3 rows) + +QUERY: SELECT '' AS four, f.* FROM FLOAT4_TBL f WHERE '1004.3' >= f.f1; +four| f1 +----+----------- + | 0 + | 1004.3 + | -34.84 + |1.23457e-20 +(4 rows) + +QUERY: SELECT '' AS four, f.* FROM FLOAT4_TBL f WHERE f.f1 <= '1004.3'; +four| f1 +----+----------- + | 0 + | 1004.3 + | -34.84 + |1.23457e-20 +(4 rows) + +QUERY: SELECT '' AS three, f.f1, f.f1 * '-10' AS x FROM FLOAT4_TBL f + WHERE f.f1 > '0.0'; +three|f1 |x +-----+-----------+------------ + |1004.3 |-10043 + |1.23457e+20|-1.23457e+21 + |1.23457e-20|-1.23457e-19 +(3 rows) + +QUERY: SELECT '' AS three, f.f1, f.f1 + '-10' AS x FROM FLOAT4_TBL f + WHERE f.f1 > '0.0'; +three|f1 |x +-----+-----------+----------- + |1004.3 |994.3 + |1.23457e+20|1.23457e+20 + |1.23457e-20|-10 +(3 rows) + +QUERY: SELECT '' AS three, f.f1, f.f1 / '-10' AS x FROM FLOAT4_TBL f + WHERE f.f1 > '0.0'; +three|f1 |x +-----+-----------+------------ + |1004.3 |-100.43 + |1.23457e+20|-1.23457e+19 + |1.23457e-20|-1.23457e-21 +(3 rows) + +QUERY: SELECT '' AS three, f.f1, f.f1 - '-10' AS x FROM FLOAT4_TBL f + WHERE f.f1 > '0.0'; +three|f1 |x +-----+-----------+----------- + |1004.3 |1014.3 + |1.23457e+20|1.23457e+20 + |1.23457e-20|10 +(3 rows) + +QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT4_TBL f; +WARN:float4div: divide by 0.0 error +QUERY: SELECT '' AS five, FLOAT4_TBL.*; +five|f1 +----+----------- + |0 + |1004.3 + |-34.84 + |1.23457e+20 + |1.23457e-20 +(5 rows) + +QUERY: SELECT '' AS five, f.f1, @f.f1 AS abs_f1 FROM FLOAT4_TBL f; +five|f1 |abs_f1 +----+-----------+----------- + |0 |0 + |1004.3 |1004.3 + |-34.84 |34.84 + |1.23457e+20|1.23457e+20 + |1.23457e-20|1.23457e-20 +(5 rows) + +QUERY: UPDATE FLOAT4_TBL + SET f1 = FLOAT4_TBL.f1 * '-1' + WHERE FLOAT4_TBL.f1 > '0.0'; +QUERY: SELECT '' AS five, FLOAT4_TBL.*; +five|f1 +----+------------ + |0 + |-34.84 + |-1004.3 + |-1.23457e+20 + |-1.23457e-20 +(5 rows) + |