*** ./expected/float4.out Thu Mar 11 19:25:40 2004 --- ./results/float4.out Wed Jan 26 15:21:06 2005 *************** *** 33,55 **** ERROR: invalid input syntax for type real: "123 5" -- special inputs SELECT 'NaN'::float4; ! float4 ! -------- ! NaN ! (1 row) ! SELECT 'nan'::float4; ! float4 ! -------- ! NaN ! (1 row) ! SELECT ' NAN '::float4; ! float4 ! -------- ! NaN ! (1 row) ! SELECT 'infinity'::float4; float4 ---------- --- 33,43 ---- ERROR: invalid input syntax for type real: "123 5" -- special inputs SELECT 'NaN'::float4; ! ERROR: type "real" value out of range: overflow SELECT 'nan'::float4; ! ERROR: type "real" value out of range: overflow SELECT ' NAN '::float4; ! ERROR: type "real" value out of range: overflow SELECT 'infinity'::float4; float4 ---------- *************** *** 72,88 **** SELECT 'Infinity'::float4 + 100.0; ERROR: type "double precision" value out of range: overflow SELECT 'Infinity'::float4 / 'Infinity'::float4; ! ?column? ! ---------- ! NaN ! (1 row) ! SELECT 'nan'::float4 / 'nan'::float4; ! ?column? ! ---------- ! NaN ! (1 row) ! SELECT '' AS five, FLOAT4_TBL.*; five | f1 ------+------------- --- 60,68 ---- SELECT 'Infinity'::float4 + 100.0; ERROR: type "double precision" value out of range: overflow SELECT 'Infinity'::float4 / 'Infinity'::float4; ! ERROR: type "real" value out of range: overflow SELECT 'nan'::float4 / 'nan'::float4; ! ERROR: type "real" value out of range: overflow SELECT '' AS five, FLOAT4_TBL.*; five | f1 ------+------------- ====================================================================== *** ./expected/float8.out Fri Apr 23 16:32:20 2004 --- ./results/float8.out Wed Jan 26 15:21:07 2005 *************** *** 33,55 **** ERROR: invalid input syntax for type double precision: "123 5" -- special inputs SELECT 'NaN'::float8; ! float8 ! -------- ! NaN ! (1 row) ! SELECT 'nan'::float8; ! float8 ! -------- ! NaN ! (1 row) ! SELECT ' NAN '::float8; ! float8 ! -------- ! NaN ! (1 row) ! SELECT 'infinity'::float8; float8 ---------- --- 33,43 ---- ERROR: invalid input syntax for type double precision: "123 5" -- special inputs SELECT 'NaN'::float8; ! ERROR: type "double precision" value out of range: overflow SELECT 'nan'::float8; ! ERROR: type "double precision" value out of range: overflow SELECT ' NAN '::float8; ! ERROR: type "double precision" value out of range: overflow SELECT 'infinity'::float8; float8 ---------- *************** *** 72,88 **** SELECT 'Infinity'::float8 + 100.0; ERROR: type "double precision" value out of range: overflow SELECT 'Infinity'::float8 / 'Infinity'::float8; ! ?column? ! ---------- ! NaN ! (1 row) ! SELECT 'nan'::float8 / 'nan'::float8; ! ?column? ! ---------- ! NaN ! (1 row) ! SELECT '' AS five, FLOAT8_TBL.*; five | f1 ------+---------------------- --- 60,68 ---- SELECT 'Infinity'::float8 + 100.0; ERROR: type "double precision" value out of range: overflow SELECT 'Infinity'::float8 / 'Infinity'::float8; ! ERROR: type "double precision" value out of range: overflow SELECT 'nan'::float8 / 'nan'::float8; ! ERROR: type "double precision" value out of range: overflow SELECT '' AS five, FLOAT8_TBL.*; five | f1 ------+---------------------- ====================================================================== *** ./expected/misc.out Wed Jan 26 15:11:29 2005 --- ./results/misc.out Wed Jan 26 15:21:44 2005 *************** *** 63,72 **** COPY BINARY stud_emp FROM '/export/home/vincze/src/postgresql-8.0.0/src/test/regress/results/stud_emp.data'; SELECT * FROM stud_emp; name | age | location | salary | manager | gpa | percent ! -------+-----+------------+--------+---------+-----+--------- ! jeff | 23 | (8,7.7) | 600 | sharon | 3.5 | ! cim | 30 | (10.5,4.7) | 400 | | 3.4 | ! linda | 19 | (0.9,6.1) | 100 | | 2.9 | (3 rows) -- COPY aggtest FROM stdin; --- 63,72 ---- COPY BINARY stud_emp FROM '/export/home/vincze/src/postgresql-8.0.0/src/test/regress/results/stud_emp.data'; SELECT * FROM stud_emp; name | age | location | salary | manager | gpa | percent ! -------+-----+-----------------------------------------------+--------+---------+-----------------------+--------- ! jeff | 23 | (0,0) | 600 | sharon | 0 | ! cim | 30 | (0,0) | 400 | | 0 | ! linda | 19 | (8.48798316386109e-312,8.48798316386109e-312) | 100 | | 8.48798316386109e-312 | (3 rows) -- COPY aggtest FROM stdin; ======================================================================