The following is a patch to bring the geometry regression test in line
with current (1.3.2/i386) NetBSD output.  I didn't see any differences
from the current "normal" expectation that were other than roundoff
errors, so I think the differences are irrelevant.

Cheers,
Brook

===========================================================================
--- test/regress/expected/geometry-NetBSD.out.orig	Sun Mar 22 12:46:33 1998
+++ test/regress/expected/geometry-NetBSD.out	Wed Sep 16 09:51:55 1998
@@ -87,43 +87,42 @@
 
 QUERY: SELECT '' AS count, p.f1, l.s, l.s # p.f1 AS intersection
    FROM LSEG_TBL l, POINT_TBL p;
-ERROR:  There is no operator '#' for types 'lseg' and 'point'
-	You will either have to retype this query using an explicit cast,
-	or you will have to define the operator using CREATE OPERATOR
+ERROR:  There is more than one possible operator '#' for types 'lseg' and 'point'
+	You will have to retype this query using an explicit cast
 QUERY: SELECT '' AS thirty, p.f1, l.s, p.f1 ## l.s AS closest
    FROM LSEG_TBL l, POINT_TBL p;
-thirty|f1        |s                            |closest                             
-------+----------+-----------------------------+------------------------------------
-      |(0,0)     |[(1,2),(3,4)]                |(1,2)                               
-      |(-10,0)   |[(1,2),(3,4)]                |(1,2)                               
-      |(-3,4)    |[(1,2),(3,4)]                |(1,2)                               
-      |(5.1,34.5)|[(1,2),(3,4)]                |(3,4)                               
-      |(-5,-12)  |[(1,2),(3,4)]                |(1,2)                               
-      |(10,10)   |[(1,2),(3,4)]                |(3,4)                               
-      |(0,0)     |[(0,0),(6,6)]                |(0,0)                               
-      |(-10,0)   |[(0,0),(6,6)]                |(0,0)                               
-      |(-3,4)    |[(0,0),(6,6)]                |(0,0)                               
-      |(5.1,34.5)|[(0,0),(6,6)]                |(6,6)                               
-      |(-5,-12)  |[(0,0),(6,6)]                |(0,0)                               
-      |(10,10)   |[(0,0),(6,6)]                |(6,6)                               
-      |(0,0)     |[(10,-10),(-3,-4)]           |(-3,-4)                             
-      |(-10,0)   |[(10,-10),(-3,-4)]           |(-3,-4)                             
-      |(-3,4)    |[(10,-10),(-3,-4)]           |(-3,-4)                             
-      |(5.1,34.5)|[(10,-10),(-3,-4)]           |(-3,-4)                             
-      |(-5,-12)  |[(10,-10),(-3,-4)]           |(-3,-4)                             
-      |(10,10)   |[(10,-10),(-3,-4)]           |(-3,-4)                             
-      |(0,0)     |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264)
-      |(-10,0)   |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472)
-      |(-3,4)    |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303)
-      |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925) 
-      |(-5,-12)  |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616)
-      |(10,10)   |[(-1000000,200),(300000,-40)]|(10.000993741978,15.3827690473092)  
-      |(0,0)     |[(11,22),(33,44)]            |(11,22)                             
-      |(-10,0)   |[(11,22),(33,44)]            |(11,22)                             
-      |(-3,4)    |[(11,22),(33,44)]            |(11,22)                             
-      |(5.1,34.5)|[(11,22),(33,44)]            |(11,22)                             
-      |(-5,-12)  |[(11,22),(33,44)]            |(11,22)                             
-      |(10,10)   |[(11,22),(33,44)]            |(11,22)                             
+thirty|f1        |s                            |closest                              
+------+----------+-----------------------------+-------------------------------------
+      |(0,0)     |[(1,2),(3,4)]                |(1,2)                                
+      |(-10,0)   |[(1,2),(3,4)]                |(1,2)                                
+      |(-3,4)    |[(1,2),(3,4)]                |(1,2)                                
+      |(5.1,34.5)|[(1,2),(3,4)]                |(3,4)                                
+      |(-5,-12)  |[(1,2),(3,4)]                |(1,2)                                
+      |(10,10)   |[(1,2),(3,4)]                |(3,4)                                
+      |(0,0)     |[(0,0),(6,6)]                |(0,0)                                
+      |(-10,0)   |[(0,0),(6,6)]                |(0,0)                                
+      |(-3,4)    |[(0,0),(6,6)]                |(0.5,0.5)                            
+      |(5.1,34.5)|[(0,0),(6,6)]                |(6,6)                                
+      |(-5,-12)  |[(0,0),(6,6)]                |(0,0)                                
+      |(10,10)   |[(0,0),(6,6)]                |(6,6)                                
+      |(0,0)     |[(10,-10),(-3,-4)]           |(-2.04878048780488,-4.4390243902439) 
+      |(-10,0)   |[(10,-10),(-3,-4)]           |(-3,-4)                              
+      |(-3,4)    |[(10,-10),(-3,-4)]           |(-3,-4)                              
+      |(5.1,34.5)|[(10,-10),(-3,-4)]           |(-3,-4)                              
+      |(-5,-12)  |[(10,-10),(-3,-4)]           |(-1.60487804878049,-4.64390243902439)
+      |(10,10)   |[(10,-10),(-3,-4)]           |(2.39024390243902,-6.48780487804878) 
+      |(0,0)     |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264) 
+      |(-10,0)   |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472) 
+      |(-3,4)    |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303) 
+      |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925)  
+      |(-5,-12)  |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616) 
+      |(10,10)   |[(-1000000,200),(300000,-40)]|(10.000993741978,15.3827690473092)   
+      |(0,0)     |[(11,22),(33,44)]            |(11,22)                              
+      |(-10,0)   |[(11,22),(33,44)]            |(11,22)                              
+      |(-3,4)    |[(11,22),(33,44)]            |(11,22)                              
+      |(5.1,34.5)|[(11,22),(33,44)]            |(14.3,25.3)                          
+      |(-5,-12)  |[(11,22),(33,44)]            |(11,22)                              
+      |(10,10)   |[(11,22),(33,44)]            |(11,22)                              
 (30 rows)
 
 QUERY: SELECT '' as six, box(f1) AS box FROM CIRCLE_TBL;

Wed, 16 Sep 1998 14:07:51 -0600 (MDT)
Brook Milligan <brook@trillium.NMSU.Edu>
geometry-NetBSD.out patch
APplied.


> The following is a patch to bring the geometry regression test in line
> with current (1.3.2/i386) NetBSD output.  I didn't see any differences
> from the current "normal" expectation that were other than roundoff
> errors, so I think the differences are irrelevant.
> 
> Cheers,
> Brook
> 
> ===========================================================================
> --- test/regress/expected/geometry-NetBSD.out.orig	Sun Mar 22 12:46:33 1998
> +++ test/regress/expected/geometry-NetBSD.out	Wed Sep 16 09:51:55 1998
> @@ -87,43 +87,42 @@
>  
>  QUERY: SELECT '' AS count, p.f1, l.s, l.s # p.f1 AS intersection
>     FROM LSEG_TBL l, POINT_TBL p;
> -ERROR:  There is no operator '#' for types 'lseg' and 'point'
> -	You will either have to retype this query using an explicit cast,
> -	or you will have to define the operator using CREATE OPERATOR
> +ERROR:  There is more than one possible operator '#' for types 'lseg' and 'point'
> +	You will have to retype this query using an explicit cast
>  QUERY: SELECT '' AS thirty, p.f1, l.s, p.f1 ## l.s AS closest
>     FROM LSEG_TBL l, POINT_TBL p;
> -thirty|f1        |s                            |closest                             
> -------+----------+-----------------------------+------------------------------------
> -      |(0,0)     |[(1,2),(3,4)]                |(1,2)                               
> -      |(-10,0)   |[(1,2),(3,4)]                |(1,2)                               
> -      |(-3,4)    |[(1,2),(3,4)]                |(1,2)                               
> -      |(5.1,34.5)|[(1,2),(3,4)]                |(3,4)                               
> -      |(-5,-12)  |[(1,2),(3,4)]                |(1,2)                               
> -      |(10,10)   |[(1,2),(3,4)]                |(3,4)                               
> -      |(0,0)     |[(0,0),(6,6)]                |(0,0)                               
> -      |(-10,0)   |[(0,0),(6,6)]                |(0,0)                               
> -      |(-3,4)    |[(0,0),(6,6)]                |(0,0)                               
> -      |(5.1,34.5)|[(0,0),(6,6)]                |(6,6)                               
> -      |(-5,-12)  |[(0,0),(6,6)]                |(0,0)                               
> -      |(10,10)   |[(0,0),(6,6)]                |(6,6)                               
> -      |(0,0)     |[(10,-10),(-3,-4)]           |(-3,-4)                             
> -      |(-10,0)   |[(10,-10),(-3,-4)]           |(-3,-4)                             
> -      |(-3,4)    |[(10,-10),(-3,-4)]           |(-3,-4)                             
> -      |(5.1,34.5)|[(10,-10),(-3,-4)]           |(-3,-4)                             
> -      |(-5,-12)  |[(10,-10),(-3,-4)]           |(-3,-4)                             
> -      |(10,10)   |[(10,-10),(-3,-4)]           |(-3,-4)                             
> -      |(0,0)     |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264)
> -      |(-10,0)   |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472)
> -      |(-3,4)    |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303)
> -      |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925) 
> -      |(-5,-12)  |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616)
> -      |(10,10)   |[(-1000000,200),(300000,-40)]|(10.000993741978,15.3827690473092)  
> -      |(0,0)     |[(11,22),(33,44)]            |(11,22)                             
> -      |(-10,0)   |[(11,22),(33,44)]            |(11,22)                             
> -      |(-3,4)    |[(11,22),(33,44)]            |(11,22)                             
> -      |(5.1,34.5)|[(11,22),(33,44)]            |(11,22)                             
> -      |(-5,-12)  |[(11,22),(33,44)]            |(11,22)                             
> -      |(10,10)   |[(11,22),(33,44)]            |(11,22)                             
> +thirty|f1        |s                            |closest                              
> +------+----------+-----------------------------+-------------------------------------
> +      |(0,0)     |[(1,2),(3,4)]                |(1,2)                                
> +      |(-10,0)   |[(1,2),(3,4)]                |(1,2)                                
> +      |(-3,4)    |[(1,2),(3,4)]                |(1,2)                                
> +      |(5.1,34.5)|[(1,2),(3,4)]                |(3,4)                                
> +      |(-5,-12)  |[(1,2),(3,4)]                |(1,2)                                
> +      |(10,10)   |[(1,2),(3,4)]                |(3,4)                                
> +      |(0,0)     |[(0,0),(6,6)]                |(0,0)                                
> +      |(-10,0)   |[(0,0),(6,6)]                |(0,0)                                
> +      |(-3,4)    |[(0,0),(6,6)]                |(0.5,0.5)                            
> +      |(5.1,34.5)|[(0,0),(6,6)]                |(6,6)                                
> +      |(-5,-12)  |[(0,0),(6,6)]                |(0,0)                                
> +      |(10,10)   |[(0,0),(6,6)]                |(6,6)                                
> +      |(0,0)     |[(10,-10),(-3,-4)]           |(-2.04878048780488,-4.4390243902439) 
> +      |(-10,0)   |[(10,-10),(-3,-4)]           |(-3,-4)                              
> +      |(-3,4)    |[(10,-10),(-3,-4)]           |(-3,-4)                              
> +      |(5.1,34.5)|[(10,-10),(-3,-4)]           |(-3,-4)                              
> +      |(-5,-12)  |[(10,-10),(-3,-4)]           |(-1.60487804878049,-4.64390243902439)
> +      |(10,10)   |[(10,-10),(-3,-4)]           |(2.39024390243902,-6.48780487804878) 
> +      |(0,0)     |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264) 
> +      |(-10,0)   |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472) 
> +      |(-3,4)    |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303) 
> +      |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925)  
> +      |(-5,-12)  |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616) 
> +      |(10,10)   |[(-1000000,200),(300000,-40)]|(10.000993741978,15.3827690473092)   
> +      |(0,0)     |[(11,22),(33,44)]            |(11,22)                              
> +      |(-10,0)   |[(11,22),(33,44)]            |(11,22)                              
> +      |(-3,4)    |[(11,22),(33,44)]            |(11,22)                              
> +      |(5.1,34.5)|[(11,22),(33,44)]            |(14.3,25.3)                          
> +      |(-5,-12)  |[(11,22),(33,44)]            |(11,22)                              
> +      |(10,10)   |[(11,22),(33,44)]            |(11,22)                              
>  (30 rows)
>  
>  QUERY: SELECT '' as six, box(f1) AS box FROM CIRCLE_TBL;
> 
> 


-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
http://www.op.net/~candle              |  (610) 353-9879(w)
  +  If your life is a hard drive,     |  (610) 853-3000(h)
  +  Christ can be your backup.        |

Fri, 18 Sep 1998 17:47:29 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] geometry-NetBSD.out patch