diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2002-10-22 20:01:15 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2002-10-22 20:01:15 +0000 |
| commit | 1c23cf4371707dee522cff08cc52ea86b99f24f6 (patch) | |
| tree | 05af062fde850a917ab0c2d3bf42dd0a5e9be51d /src | |
| parent | 7d970df60ec093c1122dc935c0ff72e4de1960d4 (diff) | |
| download | postgresql-1c23cf4371707dee522cff08cc52ea86b99f24f6.tar.gz postgresql-1c23cf4371707dee522cff08cc52ea86b99f24f6.zip | |
Update for test changes.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/float8-small-is-zero.out | 35 |
1 files changed, 34 insertions, 1 deletions
diff --git a/src/test/regress/expected/float8-small-is-zero.out b/src/test/regress/expected/float8-small-is-zero.out index 5055bb7fc59..119051f3993 100644 --- a/src/test/regress/expected/float8-small-is-zero.out +++ b/src/test/regress/expected/float8-small-is-zero.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 ------- |