diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-11-01 15:20:09 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-11-01 15:20:09 +0000 |
| commit | a4007c0d5f49d6122df7e2785be6ee27547a6e03 (patch) | |
| tree | 68ca13c17631cfa4553454c9c882fd152c0f4440 /src | |
| parent | 16cc5372e44bda4ce17e02dbebd988b64326b391 (diff) | |
| download | postgresql-a4007c0d5f49d6122df7e2785be6ee27547a6e03.tar.gz postgresql-a4007c0d5f49d6122df7e2785be6ee27547a6e03.zip | |
Update for test changes.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/float8-exp-three-digits.out | 35 | ||||
| -rw-r--r-- | src/test/regress/expected/float8-fp-exception.out | 35 |
2 files changed, 68 insertions, 2 deletions
diff --git a/src/test/regress/expected/float8-exp-three-digits.out b/src/test/regress/expected/float8-exp-three-digits.out index e4e43dafe99..b346ed5c38f 100644 --- a/src/test/regress/expected/float8-exp-three-digits.out +++ b/src/test/regress/expected/float8-exp-three-digits.out @@ -149,13 +149,46 @@ SELECT '' AS five, f.f1, f.f1 % AS round_f1 | 1.2345678901234e-200 | 0 (5 rows) +-- ceil +select ceil(f1) as ceil_f1 from float8_tbl f; + ceil_f1 +---------------------- + 0 + 1005 + -34 + 1.2345678901234e+200 + 1 +(5 rows) + +-- floor +select floor(f1) as floor_f1 from float8_tbl f; + floor_f1 +---------------------- + 0 + 1004 + -35 + 1.2345678901234e+200 + 0 +(5 rows) + +-- sign +select sign(f1) as sign_f1 from float8_tbl f; + sign_f1 +--------- + 0 + 1 + -1 + 1 + 1 +(5 rows) + +-- square root SELECT sqrt(float8 '64') AS eight; eight ------- 8 (1 row) --- square root SELECT |/ float8 '64' AS eight; eight ------- diff --git a/src/test/regress/expected/float8-fp-exception.out b/src/test/regress/expected/float8-fp-exception.out index cd9444533c3..15d96ff365d 100644 --- a/src/test/regress/expected/float8-fp-exception.out +++ b/src/test/regress/expected/float8-fp-exception.out @@ -149,13 +149,46 @@ SELECT '' AS five, f.f1, f.f1 % AS round_f1 | 1.2345678901234e-200 | 0 (5 rows) +-- ceil +select ceil(f1) as ceil_f1 from float8_tbl f; + ceil_f1 +---------------------- + 0 + 1005 + -34 + 1.2345678901234e+200 + 1 +(5 rows) + +-- floor +select floor(f1) as floor_f1 from float8_tbl f; + floor_f1 +---------------------- + 0 + 1004 + -35 + 1.2345678901234e+200 + 0 +(5 rows) + +-- sign +select sign(f1) as sign_f1 from float8_tbl f; + sign_f1 +--------- + 0 + 1 + -1 + 1 + 1 +(5 rows) + +-- square root SELECT sqrt(float8 '64') AS eight; eight ------- 8 (1 row) --- square root SELECT |/ float8 '64' AS eight; eight ------- |