Thread: arm rc1 regression failures
Just compiled RC1 on a netwinder ARM system running Debian Linux (sarge). All tests passed except "point" with the
following in results/point
Jim
--
-- POINT
--
CREATE TABLE POINT_TBL(f1 point);
INSERT INTO POINT_TBL(f1) VALUES ('(0.0,0.0)');
INSERT INTO POINT_TBL(f1) VALUES ('(-10.0,0.0)');
INSERT INTO POINT_TBL(f1) VALUES ('(-3.0,4.0)');
INSERT INTO POINT_TBL(f1) VALUES ('(5.1, 34.5)');
INSERT INTO POINT_TBL(f1) VALUES ('(-5.0,-12.0)');
-- bad format points
INSERT INTO POINT_TBL(f1) VALUES ('asdfasdf');
ERROR: invalid input syntax for type point: "asdfasdf"
INSERT INTO POINT_TBL(f1) VALUES ('10.0,10.0');
INSERT INTO POINT_TBL(f1) VALUES ('(10.0 10.0)');
ERROR: invalid input syntax for type point: "(10.0 10.0)"
INSERT INTO POINT_TBL(f1) VALUES ('(10.0,10.0');
ERROR: invalid input syntax for type point: "(10.0,10.0"
SELECT '' AS six, POINT_TBL.*;six | f1
-----+------------ | (0,0) | (-10,0) | (-3,4) | (5.1,34.5) | (-5,-12) | (10,10)
(6 rows)
-- left of
SELECT '' AS three, p.* FROM POINT_TBL p WHERE p.f1 << '(0.0, 0.0)';three | f1
-------+---------- | (-10,0) | (-3,4) | (-5,-12)
(3 rows)
-- right of
SELECT '' AS three, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' >> p.f1;three | f1
-------+---------- | (-10,0) | (-3,4) | (-5,-12)
(3 rows)
-- above
SELECT '' AS one, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' >^ p.f1;one | f1
-----+---------- | (-5,-12)
(1 row)
-- below
SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 <^ '(0.0, 0.0)';one | f1
-----+---------- | (-5,-12)
(1 row)
-- equal
SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 ~= '(5.1, 34.5)';one | f1
-----+------------ | (5.1,34.5)
(1 row)
-- point in box
SELECT '' AS three, p.* FROM POINT_TBL p WHERE p.f1 @ box '(0,0,100,100)';three | f1
-------+------------ | (0,0) | (5.1,34.5) | (10,10)
(3 rows)
SELECT '' AS three, p.* FROM POINT_TBL p WHERE not p.f1 @ box '(0,0,100,100)';three | f1
-------+---------- | (-10,0) | (-3,4) | (-5,-12)
(3 rows)
SELECT '' AS two, p.* FROM POINT_TBL p WHERE p.f1 @ path '[(0,0),(-10,0),(-10,10)]';two | f1
-----+--------- | (0,0) | (-10,0)
(2 rows)
SELECT '' AS six, p.f1, p.f1 <-> point '(0,0)' AS dist FROM POINT_TBL p ORDER BY dist;six | f1 | dist
-----+------------+------------------ | (0,0) | 0 | (-3,4) | 5 |
(-10,0) | 10 | (-5,-12) | 13 | (10,10) | 14.1421356237309 | (5.1,34.5) |
34.8749193547455
(6 rows)
SET geqo TO 'off';
SELECT '' AS thirtysix, p1.f1 AS point1, p2.f1 AS point2, p1.f1 <-> p2.f1 AS dist FROM POINT_TBL p1, POINT_TBL p2
ORDERBY dist, point1 using <<, point2 using <<;thirtysix | point1 | point2 | dist
-----------+------------+------------+------------------ | (-10,0) | (-10,0) | 0
|(-5,-12) | (-5,-12) | 0 | (-3,4) | (-3,4) | 0 | (0,0)
|(0,0) | 0 | (5.1,34.5) | (5.1,34.5) | 0 | (10,10) | (10,10)
| 0 | (-3,4) | (0,0) | 5 | (0,0) | (-3,4) |
5 | (-10,0) | (-3,4) | 8.06225774829855 | (-3,4) | (-10,0) | 8.06225774829855
| (-10,0) | (0,0) | 10 | (0,0) | (-10,0) | 10 | (-10,0)
| (-5,-12) | 13 | (-5,-12) | (-10,0) | 13 | (-5,-12) | (0,0)
| 13 | (0,0) | (-5,-12) | 13 | (0,0) | (10,10) |
14.1421356237309 | (10,10) | (0,0) | 14.1421356237309 | (-3,4) | (10,10) |
14.3178210632764 | (10,10) | (-3,4) | 14.3178210632764 | (-5,-12) | (-3,4) |
16.1245154965971 | (-3,4) | (-5,-12) | 16.1245154965971 | (-10,0) | (10,10) |
22.3606797749979 | (10,10) | (-10,0) | 22.3606797749979 | (5.1,34.5) | (10,10) |
24.9851956166046 | (10,10) | (5.1,34.5) | 24.9851956166046 | (-5,-12) | (10,10) |
26.6270539113887 | (10,10) | (-5,-12) | 26.6270539113887 | (-3,4) | (5.1,34.5) |
31.5572495632937 | (5.1,34.5) | (-3,4) | 31.5572495632937 | (0,0) | (5.1,34.5) |
34.8749193547455 | (5.1,34.5) | (0,0) | 34.8749193547455 | (-10,0) | (5.1,34.5) |
37.6597928831267 | (5.1,34.5) | (-10,0) | 37.6597928831267 | (-5,-12) | (5.1,34.5) |
47.5842410888311 | (5.1,34.5) | (-5,-12) | 47.5842410888311
(36 rows)
SELECT '' AS thirty, p1.f1 AS point1, p2.f1 AS point2 FROM POINT_TBL p1, POINT_TBL p2 WHERE (p1.f1 <-> p2.f1) >
3;thirty| point1 | point2
--------+------------+------------ | (0,0) | (-10,0) | (0,0) | (-3,4) | (0,0) |
(5.1,34.5) | (0,0) | (-5,-12) | (0,0) | (10,10) | (-10,0) | (0,0) | (-10,0) |
(-3,4) | (-10,0) | (5.1,34.5) | (-10,0) | (-5,-12) | (-10,0) | (10,10) | (-3,4) |
(0,0) | (-3,4) | (-10,0) | (-3,4) | (5.1,34.5) | (-3,4) | (-5,-12) | (-3,4) |
(10,10) | (5.1,34.5) | (0,0) | (5.1,34.5) | (-10,0) | (5.1,34.5) | (-3,4) | (5.1,34.5) |
(-5,-12) | (5.1,34.5) | (10,10) | (-5,-12) | (0,0) | (-5,-12) | (-10,0) | (-5,-12) |
(-3,4) | (-5,-12) | (5.1,34.5) | (-5,-12) | (10,10) | (10,10) | (0,0) | (10,10) |
(-10,0) | (10,10) | (-3,4) | (10,10) | (5.1,34.5) | (10,10) | (-5,-12)
(30 rows)
-- put distance result into output to allow sorting with GEQ optimizer - tgl 97/05/10
SELECT '' AS fifteen, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance FROM POINT_TBL p1, POINT_TBL p2
WHERE(p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1 ORDER BY distance, point1 using <<, point2 using <<;fifteen | point1
| point2 | distance
---------+------------+------------+------------------ | (-3,4) | (0,0) | 5 |
(-10,0) | (-3,4) | 8.06225774829855 | (-10,0) | (0,0) | 10 | (-10,0) |
(-5,-12) | 13 | (-5,-12) | (0,0) | 13 | (0,0) | (10,10) |
14.1421356237309 | (-3,4) | (10,10) | 14.3178210632764 | (-5,-12) | (-3,4) | 16.1245154965971
| (-10,0) | (10,10) | 22.3606797749979 | (5.1,34.5) | (10,10) | 24.9851956166046 |
(-5,-12) | (10,10) | 26.6270539113887 | (-3,4) | (5.1,34.5) | 31.5572495632937 | (0,0) |
(5.1,34.5)| 34.8749193547455 | (-10,0) | (5.1,34.5) | 37.6597928831267 | (-5,-12) | (5.1,34.5) |
47.5842410888311
(15 rows)
-- put distance result into output to allow sorting with GEQ optimizer - tgl 97/05/10
SELECT '' AS three, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance FROM POINT_TBL p1, POINT_TBL p2
WHERE(p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1 and p1.f1 >^ p2.f1 ORDER BY distance;three | point1 | point2 |
distance
-------+------------+----------+------------------ | (-3,4) | (0,0) | 5 | (-10,0) |
(-5,-12)| 13 | (5.1,34.5) | (10,10) | 24.9851956166046
(3 rows)
RESET geqo;
Would you send us regression.diff? That should show the differences.
---------------------------------------------------------------------------
Jim Buttafuoco wrote:
> Just compiled RC1 on a netwinder ARM system running Debian Linux (sarge). All tests passed except "point" with the
> following in results/point
>
> Jim
>
>
> --
> -- POINT
> --
> CREATE TABLE POINT_TBL(f1 point);
> INSERT INTO POINT_TBL(f1) VALUES ('(0.0,0.0)');
> INSERT INTO POINT_TBL(f1) VALUES ('(-10.0,0.0)');
> INSERT INTO POINT_TBL(f1) VALUES ('(-3.0,4.0)');
> INSERT INTO POINT_TBL(f1) VALUES ('(5.1, 34.5)');
> INSERT INTO POINT_TBL(f1) VALUES ('(-5.0,-12.0)');
> -- bad format points
> INSERT INTO POINT_TBL(f1) VALUES ('asdfasdf');
> ERROR: invalid input syntax for type point: "asdfasdf"
> INSERT INTO POINT_TBL(f1) VALUES ('10.0,10.0');
> INSERT INTO POINT_TBL(f1) VALUES ('(10.0 10.0)');
> ERROR: invalid input syntax for type point: "(10.0 10.0)"
> INSERT INTO POINT_TBL(f1) VALUES ('(10.0,10.0');
> ERROR: invalid input syntax for type point: "(10.0,10.0"
> SELECT '' AS six, POINT_TBL.*;
> six | f1
> -----+------------
> | (0,0)
> | (-10,0)
> | (-3,4)
> | (5.1,34.5)
> | (-5,-12)
> | (10,10)
> (6 rows)
>
> -- left of
> SELECT '' AS three, p.* FROM POINT_TBL p WHERE p.f1 << '(0.0, 0.0)';
> three | f1
> -------+----------
> | (-10,0)
> | (-3,4)
> | (-5,-12)
> (3 rows)
>
> -- right of
> SELECT '' AS three, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' >> p.f1;
> three | f1
> -------+----------
> | (-10,0)
> | (-3,4)
> | (-5,-12)
> (3 rows)
>
> -- above
> SELECT '' AS one, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' >^ p.f1;
> one | f1
> -----+----------
> | (-5,-12)
> (1 row)
>
> -- below
> SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 <^ '(0.0, 0.0)';
> one | f1
> -----+----------
> | (-5,-12)
> (1 row)
>
> -- equal
> SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 ~= '(5.1, 34.5)';
> one | f1
> -----+------------
> | (5.1,34.5)
> (1 row)
>
> -- point in box
> SELECT '' AS three, p.* FROM POINT_TBL p
> WHERE p.f1 @ box '(0,0,100,100)';
> three | f1
> -------+------------
> | (0,0)
> | (5.1,34.5)
> | (10,10)
> (3 rows)
>
> SELECT '' AS three, p.* FROM POINT_TBL p
> WHERE not p.f1 @ box '(0,0,100,100)';
> three | f1
> -------+----------
> | (-10,0)
> | (-3,4)
> | (-5,-12)
> (3 rows)
>
> SELECT '' AS two, p.* FROM POINT_TBL p
> WHERE p.f1 @ path '[(0,0),(-10,0),(-10,10)]';
> two | f1
> -----+---------
> | (0,0)
> | (-10,0)
> (2 rows)
>
> SELECT '' AS six, p.f1, p.f1 <-> point '(0,0)' AS dist
> FROM POINT_TBL p
> ORDER BY dist;
> six | f1 | dist
> -----+------------+------------------
> | (0,0) | 0
> | (-3,4) | 5
> | (-10,0) | 10
> | (-5,-12) | 13
> | (10,10) | 14.1421356237309
> | (5.1,34.5) | 34.8749193547455
> (6 rows)
>
> SET geqo TO 'off';
> SELECT '' AS thirtysix, p1.f1 AS point1, p2.f1 AS point2, p1.f1 <-> p2.f1 AS dist
> FROM POINT_TBL p1, POINT_TBL p2
> ORDER BY dist, point1 using <<, point2 using <<;
> thirtysix | point1 | point2 | dist
> -----------+------------+------------+------------------
> | (-10,0) | (-10,0) | 0
> | (-5,-12) | (-5,-12) | 0
> | (-3,4) | (-3,4) | 0
> | (0,0) | (0,0) | 0
> | (5.1,34.5) | (5.1,34.5) | 0
> | (10,10) | (10,10) | 0
> | (-3,4) | (0,0) | 5
> | (0,0) | (-3,4) | 5
> | (-10,0) | (-3,4) | 8.06225774829855
> | (-3,4) | (-10,0) | 8.06225774829855
> | (-10,0) | (0,0) | 10
> | (0,0) | (-10,0) | 10
> | (-10,0) | (-5,-12) | 13
> | (-5,-12) | (-10,0) | 13
> | (-5,-12) | (0,0) | 13
> | (0,0) | (-5,-12) | 13
> | (0,0) | (10,10) | 14.1421356237309
> | (10,10) | (0,0) | 14.1421356237309
> | (-3,4) | (10,10) | 14.3178210632764
> | (10,10) | (-3,4) | 14.3178210632764
> | (-5,-12) | (-3,4) | 16.1245154965971
> | (-3,4) | (-5,-12) | 16.1245154965971
> | (-10,0) | (10,10) | 22.3606797749979
> | (10,10) | (-10,0) | 22.3606797749979
> | (5.1,34.5) | (10,10) | 24.9851956166046
> | (10,10) | (5.1,34.5) | 24.9851956166046
> | (-5,-12) | (10,10) | 26.6270539113887
> | (10,10) | (-5,-12) | 26.6270539113887
> | (-3,4) | (5.1,34.5) | 31.5572495632937
> | (5.1,34.5) | (-3,4) | 31.5572495632937
> | (0,0) | (5.1,34.5) | 34.8749193547455
> | (5.1,34.5) | (0,0) | 34.8749193547455
> | (-10,0) | (5.1,34.5) | 37.6597928831267
> | (5.1,34.5) | (-10,0) | 37.6597928831267
> | (-5,-12) | (5.1,34.5) | 47.5842410888311
> | (5.1,34.5) | (-5,-12) | 47.5842410888311
> (36 rows)
>
> SELECT '' AS thirty, p1.f1 AS point1, p2.f1 AS point2
> FROM POINT_TBL p1, POINT_TBL p2
> WHERE (p1.f1 <-> p2.f1) > 3;
> thirty | point1 | point2
> --------+------------+------------
> | (0,0) | (-10,0)
> | (0,0) | (-3,4)
> | (0,0) | (5.1,34.5)
> | (0,0) | (-5,-12)
> | (0,0) | (10,10)
> | (-10,0) | (0,0)
> | (-10,0) | (-3,4)
> | (-10,0) | (5.1,34.5)
> | (-10,0) | (-5,-12)
> | (-10,0) | (10,10)
> | (-3,4) | (0,0)
> | (-3,4) | (-10,0)
> | (-3,4) | (5.1,34.5)
> | (-3,4) | (-5,-12)
> | (-3,4) | (10,10)
> | (5.1,34.5) | (0,0)
> | (5.1,34.5) | (-10,0)
> | (5.1,34.5) | (-3,4)
> | (5.1,34.5) | (-5,-12)
> | (5.1,34.5) | (10,10)
> | (-5,-12) | (0,0)
> | (-5,-12) | (-10,0)
> | (-5,-12) | (-3,4)
> | (-5,-12) | (5.1,34.5)
> | (-5,-12) | (10,10)
> | (10,10) | (0,0)
> | (10,10) | (-10,0)
> | (10,10) | (-3,4)
> | (10,10) | (5.1,34.5)
> | (10,10) | (-5,-12)
> (30 rows)
>
> -- put distance result into output to allow sorting with GEQ optimizer - tgl 97/05/10
> SELECT '' AS fifteen, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance
> FROM POINT_TBL p1, POINT_TBL p2
> WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1
> ORDER BY distance, point1 using <<, point2 using <<;
> fifteen | point1 | point2 | distance
> ---------+------------+------------+------------------
> | (-3,4) | (0,0) | 5
> | (-10,0) | (-3,4) | 8.06225774829855
> | (-10,0) | (0,0) | 10
> | (-10,0) | (-5,-12) | 13
> | (-5,-12) | (0,0) | 13
> | (0,0) | (10,10) | 14.1421356237309
> | (-3,4) | (10,10) | 14.3178210632764
> | (-5,-12) | (-3,4) | 16.1245154965971
> | (-10,0) | (10,10) | 22.3606797749979
> | (5.1,34.5) | (10,10) | 24.9851956166046
> | (-5,-12) | (10,10) | 26.6270539113887
> | (-3,4) | (5.1,34.5) | 31.5572495632937
> | (0,0) | (5.1,34.5) | 34.8749193547455
> | (-10,0) | (5.1,34.5) | 37.6597928831267
> | (-5,-12) | (5.1,34.5) | 47.5842410888311
> (15 rows)
>
> -- put distance result into output to allow sorting with GEQ optimizer - tgl 97/05/10
> SELECT '' AS three, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance
> FROM POINT_TBL p1, POINT_TBL p2
> WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1 and p1.f1 >^ p2.f1
> ORDER BY distance;
> three | point1 | point2 | distance
> -------+------------+----------+------------------
> | (-3,4) | (0,0) | 5
> | (-10,0) | (-5,-12) | 13
> | (5.1,34.5) | (10,10) | 24.9851956166046
> (3 rows)
>
> RESET geqo;
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073
See attached
---------- Original Message -----------
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: jim@contactbda.com
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Sent: Mon, 6 Dec 2004 12:24:18 -0500 (EST)
Subject: Re: [HACKERS] arm rc1 regression failures
> Would you send us regression.diff? That should show the differences.
>
> ---------------------------------------------------------------------------
>
> Jim Buttafuoco wrote:
> > Just compiled RC1 on a netwinder ARM system running Debian Linux (sarge). All tests passed except "point" with
the
> > following in results/point
> >
> > Jim
> >
> >
> > --
> > -- POINT
> > --
> > CREATE TABLE POINT_TBL(f1 point);
> > INSERT INTO POINT_TBL(f1) VALUES ('(0.0,0.0)');
> > INSERT INTO POINT_TBL(f1) VALUES ('(-10.0,0.0)');
> > INSERT INTO POINT_TBL(f1) VALUES ('(-3.0,4.0)');
> > INSERT INTO POINT_TBL(f1) VALUES ('(5.1, 34.5)');
> > INSERT INTO POINT_TBL(f1) VALUES ('(-5.0,-12.0)');
> > -- bad format points
> > INSERT INTO POINT_TBL(f1) VALUES ('asdfasdf');
> > ERROR: invalid input syntax for type point: "asdfasdf"
> > INSERT INTO POINT_TBL(f1) VALUES ('10.0,10.0');
> > INSERT INTO POINT_TBL(f1) VALUES ('(10.0 10.0)');
> > ERROR: invalid input syntax for type point: "(10.0 10.0)"
> > INSERT INTO POINT_TBL(f1) VALUES ('(10.0,10.0');
> > ERROR: invalid input syntax for type point: "(10.0,10.0"
> > SELECT '' AS six, POINT_TBL.*;
> > six | f1
> > -----+------------
> > | (0,0)
> > | (-10,0)
> > | (-3,4)
> > | (5.1,34.5)
> > | (-5,-12)
> > | (10,10)
> > (6 rows)
> >
> > -- left of
> > SELECT '' AS three, p.* FROM POINT_TBL p WHERE p.f1 << '(0.0, 0.0)';
> > three | f1
> > -------+----------
> > | (-10,0)
> > | (-3,4)
> > | (-5,-12)
> > (3 rows)
> >
> > -- right of
> > SELECT '' AS three, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' >> p.f1;
> > three | f1
> > -------+----------
> > | (-10,0)
> > | (-3,4)
> > | (-5,-12)
> > (3 rows)
> >
> > -- above
> > SELECT '' AS one, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' >^ p.f1;
> > one | f1
> > -----+----------
> > | (-5,-12)
> > (1 row)
> >
> > -- below
> > SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 <^ '(0.0, 0.0)';
> > one | f1
> > -----+----------
> > | (-5,-12)
> > (1 row)
> >
> > -- equal
> > SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 ~= '(5.1, 34.5)';
> > one | f1
> > -----+------------
> > | (5.1,34.5)
> > (1 row)
> >
> > -- point in box
> > SELECT '' AS three, p.* FROM POINT_TBL p
> > WHERE p.f1 @ box '(0,0,100,100)';
> > three | f1
> > -------+------------
> > | (0,0)
> > | (5.1,34.5)
> > | (10,10)
> > (3 rows)
> >
> > SELECT '' AS three, p.* FROM POINT_TBL p
> > WHERE not p.f1 @ box '(0,0,100,100)';
> > three | f1
> > -------+----------
> > | (-10,0)
> > | (-3,4)
> > | (-5,-12)
> > (3 rows)
> >
> > SELECT '' AS two, p.* FROM POINT_TBL p
> > WHERE p.f1 @ path '[(0,0),(-10,0),(-10,10)]';
> > two | f1
> > -----+---------
> > | (0,0)
> > | (-10,0)
> > (2 rows)
> >
> > SELECT '' AS six, p.f1, p.f1 <-> point '(0,0)' AS dist
> > FROM POINT_TBL p
> > ORDER BY dist;
> > six | f1 | dist
> > -----+------------+------------------
> > | (0,0) | 0
> > | (-3,4) | 5
> > | (-10,0) | 10
> > | (-5,-12) | 13
> > | (10,10) | 14.1421356237309
> > | (5.1,34.5) | 34.8749193547455
> > (6 rows)
> >
> > SET geqo TO 'off';
> > SELECT '' AS thirtysix, p1.f1 AS point1, p2.f1 AS point2, p1.f1 <-> p2.f1 AS dist
> > FROM POINT_TBL p1, POINT_TBL p2
> > ORDER BY dist, point1 using <<, point2 using <<;
> > thirtysix | point1 | point2 | dist
> > -----------+------------+------------+------------------
> > | (-10,0) | (-10,0) | 0
> > | (-5,-12) | (-5,-12) | 0
> > | (-3,4) | (-3,4) | 0
> > | (0,0) | (0,0) | 0
> > | (5.1,34.5) | (5.1,34.5) | 0
> > | (10,10) | (10,10) | 0
> > | (-3,4) | (0,0) | 5
> > | (0,0) | (-3,4) | 5
> > | (-10,0) | (-3,4) | 8.06225774829855
> > | (-3,4) | (-10,0) | 8.06225774829855
> > | (-10,0) | (0,0) | 10
> > | (0,0) | (-10,0) | 10
> > | (-10,0) | (-5,-12) | 13
> > | (-5,-12) | (-10,0) | 13
> > | (-5,-12) | (0,0) | 13
> > | (0,0) | (-5,-12) | 13
> > | (0,0) | (10,10) | 14.1421356237309
> > | (10,10) | (0,0) | 14.1421356237309
> > | (-3,4) | (10,10) | 14.3178210632764
> > | (10,10) | (-3,4) | 14.3178210632764
> > | (-5,-12) | (-3,4) | 16.1245154965971
> > | (-3,4) | (-5,-12) | 16.1245154965971
> > | (-10,0) | (10,10) | 22.3606797749979
> > | (10,10) | (-10,0) | 22.3606797749979
> > | (5.1,34.5) | (10,10) | 24.9851956166046
> > | (10,10) | (5.1,34.5) | 24.9851956166046
> > | (-5,-12) | (10,10) | 26.6270539113887
> > | (10,10) | (-5,-12) | 26.6270539113887
> > | (-3,4) | (5.1,34.5) | 31.5572495632937
> > | (5.1,34.5) | (-3,4) | 31.5572495632937
> > | (0,0) | (5.1,34.5) | 34.8749193547455
> > | (5.1,34.5) | (0,0) | 34.8749193547455
> > | (-10,0) | (5.1,34.5) | 37.6597928831267
> > | (5.1,34.5) | (-10,0) | 37.6597928831267
> > | (-5,-12) | (5.1,34.5) | 47.5842410888311
> > | (5.1,34.5) | (-5,-12) | 47.5842410888311
> > (36 rows)
> >
> > SELECT '' AS thirty, p1.f1 AS point1, p2.f1 AS point2
> > FROM POINT_TBL p1, POINT_TBL p2
> > WHERE (p1.f1 <-> p2.f1) > 3;
> > thirty | point1 | point2
> > --------+------------+------------
> > | (0,0) | (-10,0)
> > | (0,0) | (-3,4)
> > | (0,0) | (5.1,34.5)
> > | (0,0) | (-5,-12)
> > | (0,0) | (10,10)
> > | (-10,0) | (0,0)
> > | (-10,0) | (-3,4)
> > | (-10,0) | (5.1,34.5)
> > | (-10,0) | (-5,-12)
> > | (-10,0) | (10,10)
> > | (-3,4) | (0,0)
> > | (-3,4) | (-10,0)
> > | (-3,4) | (5.1,34.5)
> > | (-3,4) | (-5,-12)
> > | (-3,4) | (10,10)
> > | (5.1,34.5) | (0,0)
> > | (5.1,34.5) | (-10,0)
> > | (5.1,34.5) | (-3,4)
> > | (5.1,34.5) | (-5,-12)
> > | (5.1,34.5) | (10,10)
> > | (-5,-12) | (0,0)
> > | (-5,-12) | (-10,0)
> > | (-5,-12) | (-3,4)
> > | (-5,-12) | (5.1,34.5)
> > | (-5,-12) | (10,10)
> > | (10,10) | (0,0)
> > | (10,10) | (-10,0)
> > | (10,10) | (-3,4)
> > | (10,10) | (5.1,34.5)
> > | (10,10) | (-5,-12)
> > (30 rows)
> >
> > -- put distance result into output to allow sorting with GEQ optimizer - tgl 97/05/10
> > SELECT '' AS fifteen, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance
> > FROM POINT_TBL p1, POINT_TBL p2
> > WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1
> > ORDER BY distance, point1 using <<, point2 using <<;
> > fifteen | point1 | point2 | distance
> > ---------+------------+------------+------------------
> > | (-3,4) | (0,0) | 5
> > | (-10,0) | (-3,4) | 8.06225774829855
> > | (-10,0) | (0,0) | 10
> > | (-10,0) | (-5,-12) | 13
> > | (-5,-12) | (0,0) | 13
> > | (0,0) | (10,10) | 14.1421356237309
> > | (-3,4) | (10,10) | 14.3178210632764
> > | (-5,-12) | (-3,4) | 16.1245154965971
> > | (-10,0) | (10,10) | 22.3606797749979
> > | (5.1,34.5) | (10,10) | 24.9851956166046
> > | (-5,-12) | (10,10) | 26.6270539113887
> > | (-3,4) | (5.1,34.5) | 31.5572495632937
> > | (0,0) | (5.1,34.5) | 34.8749193547455
> > | (-10,0) | (5.1,34.5) | 37.6597928831267
> > | (-5,-12) | (5.1,34.5) | 47.5842410888311
> > (15 rows)
> >
> > -- put distance result into output to allow sorting with GEQ optimizer - tgl 97/05/10
> > SELECT '' AS three, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance
> > FROM POINT_TBL p1, POINT_TBL p2
> > WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1 and p1.f1 >^ p2.f1
> > ORDER BY distance;
> > three | point1 | point2 | distance
> > -------+------------+----------+------------------
> > | (-3,4) | (0,0) | 5
> > | (-10,0) | (-5,-12) | 13
> > | (5.1,34.5) | (10,10) | 24.9851956166046
> > (3 rows)
> >
> > RESET geqo;
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: the planner will ignore your desire to choose an index scan if your
> > joining column's datatypes do not match
> >
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
------- End of Original Message -------
Attachment
Jim Buttafuoco wrote: > See attached Well, that test passed for the last release, so what changed in between? I don't think we changed the floating-point output again, did we? -- Peter Eisentraut http://learn.to/quote