*** expected/float8.out	Sat Jan 23 18:12:59 1999
--- results/float8.out	Mon Aug 23 21:40:50 1999
***************
*** 189,201 ****
  QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
  ERROR:  Bad float8 input format -- overflow
  QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
! ERROR:  pow() result is out of range
  QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
  ERROR:  can't take log of zero
  QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
  ERROR:  can't take log of a negative number
  QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
! ERROR:  exp() result is out of range
  QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
  ERROR:  float8div: divide by zero error
  QUERY: SELECT '' AS five, FLOAT8_TBL.*;
--- 189,217 ----
  QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
  ERROR:  Bad float8 input format -- overflow
  QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
! bad|?column?
! ---+--------
!    |0       
!    |NaN     
!    |NaN     
!    |NaN     
!    |NaN     
! (5 rows)
! 
  QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ;
  ERROR:  can't take log of zero
  QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ;
  ERROR:  can't take log of a negative number
  QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
! bad|            ?column?
! ---+--------------------
!    |                   1
!    |7.39912306090513e-16
!    |                   0
!    |                   0
!    |                   1
! (5 rows)
! 
  QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
  ERROR:  float8div: divide by zero error
  QUERY: SELECT '' AS five, FLOAT8_TBL.*;

----------------------

*** expected/geometry.out	Sun Dec 13 17:49:18 1998
--- results/geometry.out	Mon Aug 23 21:40:59 1999
***************
*** 112,118 ****
        |(-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.3864610140473) 
        |(-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) 
--- 112,118 ----
        |(-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) 
***************
*** 409,433 ****
  QUERY: SELECT '' AS six, polygon(f1)
     FROM CIRCLE_TBL;
  six|polygon                                                                                                                                                                                                                                                                             
! ---+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!    |((-3,0),(-2.59807621135332,1.5),(-1.5,2.59807621135332),(-1.83690953073357e-16,3),(1.5,2.59807621135332),(2.59807621135332,1.5),(3,3.67381906146713e-16),(2.59807621135332,-1.5),(1.5,-2.59807621135332),(5.5107285922007e-16,-3),(-1.5,-2.59807621135332),(-2.59807621135332,-1.5))
!    |((-99,2),(-85.6025403784439,52),(-49,88.6025403784439),(0.999999999999994,102),(51,88.6025403784439),(87.6025403784439,52),(101,2.00000000000001),(87.6025403784439,-48),(51,-84.6025403784438),(1.00000000000002,-98),(-49,-84.6025403784439),(-85.6025403784438,-48))             
!    |((-4,3),(-3.33012701892219,5.5),(-1.5,7.33012701892219),(1,8),(3.5,7.33012701892219),(5.33012701892219,5.5),(6,3),(5.33012701892219,0.500000000000001),(3.5,-1.33012701892219),(1,-2),(-1.5,-1.33012701892219),(-3.33012701892219,0.499999999999998))                               
!    |((-2,2),(-1.59807621135332,3.5),(-0.5,4.59807621135332),(1,5),(2.5,4.59807621135332),(3.59807621135332,3.5),(4,2),(3.59807621135332,0.500000000000001),(2.5,-0.598076211353315),(1,-1),(-0.5,-0.598076211353316),(-1.59807621135332,0.499999999999999))                             
!    |((90,200),(91.3397459621556,205),(95,208.660254037844),(100,210),(105,208.660254037844),(108.660254037844,205),(110,200),(108.660254037844,195),(105,191.339745962156),(100,190),(95,191.339745962156),(91.3397459621556,195))                                                      
!    |((0,0),(13.3974596215561,50),(50,86.6025403784439),(100,100),(150,86.6025403784439),(186.602540378444,50),(200,1.22460635382238e-14),(186.602540378444,-50),(150,-86.6025403784438),(100,-100),(50,-86.6025403784439),(13.3974596215562,-50))                                       
  (6 rows)
  
  QUERY: SELECT '' AS six, polygon(8, f1)
     FROM CIRCLE_TBL;
  six|polygon                                                                                                                                                                                                                                 
! ---+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!    |((-3,0),(-2.12132034355964,2.12132034355964),(-1.83690953073357e-16,3),(2.12132034355964,2.12132034355964),(3,3.67381906146713e-16),(2.12132034355964,-2.12132034355964),(5.5107285922007e-16,-3),(-2.12132034355964,-2.12132034355964))
!    |((-99,2),(-69.7106781186548,72.7106781186548),(0.999999999999994,102),(71.7106781186547,72.7106781186548),(101,2.00000000000001),(71.7106781186548,-68.7106781186547),(1.00000000000002,-98),(-69.7106781186547,-68.7106781186548))     
!    |((-4,3),(-2.53553390593274,6.53553390593274),(1,8),(4.53553390593274,6.53553390593274),(6,3),(4.53553390593274,-0.535533905932737),(1,-2),(-2.53553390593274,-0.535533905932738))                                                       
!    |((-2,2),(-1.12132034355964,4.12132034355964),(1,5),(3.12132034355964,4.12132034355964),(4,2),(3.12132034355964,-0.121320343559642),(1,-1),(-1.12132034355964,-0.121320343559643))                                                       
!    |((90,200),(92.9289321881345,207.071067811865),(100,210),(107.071067811865,207.071067811865),(110,200),(107.071067811865,192.928932188135),(100,190),(92.9289321881345,192.928932188135))                                                
!    |((0,0),(29.2893218813452,70.7106781186548),(100,100),(170.710678118655,70.7106781186548),(200,1.22460635382238e-14),(170.710678118655,-70.7106781186547),(100,-100),(29.2893218813453,-70.7106781186548))                               
  (6 rows)
  
  QUERY: SELECT '' AS six, circle(f1, 50.0)
--- 409,433 ----
  QUERY: SELECT '' AS six, polygon(f1)
     FROM CIRCLE_TBL;
  six|polygon                                                                                                                                                                                                                                                                                                                                                                                    
! ---+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!    |((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359078377e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718156754e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077235131e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138))
!    |((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795))     
!    |((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887966),(-3.33012701896897,0.500000000081028))           
!    |((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048617))        
!    |((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))             
!    |((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239385585e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))        
  (6 rows)
  
  QUERY: SELECT '' AS six, polygon(8, f1)
     FROM CIRCLE_TBL;
  six|polygon                                                                                                                                                                                                                                  
! ---+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!    |((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359078377e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718156754e-11),(2.12132034353258,-2.12132034358671),(-4.59307077235131e-11,-3),(-2.12132034359753,-2.12132034352175))
!    |((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.710678119196,72.7106781181134),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))       
!    |((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))           
!    |((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))           
!    |((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))           
!    |((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181134),(200,-1.02068239385585e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))       
  (6 rows)
  
  QUERY: SELECT '' AS six, circle(f1, 50.0)

----------------------

*** expected/copy.out	Mon Aug 23 21:40:32 1999
--- results/copy.out	Mon Aug 23 21:42:28 1999
***************
*** 1,8 ****
--- 1,10 ----
  QUERY: COPY aggtest FROM '/usr/src/pgsql/src/test/regress/input/../data/agg.data';
  QUERY: COPY onek FROM '/usr/src/pgsql/src/test/regress/input/../data/onek.data';
  QUERY: COPY onek TO '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
+ ERROR:  COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/onek.data' for writing.  Errno = Permission denied (13).
  QUERY: DELETE FROM onek;
  QUERY: COPY onek FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
+ ERROR:  COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/onek.data' for reading.  Errno = No such file or directory (2).
  QUERY: COPY tenk1 FROM '/usr/src/pgsql/src/test/regress/input/../data/tenk.data';
  QUERY: COPY slow_emp4000 FROM '/usr/src/pgsql/src/test/regress/input/../data/rect.data';
  QUERY: COPY person FROM '/usr/src/pgsql/src/test/regress/input/../data/person.data';

----------------------

*** expected/select.out	Mon Feb  1 21:45:39 1999
--- results/select.out	Mon Aug 23 21:44:00 1999
***************
*** 1,176 ****
  QUERY: SELECT onek.* WHERE onek.unique1 < 10;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!       0|    998|  0|   0|  0|     0|      0|       0|          0|        0|       0|  0|   1|AAAAAA  |KMBAAA  |OOOOxx 
!       1|    214|  1|   1|  1|     1|      1|       1|          1|        1|       1|  2|   3|BAAAAA  |GIAAAA  |OOOOxx 
!       2|    326|  0|   2|  2|     2|      2|       2|          2|        2|       2|  4|   5|CAAAAA  |OMAAAA  |OOOOxx 
!       3|    431|  1|   3|  3|     3|      3|       3|          3|        3|       3|  6|   7|DAAAAA  |PQAAAA  |VVVVxx 
!       4|    833|  0|   0|  4|     4|      4|       4|          4|        4|       4|  8|   9|EAAAAA  |BGBAAA  |HHHHxx 
!       5|    541|  1|   1|  5|     5|      5|       5|          5|        5|       5| 10|  11|FAAAAA  |VUAAAA  |HHHHxx 
!       6|    978|  0|   2|  6|     6|      6|       6|          6|        6|       6| 12|  13|GAAAAA  |QLBAAA  |OOOOxx 
!       7|    647|  1|   3|  7|     7|      7|       7|          7|        7|       7| 14|  15|HAAAAA  |XYAAAA  |VVVVxx 
!       8|    653|  0|   0|  8|     8|      8|       8|          8|        8|       8| 16|  17|IAAAAA  |DZAAAA  |HHHHxx 
!       9|     49|  1|   1|  9|     9|      9|       9|          9|        9|       9| 18|  19|JAAAAA  |XBAAAA  |HHHHxx 
! (10 rows)
  
  QUERY: SELECT onek.unique1, onek.stringu1
     WHERE onek.unique1 < 20
     ORDER BY unique1 using >;
  unique1|stringu1
  -------+--------
!      19|TAAAAA  
!      18|SAAAAA  
!      17|RAAAAA  
!      16|QAAAAA  
!      15|PAAAAA  
!      14|OAAAAA  
!      13|NAAAAA  
!      12|MAAAAA  
!      11|LAAAAA  
!      10|KAAAAA  
!       9|JAAAAA  
!       8|IAAAAA  
!       7|HAAAAA  
!       6|GAAAAA  
!       5|FAAAAA  
!       4|EAAAAA  
!       3|DAAAAA  
!       2|CAAAAA  
!       1|BAAAAA  
!       0|AAAAAA  
! (20 rows)
  
  QUERY: SELECT onek.unique1, onek.stringu1
     WHERE onek.unique1 > 980
     ORDER BY stringu1 using <;
  unique1|stringu1
  -------+--------
!     988|AMAAAA  
!     989|BMAAAA  
!     990|CMAAAA  
!     991|DMAAAA  
!     992|EMAAAA  
!     993|FMAAAA  
!     994|GMAAAA  
!     995|HMAAAA  
!     996|IMAAAA  
!     997|JMAAAA  
!     998|KMAAAA  
!     999|LMAAAA  
!     981|TLAAAA  
!     982|ULAAAA  
!     983|VLAAAA  
!     984|WLAAAA  
!     985|XLAAAA  
!     986|YLAAAA  
!     987|ZLAAAA  
! (19 rows)
  
  QUERY: SELECT onek.unique1, onek.string4
     WHERE onek.unique1 > 980
     ORDER BY string4 using <, unique1 using >;
  unique1|string4
  -------+-------
!     999|AAAAxx 
!     995|AAAAxx 
!     983|AAAAxx 
!     982|AAAAxx 
!     981|AAAAxx 
!     998|HHHHxx 
!     997|HHHHxx 
!     993|HHHHxx 
!     990|HHHHxx 
!     986|HHHHxx 
!     996|OOOOxx 
!     991|OOOOxx 
!     988|OOOOxx 
!     987|OOOOxx 
!     985|OOOOxx 
!     994|VVVVxx 
!     992|VVVVxx 
!     989|VVVVxx 
!     984|VVVVxx 
! (19 rows)
  
  QUERY: SELECT onek.unique1, onek.string4
     WHERE onek.unique1 > 980
     ORDER BY string4 using >, unique1 using <;
  unique1|string4
  -------+-------
!     984|VVVVxx 
!     989|VVVVxx 
!     992|VVVVxx 
!     994|VVVVxx 
!     985|OOOOxx 
!     987|OOOOxx 
!     988|OOOOxx 
!     991|OOOOxx 
!     996|OOOOxx 
!     986|HHHHxx 
!     990|HHHHxx 
!     993|HHHHxx 
!     997|HHHHxx 
!     998|HHHHxx 
!     981|AAAAxx 
!     982|AAAAxx 
!     983|AAAAxx 
!     995|AAAAxx 
!     999|AAAAxx 
! (19 rows)
  
  QUERY: SELECT onek.unique1, onek.string4
     WHERE onek.unique1 < 20
     ORDER BY unique1 using >, string4 using <;
  unique1|string4
  -------+-------
!      19|OOOOxx 
!      18|VVVVxx 
!      17|HHHHxx 
!      16|OOOOxx 
!      15|VVVVxx 
!      14|AAAAxx 
!      13|OOOOxx 
!      12|AAAAxx 
!      11|OOOOxx 
!      10|AAAAxx 
!       9|HHHHxx 
!       8|HHHHxx 
!       7|VVVVxx 
!       6|OOOOxx 
!       5|HHHHxx 
!       4|HHHHxx 
!       3|VVVVxx 
!       2|OOOOxx 
!       1|OOOOxx 
!       0|OOOOxx 
! (20 rows)
  
  QUERY: SELECT onek.unique1, onek.string4
     WHERE onek.unique1 < 20
     ORDER BY unique1 using <, string4 using >;
  unique1|string4
  -------+-------
!       0|OOOOxx 
!       1|OOOOxx 
!       2|OOOOxx 
!       3|VVVVxx 
!       4|HHHHxx 
!       5|HHHHxx 
!       6|OOOOxx 
!       7|VVVVxx 
!       8|HHHHxx 
!       9|HHHHxx 
!      10|AAAAxx 
!      11|OOOOxx 
!      12|AAAAxx 
!      13|OOOOxx 
!      14|AAAAxx 
!      15|VVVVxx 
!      16|OOOOxx 
!      17|HHHHxx 
!      18|VVVVxx 
!      19|OOOOxx 
! (20 rows)
  
  QUERY: SELECT two, stringu1, ten, string4
     INTO TABLE tmp
--- 1,49 ----
  QUERY: SELECT onek.* WHERE onek.unique1 < 10;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: SELECT onek.unique1, onek.stringu1
     WHERE onek.unique1 < 20
     ORDER BY unique1 using >;
  unique1|stringu1
  -------+--------
! (0 rows)
  
  QUERY: SELECT onek.unique1, onek.stringu1
     WHERE onek.unique1 > 980
     ORDER BY stringu1 using <;
  unique1|stringu1
  -------+--------
! (0 rows)
  
  QUERY: SELECT onek.unique1, onek.string4
     WHERE onek.unique1 > 980
     ORDER BY string4 using <, unique1 using >;
  unique1|string4
  -------+-------
! (0 rows)
  
  QUERY: SELECT onek.unique1, onek.string4
     WHERE onek.unique1 > 980
     ORDER BY string4 using >, unique1 using <;
  unique1|string4
  -------+-------
! (0 rows)
  
  QUERY: SELECT onek.unique1, onek.string4
     WHERE onek.unique1 < 20
     ORDER BY unique1 using >, string4 using <;
  unique1|string4
  -------+-------
! (0 rows)
  
  QUERY: SELECT onek.unique1, onek.string4
     WHERE onek.unique1 < 20
     ORDER BY unique1 using <, string4 using >;
  unique1|string4
  -------+-------
! (0 rows)
  
  QUERY: SELECT two, stringu1, ten, string4
     INTO TABLE tmp

----------------------

*** expected/select_distinct.out	Mon Feb  1 21:45:39 1999
--- results/select_distinct.out	Mon Aug 23 21:44:01 1999
***************
*** 1,80 ****
  QUERY: SELECT DISTINCT two FROM tmp;
  two
  ---
!   0
!   1
! (2 rows)
  
  QUERY: SELECT DISTINCT ten FROM tmp;
  ten
  ---
!   0
!   1
!   2
!   3
!   4
!   5
!   6
!   7
!   8
!   9
! (10 rows)
  
  QUERY: SELECT DISTINCT string4 FROM tmp;
  string4
  -------
! AAAAxx 
! HHHHxx 
! OOOOxx 
! VVVVxx 
! (4 rows)
  
  QUERY: SELECT DISTINCT two, string4, ten
     FROM tmp
     ORDER BY two using <, string4 using <, ten using <;
  two|string4|ten
  ---+-------+---
!   0|AAAAxx |  0
!   0|AAAAxx |  2
!   0|AAAAxx |  4
!   0|AAAAxx |  6
!   0|AAAAxx |  8
!   0|HHHHxx |  0
!   0|HHHHxx |  2
!   0|HHHHxx |  4
!   0|HHHHxx |  6
!   0|HHHHxx |  8
!   0|OOOOxx |  0
!   0|OOOOxx |  2
!   0|OOOOxx |  4
!   0|OOOOxx |  6
!   0|OOOOxx |  8
!   0|VVVVxx |  0
!   0|VVVVxx |  2
!   0|VVVVxx |  4
!   0|VVVVxx |  6
!   0|VVVVxx |  8
!   1|AAAAxx |  1
!   1|AAAAxx |  3
!   1|AAAAxx |  5
!   1|AAAAxx |  7
!   1|AAAAxx |  9
!   1|HHHHxx |  1
!   1|HHHHxx |  3
!   1|HHHHxx |  5
!   1|HHHHxx |  7
!   1|HHHHxx |  9
!   1|OOOOxx |  1
!   1|OOOOxx |  3
!   1|OOOOxx |  5
!   1|OOOOxx |  7
!   1|OOOOxx |  9
!   1|VVVVxx |  1
!   1|VVVVxx |  3
!   1|VVVVxx |  5
!   1|VVVVxx |  7
!   1|VVVVxx |  9
! (40 rows)
  
  QUERY: SELECT DISTINCT p.age FROM person* p ORDER BY age using >;
  age
--- 1,24 ----
  QUERY: SELECT DISTINCT two FROM tmp;
  two
  ---
! (0 rows)
  
  QUERY: SELECT DISTINCT ten FROM tmp;
  ten
  ---
! (0 rows)
  
  QUERY: SELECT DISTINCT string4 FROM tmp;
  string4
  -------
! (0 rows)
  
  QUERY: SELECT DISTINCT two, string4, ten
     FROM tmp
     ORDER BY two using <, string4 using <, ten using <;
  two|string4|ten
  ---+-------+---
! (0 rows)
  
  QUERY: SELECT DISTINCT p.age FROM person* p ORDER BY age using >;
  age

----------------------

*** expected/select_distinct_on.out	Mon Feb  1 21:45:40 1999
--- results/select_distinct_on.out	Mon Aug 23 21:44:01 1999
***************
*** 3,15 ****
     ORDER BY two using <, string4 using <, ten using <;
  two|string4|ten
  ---+-------+---
!   0|AAAAxx |  0
!   0|HHHHxx |  0
!   0|OOOOxx |  0
!   0|VVVVxx |  0
!   1|AAAAxx |  1
!   1|HHHHxx |  1
!   1|OOOOxx |  1
!   1|VVVVxx |  1
! (8 rows)
  
--- 3,7 ----
     ORDER BY two using <, string4 using <, ten using <;
  two|string4|ten
  ---+-------+---
! (0 rows)
  

----------------------

*** expected/aggregates.out	Tue Apr 29 09:23:15 1997
--- results/aggregates.out	Mon Aug 23 21:44:12 1999
***************
*** 1,7 ****
  QUERY: SELECT avg(four) AS avg_1 FROM onek;
  avg_1
  -----
!     1
  (1 row)
  
  QUERY: SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
--- 1,7 ----
  QUERY: SELECT avg(four) AS avg_1 FROM onek;
  avg_1
  -----
!      
  (1 row)
  
  QUERY: SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
***************
*** 25,31 ****
  QUERY: SELECT sum(four) AS sum_1500 FROM onek;
  sum_1500
  --------
!     1500
  (1 row)
  
  QUERY: SELECT sum(a) AS sum_198 FROM aggtest;
--- 25,31 ----
  QUERY: SELECT sum(four) AS sum_1500 FROM onek;
  sum_1500
  --------
!         
  (1 row)
  
  QUERY: SELECT sum(a) AS sum_198 FROM aggtest;
***************
*** 49,55 ****
  QUERY: SELECT max(four) AS max_3 FROM onek;
  max_3
  -----
!     3
  (1 row)
  
  QUERY: SELECT max(a) AS max_100 FROM aggtest;
--- 49,55 ----
  QUERY: SELECT max(four) AS max_3 FROM onek;
  max_3
  -----
!      
  (1 row)
  
  QUERY: SELECT max(a) AS max_100 FROM aggtest;
***************
*** 73,96 ****
  QUERY: SELECT count(four) AS cnt_1000 FROM onek;
  cnt_1000
  --------
!     1000
  (1 row)
  
  QUERY: SELECT newavg(four) AS avg_1 FROM onek;
  avg_1
  -----
!     1
  (1 row)
  
  QUERY: SELECT newsum(four) AS sum_1500 FROM onek;
  sum_1500
  --------
!     1500
  (1 row)
  
  QUERY: SELECT newcnt(four) AS cnt_1000 FROM onek;
  cnt_1000
  --------
!     1000
  (1 row)
  
--- 73,96 ----
  QUERY: SELECT count(four) AS cnt_1000 FROM onek;
  cnt_1000
  --------
!        0
  (1 row)
  
  QUERY: SELECT newavg(four) AS avg_1 FROM onek;
  avg_1
  -----
!     0
  (1 row)
  
  QUERY: SELECT newsum(four) AS sum_1500 FROM onek;
  sum_1500
  --------
!        0
  (1 row)
  
  QUERY: SELECT newcnt(four) AS cnt_1000 FROM onek;
  cnt_1000
  --------
!        0
  (1 row)
  

----------------------

*** expected/random.out	Mon Aug 17 11:11:15 1998
--- results/random.out	Mon Aug 23 21:44:14 1999
***************
*** 1,7 ****
  QUERY: SELECT count(*) FROM onek;
  count
  -----
!  1000
  (1 row)
  
  QUERY: SELECT count(*) AS random INTO RANDOM_TBL
--- 1,7 ----
  QUERY: SELECT count(*) FROM onek;
  count
  -----
!     0
  (1 row)
  
  QUERY: SELECT count(*) AS random INTO RANDOM_TBL
***************
*** 13,23 ****
    GROUP BY random HAVING count(random) > 1;
  random|count
  ------+-----
! (0 rows)
  
  QUERY: SELECT random FROM RANDOM_TBL
    WHERE random NOT BETWEEN 80 AND 120;
  random
  ------
! (0 rows)
  
--- 13,26 ----
    GROUP BY random HAVING count(random) > 1;
  random|count
  ------+-----
!      0|    2
! (1 row)
  
  QUERY: SELECT random FROM RANDOM_TBL
    WHERE random NOT BETWEEN 80 AND 120;
  random
  ------
!      0
!      0
! (2 rows)
  

----------------------

*** expected/misc.out	Mon Aug 23 21:40:32 1999
--- results/misc.out	Mon Aug 23 21:44:18 1999
***************
*** 12,45 ****
  	  onek2.stringu1 = tmp.stringu1;
  QUERY: DROP TABLE tmp;
  QUERY: COPY onek TO '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
  QUERY: DELETE FROM onek;
  QUERY: COPY onek FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
  QUERY: SELECT unique1 FROM onek WHERE unique1 < 2;
  unique1
  -------
!       0
!       1
! (2 rows)
  
  QUERY: DELETE FROM onek2;
  QUERY: COPY onek2 FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
  QUERY: SELECT unique1 FROM onek2 WHERE unique1 < 2;
  unique1
  -------
!       0
!       1
! (2 rows)
  
  QUERY: COPY BINARY stud_emp TO '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data';
  QUERY: DELETE FROM stud_emp;
  QUERY: COPY BINARY stud_emp FROM '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data';
  QUERY: SELECT * FROM stud_emp;
  name |age|location  |salary|manager|gpa|percent
! -----+---+----------+------+-------+---+-------
! jeff | 23|(8,7.7)   |   600|sharon |3.5|       
! cim  | 30|(10.5,4.7)|   400|       |3.4|       
! linda| 19|(0.9,6.1) |   100|       |2.9|       
! (3 rows)
  
  QUERY: SELECT * FROM a_star*;
  class| a
--- 12,43 ----
  	  onek2.stringu1 = tmp.stringu1;
  QUERY: DROP TABLE tmp;
  QUERY: COPY onek TO '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
+ ERROR:  COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/onek.data' for writing.  Errno = Permission denied (13).
  QUERY: DELETE FROM onek;
  QUERY: COPY onek FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
+ ERROR:  COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/onek.data' for reading.  Errno = No such file or directory (2).
  QUERY: SELECT unique1 FROM onek WHERE unique1 < 2;
  unique1
  -------
! (0 rows)
  
  QUERY: DELETE FROM onek2;
  QUERY: COPY onek2 FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data';
+ ERROR:  COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/onek.data' for reading.  Errno = No such file or directory (2).
  QUERY: SELECT unique1 FROM onek2 WHERE unique1 < 2;
  unique1
  -------
! (0 rows)
  
  QUERY: COPY BINARY stud_emp TO '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data';
+ ERROR:  COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data' for writing.  Errno = Permission denied (13).
  QUERY: DELETE FROM stud_emp;
  QUERY: COPY BINARY stud_emp FROM '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data';
+ ERROR:  COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data' for reading.  Errno = No such file or directory (2).
  QUERY: SELECT * FROM stud_emp;
  name|age|location|salary|manager|gpa|percent
! ----+---+--------+------+-------+---+-------
! (0 rows)
  
  QUERY: SELECT * FROM a_star*;
  class| a
***************
*** 376,383 ****
  mike |posthacking
  joe  |basketball 
  sally|basketball 
! jeff |posthacking
! (4 rows)
  
  QUERY: SELECT DISTINCT hobbies_r.name, hobbies_r.equipment.name FROM hobbies_r;
  name       |name         
--- 374,380 ----
  mike |posthacking
  joe  |basketball 
  sally|basketball 
! (3 rows)
  
  QUERY: SELECT DISTINCT hobbies_r.name, hobbies_r.equipment.name FROM hobbies_r;
  name       |name         
***************
*** 414,421 ****
  mike |posthacking|advil        
  joe  |basketball |peet's coffee
  sally|basketball |hightops     
! jeff |posthacking|advil        
! (4 rows)
  
  QUERY: SELECT p.hobbies.equipment.name, p.name, p.hobbies.name FROM person p;
  name    |name |name       
--- 411,417 ----
  mike |posthacking|advil        
  joe  |basketball |peet's coffee
  sally|basketball |hightops     
! (3 rows)
  
  QUERY: SELECT p.hobbies.equipment.name, p.name, p.hobbies.name FROM person p;
  name    |name |name       
***************
*** 431,438 ****
  advil   |mike |posthacking
  hightops|joe  |basketball 
  hightops|sally|basketball 
! advil   |jeff |posthacking
! (4 rows)
  
  QUERY: SELECT p.hobbies.equipment.name, p.hobbies.name, p.name FROM person p;
  name         |name       |name 
--- 427,433 ----
  advil   |mike |posthacking
  hightops|joe  |basketball 
  hightops|sally|basketball 
! (3 rows)
  
  QUERY: SELECT p.hobbies.equipment.name, p.hobbies.name, p.name FROM person p;
  name         |name       |name 
***************
*** 448,455 ****
  advil        |posthacking|mike 
  peet's coffee|basketball |joe  
  hightops     |basketball |sally
! advil        |posthacking|jeff 
! (4 rows)
  
  QUERY: SELECT user_relns() AS user_relns
     ORDER BY user_relns;
--- 443,449 ----
  advil        |posthacking|mike 
  peet's coffee|basketball |joe  
  hightops     |basketball |sally
! (3 rows)
  
  QUERY: SELECT user_relns() AS user_relns
     ORDER BY user_relns;

----------------------

*** expected/portals_p2.out	Mon May  5 01:43:59 1997
--- results/portals_p2.out	Mon Aug 23 21:44:38 1999
***************
*** 28,107 ****
  QUERY: FETCH all in foo13;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!      50|    253|  0|   2|  0|    10|      0|      50|         50|       50|      50|  0|   1|YBAAAA  |TJAAAA  |HHHHxx 
! (1 row)
  
  QUERY: FETCH all in foo14;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!      51|     76|  1|   3|  1|    11|      1|      51|         51|       51|      51|  2|   3|ZBAAAA  |YCAAAA  |AAAAxx 
! (1 row)
  
  QUERY: FETCH all in foo15;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!      52|    985|  0|   0|  2|    12|      2|      52|         52|       52|      52|  4|   5|ACAAAA  |XLBAAA  |HHHHxx 
! (1 row)
  
  QUERY: FETCH all in foo16;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!      53|    196|  1|   1|  3|    13|      3|      53|         53|       53|      53|  6|   7|BCAAAA  |OHAAAA  |AAAAxx 
! (1 row)
  
  QUERY: FETCH all in foo17;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!      54|    356|  0|   2|  4|    14|      4|      54|         54|       54|      54|  8|   9|CCAAAA  |SNAAAA  |AAAAxx 
! (1 row)
  
  QUERY: FETCH all in foo18;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!      55|    627|  1|   3|  5|    15|      5|      55|         55|       55|      55| 10|  11|DCAAAA  |DYAAAA  |VVVVxx 
! (1 row)
  
  QUERY: FETCH all in foo19;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!      56|     54|  0|   0|  6|    16|      6|      56|         56|       56|      56| 12|  13|ECAAAA  |CCAAAA  |OOOOxx 
! (1 row)
  
  QUERY: FETCH all in foo20;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!      57|    942|  1|   1|  7|    17|      7|      57|         57|       57|      57| 14|  15|FCAAAA  |GKBAAA  |OOOOxx 
! (1 row)
  
  QUERY: FETCH all in foo21;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!      58|    114|  0|   2|  8|    18|      8|      58|         58|       58|      58| 16|  17|GCAAAA  |KEAAAA  |OOOOxx 
! (1 row)
  
  QUERY: FETCH all in foo22;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!      59|    593|  1|   3|  9|    19|      9|      59|         59|       59|      59| 18|  19|HCAAAA  |VWAAAA  |HHHHxx 
! (1 row)
  
  QUERY: FETCH all in foo23;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!      60|    483|  0|   0|  0|     0|      0|      60|         60|       60|      60|  0|   1|ICAAAA  |PSAAAA  |VVVVxx 
! (1 row)
  
  QUERY: FETCH all in foo24;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!      50|    253|  0|   2|  0|    10|      0|      50|         50|       50|      50|  0|   1|YBAAAA  |TJAAAA  |HHHHxx 
! (1 row)
  
  QUERY: FETCH all in foo25;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
!      60|    483|  0|   0|  0|     0|      0|      60|         60|       60|      60|  0|   1|ICAAAA  |PSAAAA  |VVVVxx 
! (1 row)
  
  QUERY: CLOSE foo13;
  QUERY: CLOSE foo14;
--- 28,94 ----
  QUERY: FETCH all in foo13;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: FETCH all in foo14;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: FETCH all in foo15;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: FETCH all in foo16;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: FETCH all in foo17;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: FETCH all in foo18;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: FETCH all in foo19;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: FETCH all in foo20;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: FETCH all in foo21;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: FETCH all in foo22;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: FETCH all in foo23;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: FETCH all in foo24;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: FETCH all in foo25;
  unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4
  -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------
! (0 rows)
  
  QUERY: CLOSE foo13;
  QUERY: CLOSE foo14;

----------------------

*** expected/limit.out	Mon Feb  8 08:14:22 1999
--- results/limit.out	Mon Aug 23 21:45:16 1999
***************
*** 3,42 ****
  		ORDER BY unique1 LIMIT 2;
  two|unique1|unique2|stringu1
  ---+-------+-------+--------
!    |     51|     76|ZBAAAA  
!    |     52|    985|ACAAAA  
! (2 rows)
  
  QUERY: SELECT ''::text AS five, unique1, unique2, stringu1
  		FROM onek WHERE unique1 > 60
  		ORDER BY unique1 LIMIT 5;
  five|unique1|unique2|stringu1
  ----+-------+-------+--------
!     |     61|    560|JCAAAA  
!     |     62|    633|KCAAAA  
!     |     63|    296|LCAAAA  
!     |     64|    479|MCAAAA  
!     |     65|     64|NCAAAA  
! (5 rows)
  
  QUERY: SELECT ''::text AS two, unique1, unique2, stringu1
  		FROM onek WHERE unique1 > 60 AND unique1 < 63
  		ORDER BY unique1 LIMIT 5;
  two|unique1|unique2|stringu1
  ---+-------+-------+--------
!    |     61|    560|JCAAAA  
!    |     62|    633|KCAAAA  
! (2 rows)
  
  QUERY: SELECT ''::text AS three, unique1, unique2, stringu1
  		FROM onek WHERE unique1 > 100
  		ORDER BY unique1 LIMIT 3 OFFSET 20;
  three|unique1|unique2|stringu1
  -----+-------+-------+--------
!      |    121|    700|REAAAA  
!      |    122|    519|SEAAAA  
!      |    123|    777|TEAAAA  
! (3 rows)
  
  QUERY: SELECT ''::text AS zero, unique1, unique2, stringu1
  		FROM onek WHERE unique1 < 50
--- 3,30 ----
  		ORDER BY unique1 LIMIT 2;
  two|unique1|unique2|stringu1
  ---+-------+-------+--------
! (0 rows)
  
  QUERY: SELECT ''::text AS five, unique1, unique2, stringu1
  		FROM onek WHERE unique1 > 60
  		ORDER BY unique1 LIMIT 5;
  five|unique1|unique2|stringu1
  ----+-------+-------+--------
! (0 rows)
  
  QUERY: SELECT ''::text AS two, unique1, unique2, stringu1
  		FROM onek WHERE unique1 > 60 AND unique1 < 63
  		ORDER BY unique1 LIMIT 5;
  two|unique1|unique2|stringu1
  ---+-------+-------+--------
! (0 rows)
  
  QUERY: SELECT ''::text AS three, unique1, unique2, stringu1
  		FROM onek WHERE unique1 > 100
  		ORDER BY unique1 LIMIT 3 OFFSET 20;
  three|unique1|unique2|stringu1
  -----+-------+-------+--------
! (0 rows)
  
  QUERY: SELECT ''::text AS zero, unique1, unique2, stringu1
  		FROM onek WHERE unique1 < 50
***************
*** 50,106 ****
  		ORDER BY unique1 DESC LIMIT 20 OFFSET 39;
  eleven|unique1|unique2|stringu1
  ------+-------+-------+--------
!       |     10|    520|KAAAAA  
!       |      9|     49|JAAAAA  
!       |      8|    653|IAAAAA  
!       |      7|    647|HAAAAA  
!       |      6|    978|GAAAAA  
!       |      5|    541|FAAAAA  
!       |      4|    833|EAAAAA  
!       |      3|    431|DAAAAA  
!       |      2|    326|CAAAAA  
!       |      1|    214|BAAAAA  
!       |      0|    998|AAAAAA  
! (11 rows)
  
  QUERY: SELECT ''::text AS ten, unique1, unique2, stringu1
  		FROM onek
  		ORDER BY unique1 OFFSET 990;
  ten|unique1|unique2|stringu1
  ---+-------+-------+--------
!    |    990|    369|CMAAAA  
!    |    991|    426|DMAAAA  
!    |    992|    363|EMAAAA  
!    |    993|    661|FMAAAA  
!    |    994|    695|GMAAAA  
!    |    995|    144|HMAAAA  
!    |    996|    258|IMAAAA  
!    |    997|     21|JMAAAA  
!    |    998|    549|KMAAAA  
!    |    999|    152|LMAAAA  
! (10 rows)
  
  QUERY: SELECT ''::text AS five, unique1, unique2, stringu1
  		FROM onek
  		ORDER BY unique1 OFFSET 990 LIMIT 5;
  five|unique1|unique2|stringu1
  ----+-------+-------+--------
!     |    990|    369|CMAAAA  
!     |    991|    426|DMAAAA  
!     |    992|    363|EMAAAA  
!     |    993|    661|FMAAAA  
!     |    994|    695|GMAAAA  
! (5 rows)
  
  QUERY: SELECT ''::text AS five, unique1, unique2, stringu1
  		FROM onek
  		ORDER BY unique1 LIMIT 5, 900;
  five|unique1|unique2|stringu1
  ----+-------+-------+--------
!     |    900|    913|QIAAAA  
!     |    901|    931|RIAAAA  
!     |    902|    702|SIAAAA  
!     |    903|    641|TIAAAA  
!     |    904|    793|UIAAAA  
! (5 rows)
  
--- 38,63 ----
  		ORDER BY unique1 DESC LIMIT 20 OFFSET 39;
  eleven|unique1|unique2|stringu1
  ------+-------+-------+--------
! (0 rows)
  
  QUERY: SELECT ''::text AS ten, unique1, unique2, stringu1
  		FROM onek
  		ORDER BY unique1 OFFSET 990;
  ten|unique1|unique2|stringu1
  ---+-------+-------+--------
! (0 rows)
  
  QUERY: SELECT ''::text AS five, unique1, unique2, stringu1
  		FROM onek
  		ORDER BY unique1 OFFSET 990 LIMIT 5;
  five|unique1|unique2|stringu1
  ----+-------+-------+--------
! (0 rows)
  
  QUERY: SELECT ''::text AS five, unique1, unique2, stringu1
  		FROM onek
  		ORDER BY unique1 LIMIT 5, 900;
  five|unique1|unique2|stringu1
  ----+-------+-------+--------
! (0 rows)
  

----------------------