*** /home/thom/Development/postgresql/src/test/regress/expected/rangetypes.out 2012-04-06 10:31:54.361663200 +0100 --- /home/thom/Development/postgresql/src/test/regress/results/rangetypes.out 2012-04-06 21:52:24.196572345 +0100 *************** *** 263,306 **** select * from numrange_test where nr < numrange(-1000.0, -1000.0,'[]'); nr ------- - (,) - (,5) empty (3 rows) select * from numrange_test where nr < numrange(0.0, 1.0,'[]'); nr ------- - (,) - (,5) empty (3 rows) select * from numrange_test where nr < numrange(1000.0, 1001.0,'[]'); nr ----------- ! (,) ! [3,) (,5) [1.1,2.2) - empty [1.7,1.7] (6 rows) select * from numrange_test where nr > numrange(-1001.0, -1000.0,'[]'); nr ----------- - [3,) [1.1,2.2) [1.7,1.7] (3 rows) select * from numrange_test where nr > numrange(0.0, 1.0,'[]'); nr ----------- - [3,) [1.1,2.2) [1.7,1.7] (3 rows) select * from numrange_test where nr > numrange(1000.0, 1000.0,'[]'); --- 263,306 ---- select * from numrange_test where nr < numrange(-1000.0, -1000.0,'[]'); nr ------- empty + (,5) + (,) (3 rows) select * from numrange_test where nr < numrange(0.0, 1.0,'[]'); nr ------- empty + (,5) + (,) (3 rows) select * from numrange_test where nr < numrange(1000.0, 1001.0,'[]'); nr ----------- ! empty (,5) + (,) [1.1,2.2) [1.7,1.7] + [3,) (6 rows) select * from numrange_test where nr > numrange(-1001.0, -1000.0,'[]'); nr ----------- [1.1,2.2) [1.7,1.7] + [3,) (3 rows) select * from numrange_test where nr > numrange(0.0, 1.0,'[]'); nr ----------- [1.1,2.2) [1.7,1.7] + [3,) (3 rows) select * from numrange_test where nr > numrange(1000.0, 1000.0,'[]'); ======================================================================