diff options
| author | Neil Conway <neilc@samurai.com> | 2005-04-07 01:51:41 +0000 |
|---|---|---|
| committer | Neil Conway <neilc@samurai.com> | 2005-04-07 01:51:41 +0000 |
| commit | f5ab0a14ea83eb6c27196b0c5d600b7f8b8b75fc (patch) | |
| tree | 3a40f9e70af0338c3dd1210b859f1a7445a40e6c /src/test/regress/expected/float8-exp-three-digits-win32.out | |
| parent | be2f825d51176bd21a627a529476f94de5bad4c2 (diff) | |
| download | postgresql-f5ab0a14ea83eb6c27196b0c5d600b7f8b8b75fc.tar.gz | |
Add a "USING" clause to DELETE, which is equivalent to the FROM clause
in UPDATE. We also now issue a NOTICE if a query has _any_ implicit
range table entries -- in the past, we would only warn about implicit
RTEs in SELECTs with at least one explicit RTE.
As a result of the warning change, 25 of the regression tests had to
be updated. I also took the opportunity to remove some bogus whitespace
differences between some of the float4 and float8 variants. I believe
I have correctly updated all the platform-specific variants, but let
me know if that's not the case.
Original patch for DELETE ... USING from Euler Taveira de Oliveira,
reworked by Neil Conway.
Diffstat (limited to 'src/test/regress/expected/float8-exp-three-digits-win32.out')
| -rw-r--r-- | src/test/regress/expected/float8-exp-three-digits-win32.out | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/src/test/regress/expected/float8-exp-three-digits-win32.out b/src/test/regress/expected/float8-exp-three-digits-win32.out index a7f15c5bbd..63d5e33c93 100644 --- a/src/test/regress/expected/float8-exp-three-digits-win32.out +++ b/src/test/regress/expected/float8-exp-three-digits-win32.out @@ -2,9 +2,9 @@ -- FLOAT8 -- CREATE TABLE FLOAT8_TBL(f1 float8); -INSERT INTO FLOAT8_TBL(f1) VALUES ('0.0'); -INSERT INTO FLOAT8_TBL(f1) VALUES ('1004.30'); -INSERT INTO FLOAT8_TBL(f1) VALUES ('-34.84'); +INSERT INTO FLOAT8_TBL(f1) VALUES (' 0.0 '); +INSERT INTO FLOAT8_TBL(f1) VALUES ('1004.30 '); +INSERT INTO FLOAT8_TBL(f1) VALUES (' -34.84'); INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e+200'); INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-200'); -- test for underflow and overflow handling @@ -85,7 +85,7 @@ SELECT 'nan'::float8 / 'nan'::float8; NaN (1 row) -SELECT '' AS five, FLOAT8_TBL.*; +SELECT '' AS five, * FROM FLOAT8_TBL; five | f1 ------+---------------------- | 0 @@ -328,7 +328,7 @@ SELECT '' AS five, f.f1, ||/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f; | 1.2345678901234e-200 | 2.3112042409018e-067 (5 rows) -SELECT '' AS five, FLOAT8_TBL.*; +SELECT '' AS five, * FROM FLOAT8_TBL; five | f1 ------+---------------------- | 0 @@ -353,7 +353,7 @@ SELECT '' AS bad, exp(f.f1) from FLOAT8_TBL f; ERROR: result is out of range SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f; ERROR: division by zero -SELECT '' AS five, FLOAT8_TBL.*; +SELECT '' AS five, * FROM FLOAT8_TBL; five | f1 ------+----------------------- | 0 @@ -380,7 +380,7 @@ INSERT INTO FLOAT8_TBL(f1) VALUES ('-34.84'); INSERT INTO FLOAT8_TBL(f1) VALUES ('-1004.30'); INSERT INTO FLOAT8_TBL(f1) VALUES ('-1.2345678901234e+200'); INSERT INTO FLOAT8_TBL(f1) VALUES ('-1.2345678901234e-200'); -SELECT '' AS five, FLOAT8_TBL.*; +SELECT '' AS five, * FROM FLOAT8_TBL; five | f1 ------+----------------------- | 0 |