@@ -87,43 +87,42 @@ one|f1
8787
8888QUERY: SELECT '' AS count, p.f1, l.s, l.s # p.f1 AS intersection
8989 FROM LSEG_TBL l, POINT_TBL p;
90- ERROR: There is no operator '#' for types 'lseg' and 'point'
91- You will either have to retype this query using an explicit cast,
92- or you will have to define the operator using CREATE OPERATOR
90+ ERROR: There is more than one possible operator '#' for types 'lseg' and 'point'
91+ You will have to retype this query using an explicit cast
9392QUERY: SELECT '' AS thirty, p.f1, l.s, p.f1 ## l.s AS closest
9493 FROM LSEG_TBL l, POINT_TBL p;
95- thirty|f1 |s |closest
96- ------+----------+-----------------------------+------------------------------------
97- |(0,0) |[(1,2),(3,4)] |(1,2)
98- |(-10,0) |[(1,2),(3,4)] |(1,2)
99- |(-3,4) |[(1,2),(3,4)] |(1,2)
100- |(5.1,34.5)|[(1,2),(3,4)] |(3,4)
101- |(-5,-12) |[(1,2),(3,4)] |(1,2)
102- |(10,10) |[(1,2),(3,4)] |(3,4)
103- |(0,0) |[(0,0),(6,6)] |(0,0)
104- |(-10,0) |[(0,0),(6,6)] |(0,0)
105- |(-3,4) |[(0,0),(6,6)] |(0,0)
106- |(5.1,34.5)|[(0,0),(6,6)] |(6,6)
107- |(-5,-12) |[(0,0),(6,6)] |(0,0)
108- |(10,10) |[(0,0),(6,6)] |(6,6)
109- |(0,0) |[(10,-10),(-3,-4)] |(-3 ,-4)
110- |(-10,0) |[(10,-10),(-3,-4)] |(-3,-4)
111- |(-3,4) |[(10,-10),(-3,-4)] |(-3,-4)
112- |(5.1,34.5)|[(10,-10),(-3,-4)] |(-3,-4)
113- |(-5,-12) |[(10,-10),(-3,-4)] |(-3 ,-4)
114- |(10,10) |[(10,-10),(-3,-4)] |(-3,-4)
115- |(0,0) |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264)
116- |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472)
117- |(-3,4) |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303)
118- |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925)
119- |(-5,-12) |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616)
120- |(10,10) |[(-1000000,200),(300000,-40)]|(10.000993741978,15.3827690473092)
121- |(0,0) |[(11,22),(33,44)] |(11,22)
122- |(-10,0) |[(11,22),(33,44)] |(11,22)
123- |(-3,4) |[(11,22),(33,44)] |(11,22)
124- |(5.1,34.5)|[(11,22),(33,44)] |(11,22)
125- |(-5,-12) |[(11,22),(33,44)] |(11,22)
126- |(10,10) |[(11,22),(33,44)] |(11,22)
94+ thirty|f1 |s |closest
95+ ------+----------+-----------------------------+-------------------------------------
96+ |(0,0) |[(1,2),(3,4)] |(1,2)
97+ |(-10,0) |[(1,2),(3,4)] |(1,2)
98+ |(-3,4) |[(1,2),(3,4)] |(1,2)
99+ |(5.1,34.5)|[(1,2),(3,4)] |(3,4)
100+ |(-5,-12) |[(1,2),(3,4)] |(1,2)
101+ |(10,10) |[(1,2),(3,4)] |(3,4)
102+ |(0,0) |[(0,0),(6,6)] |(0,0)
103+ |(-10,0) |[(0,0),(6,6)] |(0,0)
104+ |(-3,4) |[(0,0),(6,6)] |(0.5,0.5)
105+ |(5.1,34.5)|[(0,0),(6,6)] |(6,6)
106+ |(-5,-12) |[(0,0),(6,6)] |(0,0)
107+ |(10,10) |[(0,0),(6,6)] |(6,6)
108+ |(0,0) |[(10,-10),(-3,-4)] |(-2.04878048780488 ,-4.4390243902439)
109+ |(-10,0) |[(10,-10),(-3,-4)] |(-3,-4)
110+ |(-3,4) |[(10,-10),(-3,-4)] |(-3,-4)
111+ |(5.1,34.5)|[(10,-10),(-3,-4)] |(-3,-4)
112+ |(-5,-12) |[(10,-10),(-3,-4)] |(-1.60487804878049 ,-4.64390243902439)
113+ |(10,10) |[(10,-10),(-3,-4)] |(2.39024390243902,-6.48780487804878)
114+ |(0,0) |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264)
115+ |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472)
116+ |(-3,4) |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303)
117+ |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925)
118+ |(-5,-12) |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616)
119+ |(10,10) |[(-1000000,200),(300000,-40)]|(10.000993741978,15.3827690473092)
120+ |(0,0) |[(11,22),(33,44)] |(11,22)
121+ |(-10,0) |[(11,22),(33,44)] |(11,22)
122+ |(-3,4) |[(11,22),(33,44)] |(11,22)
123+ |(5.1,34.5)|[(11,22),(33,44)] |(14.3,25.3)
124+ |(-5,-12) |[(11,22),(33,44)] |(11,22)
125+ |(10,10) |[(11,22),(33,44)] |(11,22)
127126(30 rows)
128127
129128QUERY: SELECT '' as six, box(f1) AS box FROM CIRCLE_TBL;