summaryrefslogtreecommitdiff
path: root/src/test/regress/expected/float8-small-is-zero_1.out
diff options
context:
space:
mode:
authorNeil Conway <neilc@samurai.com>2005-02-11 04:09:05 +0000
committerNeil Conway <neilc@samurai.com>2005-02-11 04:09:05 +0000
commit975e27377aadcabab6504155c091d27ea2fa4c53 (patch)
treecbf5435f931969d09543401af0c1d8bb5dcb3d56 /src/test/regress/expected/float8-small-is-zero_1.out
parent4db84f0880716ece570db2debf99b773bfb82dd3 (diff)
downloadpostgresql-975e27377aadcabab6504155c091d27ea2fa4c53.tar.gz
Adjust input routines for float4, float8 and oid to reject the empty string
as valid input (it was previously treated as 0). This input was deprecated in 8.0 (and a warning was emitted). Regression tests updated.
Diffstat (limited to 'src/test/regress/expected/float8-small-is-zero_1.out')
-rw-r--r--src/test/regress/expected/float8-small-is-zero_1.out2
1 files changed, 2 insertions, 0 deletions
diff --git a/src/test/regress/expected/float8-small-is-zero_1.out b/src/test/regress/expected/float8-small-is-zero_1.out
index 3a74505b4e..a6b1ae2c04 100644
--- a/src/test/regress/expected/float8-small-is-zero_1.out
+++ b/src/test/regress/expected/float8-small-is-zero_1.out
@@ -25,6 +25,8 @@ SELECT '-10e-400'::float8;
(1 row)
-- bad input
+INSERT INTO FLOAT8_TBL(f1) VALUES ('');
+ERROR: invalid input syntax for type double precision: ""
INSERT INTO FLOAT8_TBL(f1) VALUES (' ');
ERROR: invalid input syntax for type double precision: " "
INSERT INTO FLOAT8_TBL(f1) VALUES ('xyz');