*** /home/manu/workspace/PG-HEAD/src/test/regress/expected/union.out	2009-02-09 16:18:28.000000000 -0500
--- /home/manu/workspace/PG-HEAD/src/test/regress/results/union.out	2009-11-19 19:37:32.000000000 -0500
***************
*** 198,208 ****
    WHERE f1 BETWEEN 0 AND 1000000;
           five          
  -----------------------
-                -1004.3
-                 -34.84
-  -1.2345678901234e-200
                       0
                  123456
  (5 rows)
  
  SELECT CAST(f1 AS char(4)) AS three FROM VARCHAR_TBL
--- 198,208 ----
    WHERE f1 BETWEEN 0 AND 1000000;
           five          
  -----------------------
                       0
                  123456
+                 -34.84
+  -1.2345678901234e-200
+                -1004.3
  (5 rows)
  
  SELECT CAST(f1 AS char(4)) AS three FROM VARCHAR_TBL
***************
*** 263,278 ****
  SELECT q2 FROM int8_tbl INTERSECT SELECT q1 FROM int8_tbl;
          q2        
  ------------------
-  4567890123456789
                123
  (2 rows)
  
  SELECT q2 FROM int8_tbl INTERSECT ALL SELECT q1 FROM int8_tbl;
          q2        
  ------------------
   4567890123456789
   4567890123456789
-               123
  (3 rows)
  
  SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl ORDER BY 1;
--- 263,278 ----
  SELECT q2 FROM int8_tbl INTERSECT SELECT q1 FROM int8_tbl;
          q2        
  ------------------
                123
+  4567890123456789
  (2 rows)
  
  SELECT q2 FROM int8_tbl INTERSECT ALL SELECT q1 FROM int8_tbl;
          q2        
  ------------------
+               123
   4567890123456789
   4567890123456789
  (3 rows)
  
  SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl ORDER BY 1;
***************
*** 305,320 ****
  SELECT q1 FROM int8_tbl EXCEPT ALL SELECT q2 FROM int8_tbl;
          q1        
  ------------------
-  4567890123456789
                123
  (2 rows)
  
  SELECT q1 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q2 FROM int8_tbl;
          q1        
  ------------------
   4567890123456789
   4567890123456789
-               123
  (3 rows)
  
  --
--- 305,320 ----
  SELECT q1 FROM int8_tbl EXCEPT ALL SELECT q2 FROM int8_tbl;
          q1        
  ------------------
                123
+  4567890123456789
  (2 rows)
  
  SELECT q1 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q2 FROM int8_tbl;
          q1        
  ------------------
+               123
   4567890123456789
   4567890123456789
  (3 rows)
  
  --
***************
*** 341,348 ****
  SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl;
          q1         
  -------------------
-   4567890123456789
                 123
                 456
    4567890123456789
                 123
--- 341,348 ----
  SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl;
          q1         
  -------------------
                 123
+   4567890123456789
                 456
    4567890123456789
                 123
***************
*** 353,367 ****
  SELECT q1 FROM int8_tbl INTERSECT (((SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl)));
          q1        
  ------------------
-  4567890123456789
                123
  (2 rows)
  
  (((SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl))) UNION ALL SELECT q2 FROM int8_tbl;
          q1         
  -------------------
-   4567890123456789
                 123
                 456
    4567890123456789
                 123
--- 353,367 ----
  SELECT q1 FROM int8_tbl INTERSECT (((SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl)));
          q1        
  ------------------
                123
+  4567890123456789
  (2 rows)
  
  (((SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl))) UNION ALL SELECT q2 FROM int8_tbl;
          q1         
  -------------------
                 123
+   4567890123456789
                 456
    4567890123456789
                 123
***************
*** 416,423 ****
  SELECT q1 FROM int8_tbl EXCEPT (((SELECT q2 FROM int8_tbl ORDER BY q2 LIMIT 1)));
          q1        
  ------------------
-  4567890123456789
                123
  (2 rows)
  
  --
--- 416,423 ----
  SELECT q1 FROM int8_tbl EXCEPT (((SELECT q2 FROM int8_tbl ORDER BY q2 LIMIT 1)));
          q1        
  ------------------
                123
+  4567890123456789
  (2 rows)
  
  --

======================================================================