diff options
Diffstat (limited to 'src')
-rw-r--r-- | src/test/regress/expected/float4-exp-three-digits.out | 12 | ||||
-rw-r--r-- | src/test/regress/expected/float4.out | 12 | ||||
-rw-r--r-- | src/test/regress/sql/float4.sql | 2 |
3 files changed, 26 insertions, 0 deletions
diff --git a/src/test/regress/expected/float4-exp-three-digits.out b/src/test/regress/expected/float4-exp-three-digits.out index f17f95697a2..ea6f77a671a 100644 --- a/src/test/regress/expected/float4-exp-three-digits.out +++ b/src/test/regress/expected/float4-exp-three-digits.out @@ -125,6 +125,18 @@ SELECT 'nan'::numeric::float4; NaN (1 row) +SELECT 'nan'::float8::float4; + float4 +-------- + NaN +(1 row) + +SELECT 'nan'::float4::float8; + float8 +-------- + NaN +(1 row) + SELECT '' AS five, * FROM FLOAT4_TBL; five | f1 ------+-------------- diff --git a/src/test/regress/expected/float4.out b/src/test/regress/expected/float4.out index fd46a4a1db7..ab9b1acd493 100644 --- a/src/test/regress/expected/float4.out +++ b/src/test/regress/expected/float4.out @@ -125,6 +125,18 @@ SELECT 'nan'::numeric::float4; NaN (1 row) +SELECT 'nan'::float8::float4; + float4 +-------- + NaN +(1 row) + +SELECT 'nan'::float4::float8; + float8 +-------- + NaN +(1 row) + SELECT '' AS five, * FROM FLOAT4_TBL; five | f1 ------+------------- diff --git a/src/test/regress/sql/float4.sql b/src/test/regress/sql/float4.sql index 3b363f94635..e6f5c7425da 100644 --- a/src/test/regress/sql/float4.sql +++ b/src/test/regress/sql/float4.sql @@ -41,6 +41,8 @@ SELECT 'Infinity'::float4 + 100.0; SELECT 'Infinity'::float4 / 'Infinity'::float4; SELECT 'nan'::float4 / 'nan'::float4; SELECT 'nan'::numeric::float4; +SELECT 'nan'::float8::float4; +SELECT 'nan'::float4::float8; SELECT '' AS five, * FROM FLOAT4_TBL; |