FreeBSD 4.7: BETA3 (from port): regression failures...

Regression Diffs:

*** ./expected/geometry-positive-zeros-bsd.out	Tue Sep 12 16:07:16 2000
--- ./results/geometry.out	Mon Oct 28 00:06:41 2002
***************
*** 114,120 ****
          | (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)
--- 114,120 ----
          | (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)
***************
*** 224,233 ****
   twentyfour |          rotation           
  ------------+-----------------------------
              | (0,0),(0,0)
!             | (0,0),(-20,-20)
!             | (0,2),(-14,0)
              | (0,79.2),(-58.8,0)
!             | (14,0),(0,-34)
              | (0,40),(0,0)
              | (0,0),(0,0)
              | (-10,-10),(-30,-30)
--- 224,233 ----
   twentyfour |          rotation           
  ------------+-----------------------------
              | (0,0),(0,0)
!             | (-0,0),(-20,-20)
!             | (-0,2),(-14,0)
              | (0,79.2),(-58.8,0)
!             | (14,-0),(0,-34)
              | (0,40),(0,0)
              | (0,0),(0,0)
              | (-10,-10),(-30,-30)
***************
*** 254,264 ****
     WHERE (p.f1 <-> point '(0,0)') >= 1;
   twenty |                                     rotation                                      
  --------+-----------------------------------------------------------------------------------
!         | (0,0),(-0.2,-0.2)
          | (-0.1,-0.1),(-0.3,-0.3)
          | (-0.25,-0.25),(-0.25,-0.35)
          | (-0.3,-0.3),(-0.3,-0.3)
!         | (0.08,0),(0,-0.56)
          | (0.12,-0.28),(0.04,-0.84)
          | (0.26,-0.7),(0.1,-0.82)
          | (0.12,-0.84),(0.12,-0.84)
--- 254,264 ----
     WHERE (p.f1 <-> point '(0,0)') >= 1;
   twenty |                                     rotation                                      
  --------+-----------------------------------------------------------------------------------
!         | (0,-0),(-0.2,-0.2)
          | (-0.1,-0.1),(-0.3,-0.3)
          | (-0.25,-0.25),(-0.25,-0.35)
          | (-0.3,-0.3),(-0.3,-0.3)
!         | (0.08,-0),(0,-0.56)
          | (0.12,-0.28),(0.04,-0.84)
          | (0.26,-0.7),(0.1,-0.82)
          | (0.12,-0.84),(0.12,-0.84)
***************
*** 266,272 ****
          | (0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825)
          | (0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521)
          | (0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
!         | (0,0.0828402366863905),(-0.201183431952663,0)
          | (-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953)
          | (-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201)
          | (-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)
--- 266,272 ----
          | (0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825)
          | (0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521)
          | (0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
!         | (-0,0.0828402366863905),(-0.201183431952663,0)
          | (-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953)
          | (-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201)
          | (-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)

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

*** ./expected/horology.out	Wed Sep 18 16:35:25 2002
--- ./results/horology.out	Mon Oct 28 00:06:41 2002
***************
*** 537,549 ****
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
   True 
  ------
!  t
  (1 row)

SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
True
------
! t
(1 row)

  SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
--- 537,549 ----
  SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
   True 
  ------
!  f
  (1 row)

SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
True
------
! f
(1 row)

SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";

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

*** ./expected/copy.out	Mon Oct 28 00:06:11 2002
--- ./results/copy.out	Mon Oct 28 00:06:49 2002
***************
*** 7,14 ****
--- 7,16 ----
  COPY aggtest FROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/data/agg.data';
  COPY onek FROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/data/onek.data';
  COPY onek TO '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
+ ERROR:  COPY command, running in backend with effective uid 70, could not open file '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data' for writing.  Errno = Permission denied (13).
  DELETE FROM onek;
  COPY onek FROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
+ ERROR:  COPY command, running in backend with effective uid 70, could not open file '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data' for reading.  Errno = No such file or directory (2).
  COPY tenk1 FROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/data/tenk.data';
  COPY slow_emp4000 FROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/data/rect.data';
  COPY person FROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/data/person.data';

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

*** ./expected/select.out	Thu Jul 18 12:11:49 2002
--- ./results/select.out	Mon Oct 28 00:07:02 2002
***************
*** 8,24 ****
     ORDER BY onek.unique1;
   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)

  --
  -- awk '{if($1<20){print $1,$14;}else{next;}}' onek.data | sort +0nr -1
--- 8,14 ----
     ORDER BY onek.unique1;
   unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 
  ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

--
-- awk '{if($1<20){print $1,$14;}else{next;}}' onek.data | sort +0nr -1
***************
*** 28,54 ****
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)

  --
  -- awk '{if($1>980){print $1,$14;}else{next;}}' onek.data | sort +1d -2
--- 18,24 ----
     ORDER BY unique1 using >;
   unique1 | stringu1 
  ---------+----------
! (0 rows)

--
-- awk '{if($1>980){print $1,$14;}else{next;}}' onek.data | sort +1d -2
***************
*** 58,83 ****
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)

  --
--- 28,34 ----
     ORDER BY stringu1 using <;
   unique1 | stringu1 
  ---------+----------
! (0 rows)

--
***************
*** 89,114 ****
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)

  --
--- 40,46 ----
     ORDER BY string4 using <, unique1 using >;
   unique1 | string4 
  ---------+---------
! (0 rows)

--
***************
*** 120,145 ****
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)

  --
--- 52,58 ----
     ORDER BY string4 using >, unique1 using <;
   unique1 | string4 
  ---------+---------
! (0 rows)

--
***************
*** 151,177 ****
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)

  --
  -- awk '{if($1<20){print $1,$16;}else{next;}}' onek.data |
--- 64,70 ----
     ORDER BY unique1 using >, string4 using <;
   unique1 | string4 
  ---------+---------
! (0 rows)

--
-- awk '{if($1<20){print $1,$16;}else{next;}}' onek.data |
***************
*** 182,208 ****
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)

  --
  -- test partial btree indexes
--- 75,81 ----
     ORDER BY unique1 using <, string4 using >;
   unique1 | string4 
  ---------+---------
! (0 rows)

--
-- test partial btree indexes
***************
*** 217,233 ****
SELECT onek2.* WHERE onek2.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)

  --
  -- awk '{if($1<20){print $1,$14;}else{next;}}' onek.data | sort +0nr -1
--- 90,96 ----
  SELECT onek2.* WHERE onek2.unique1 < 10;
   unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 
  ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

--
-- awk '{if($1<20){print $1,$14;}else{next;}}' onek.data | sort +0nr -1
***************
*** 237,263 ****
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)

  --
  -- awk '{if($1>980){print $1,$14;}else{next;}}' onek.data | sort +1d -2
--- 100,106 ----
      ORDER BY unique1 using >;
   unique1 | stringu1 
  ---------+----------
! (0 rows)

--
-- awk '{if($1>980){print $1,$14;}else{next;}}' onek.data | sort +1d -2
***************
*** 266,291 ****
WHERE onek2.unique1 > 980;
unique1 | stringu1
---------+----------
! 981 | TLAAAA
! 982 | ULAAAA
! 983 | VLAAAA
! 984 | WLAAAA
! 985 | XLAAAA
! 986 | YLAAAA
! 987 | ZLAAAA
! 988 | AMAAAA
! 989 | BMAAAA
! 990 | CMAAAA
! 991 | DMAAAA
! 992 | EMAAAA
! 993 | FMAAAA
! 994 | GMAAAA
! 995 | HMAAAA
! 996 | IMAAAA
! 997 | JMAAAA
! 998 | KMAAAA
! 999 | LMAAAA
! (19 rows)

  SELECT two, stringu1, ten, string4
     INTO TABLE tmp
--- 109,115 ----
     WHERE onek2.unique1 > 980;
   unique1 | stringu1 
  ---------+----------
! (0 rows)

SELECT two, stringu1, ten, string4
INTO TABLE tmp

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

*** ./expected/select_distinct.out	Thu Jan  6 00:40:54 2000
--- ./results/select_distinct.out	Mon Oct 28 00:07:03 2002
***************
*** 7,15 ****
  SELECT DISTINCT two FROM tmp;
   two 
  -----
!    0
!    1
! (2 rows)

  --
  -- awk '{print $5;}' onek.data | sort -n | uniq
--- 7,13 ----
  SELECT DISTINCT two FROM tmp;
   two 
  -----
! (0 rows)

--
-- awk '{print $5;}' onek.data | sort -n | uniq
***************
*** 17,33 ****
SELECT DISTINCT ten FROM tmp;
ten
-----
! 0
! 1
! 2
! 3
! 4
! 5
! 6
! 7
! 8
! 9
! (10 rows)

  --
  -- awk '{print $16;}' onek.data | sort -d | uniq
--- 15,21 ----
  SELECT DISTINCT ten FROM tmp;
   ten 
  -----
! (0 rows)

--
-- awk '{print $16;}' onek.data | sort -d | uniq
***************
*** 35,45 ****
SELECT DISTINCT string4 FROM tmp;
string4
---------
! AAAAxx
! HHHHxx
! OOOOxx
! VVVVxx
! (4 rows)

  --
  -- awk '{print $3,$16,$5;}' onek.data | sort -d | uniq |
--- 23,29 ----
  SELECT DISTINCT string4 FROM tmp;
   string4 
  ---------
! (0 rows)

--
-- awk '{print $3,$16,$5;}' onek.data | sort -d | uniq |
***************
*** 50,96 ****
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)

  --
  -- awk '{print $2;}' person.data |
--- 34,40 ----
     ORDER BY two using <, string4 using <, ten using <;
   two | string4 | ten 
  -----+---------+-----
! (0 rows)

--
-- awk '{print $2;}' person.data |

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

*** ./expected/select_distinct_on.out	Thu Jan 27 12:11:50 2000
--- ./results/select_distinct_on.out	Mon Oct 28 00:07:03 2002
***************
*** 6,16 ****
     ORDER BY string4 using <, two using >, ten using <;
   string4 | two | ten 
  ---------+-----+-----
!  AAAAxx  |   1 |   1
!  HHHHxx  |   1 |   1
!  OOOOxx  |   1 |   1
!  VVVVxx  |   1 |   1
! (4 rows)

  -- this will fail due to conflict of ordering requirements
  SELECT DISTINCT ON (string4, ten) string4, two, ten
--- 6,12 ----
     ORDER BY string4 using <, two using >, ten using <;
   string4 | two | ten 
  ---------+-----+-----
! (0 rows)

-- this will fail due to conflict of ordering requirements
SELECT DISTINCT ON (string4, ten) string4, two, ten
***************
*** 22,66 ****
ORDER BY string4 using <, ten using >, two using <;
string4 | ten | two
---------+-----+-----
! AAAAxx | 9 | 1
! AAAAxx | 8 | 0
! AAAAxx | 7 | 1
! AAAAxx | 6 | 0
! AAAAxx | 5 | 1
! AAAAxx | 4 | 0
! AAAAxx | 3 | 1
! AAAAxx | 2 | 0
! AAAAxx | 1 | 1
! AAAAxx | 0 | 0
! HHHHxx | 9 | 1
! HHHHxx | 8 | 0
! HHHHxx | 7 | 1
! HHHHxx | 6 | 0
! HHHHxx | 5 | 1
! HHHHxx | 4 | 0
! HHHHxx | 3 | 1
! HHHHxx | 2 | 0
! HHHHxx | 1 | 1
! HHHHxx | 0 | 0
! OOOOxx | 9 | 1
! OOOOxx | 8 | 0
! OOOOxx | 7 | 1
! OOOOxx | 6 | 0
! OOOOxx | 5 | 1
! OOOOxx | 4 | 0
! OOOOxx | 3 | 1
! OOOOxx | 2 | 0
! OOOOxx | 1 | 1
! OOOOxx | 0 | 0
! VVVVxx | 9 | 1
! VVVVxx | 8 | 0
! VVVVxx | 7 | 1
! VVVVxx | 6 | 0
! VVVVxx | 5 | 1
! VVVVxx | 4 | 0
! VVVVxx | 3 | 1
! VVVVxx | 2 | 0
! VVVVxx | 1 | 1
! VVVVxx | 0 | 0
! (40 rows)

--- 18,22 ----
     ORDER BY string4 using <, ten using >, two using <;
   string4 | ten | two 
  ---------+-----+-----
! (0 rows)

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

*** ./expected/aggregates.out	Wed Oct  2 14:21:26 2002
--- ./results/aggregates.out	Mon Oct 28 00:07:04 2002
***************
*** 3,10 ****
  --
  SELECT avg(four) AS avg_1 FROM onek;
          avg_1        
! ---------------------
!  1.50000000000000000
  (1 row)

  SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
--- 3,10 ----
  --
  SELECT avg(four) AS avg_1 FROM onek;
   avg_1 
! -------
!       
  (1 row)

SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
***************
*** 30,36 ****
SELECT sum(four) AS sum_1500 FROM onek;
sum_1500
----------
! 1500
(1 row)

  SELECT sum(a) AS sum_198 FROM aggtest;
--- 30,36 ----
  SELECT sum(four) AS sum_1500 FROM onek;
   sum_1500 
  ----------
!          
  (1 row)

SELECT sum(a) AS sum_198 FROM aggtest;
***************
*** 54,60 ****
SELECT max(four) AS max_3 FROM onek;
max_3
-------
! 3
(1 row)

  SELECT max(a) AS max_100 FROM aggtest;
--- 54,60 ----
  SELECT max(four) AS max_3 FROM onek;
   max_3 
  -------
!       
  (1 row)

SELECT max(a) AS max_100 FROM aggtest;
***************
*** 78,137 ****
SELECT count(four) AS cnt_1000 FROM onek;
cnt_1000
----------
! 1000
(1 row)

SELECT count(DISTINCT four) AS cnt_4 FROM onek;
cnt_4
-------
! 4
(1 row)

select ten, count(*), sum(four) from onek group by ten;
ten | count | sum
-----+-------+-----
! 0 | 100 | 100
! 1 | 100 | 200
! 2 | 100 | 100
! 3 | 100 | 200
! 4 | 100 | 100
! 5 | 100 | 200
! 6 | 100 | 100
! 7 | 100 | 200
! 8 | 100 | 100
! 9 | 100 | 200
! (10 rows)

select ten, count(four), sum(DISTINCT four) from onek group by ten;
ten | count | sum
-----+-------+-----
! 0 | 100 | 2
! 1 | 100 | 4
! 2 | 100 | 2
! 3 | 100 | 4
! 4 | 100 | 2
! 5 | 100 | 4
! 6 | 100 | 2
! 7 | 100 | 4
! 8 | 100 | 2
! 9 | 100 | 4
! (10 rows)

SELECT newavg(four) AS avg_1 FROM onek;
avg_1
! ---------------------
! 1.50000000000000000
(1 row)

SELECT newsum(four) AS sum_1500 FROM onek;
sum_1500
----------
! 1500
(1 row)

SELECT newcnt(four) AS cnt_1000 FROM onek;
cnt_1000
----------
! 1000
(1 row)

--- 78,117 ----
  SELECT count(four) AS cnt_1000 FROM onek;
   cnt_1000 
  ----------
!         0
  (1 row)

SELECT count(DISTINCT four) AS cnt_4 FROM onek;
cnt_4
-------
! 0
(1 row)

select ten, count(*), sum(four) from onek group by ten;
ten | count | sum
-----+-------+-----
! (0 rows)

select ten, count(four), sum(DISTINCT four) from onek group by ten;
ten | count | sum
-----+-------+-----
! (0 rows)

SELECT newavg(four) AS avg_1 FROM onek;
avg_1
! -------
!
(1 row)

SELECT newsum(four) AS sum_1500 FROM onek;
sum_1500
----------
! 0
(1 row)

SELECT newcnt(four) AS cnt_1000 FROM onek;
cnt_1000
----------
! 0
(1 row)

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

*** ./expected/random.out	Thu Jan  6 00:40:54 2000
--- ./results/random.out	Mon Oct 28 00:07:05 2002
***************
*** 6,12 ****
  SELECT count(*) FROM onek;
   count 
  -------
!   1000
  (1 row)

  -- select roughly 1/10 of the tuples
--- 6,12 ----
  SELECT count(*) FROM onek;
   count 
  -------
!      0
  (1 row)

-- select roughly 1/10 of the tuples
***************
*** 25,35 ****
GROUP BY random HAVING count(random) > 1;
random | count
--------+-------
! (0 rows)

SELECT random FROM RANDOM_TBL
WHERE random NOT BETWEEN 80 AND 120;
random
--------
! (0 rows)

--- 25,38 ----
    GROUP BY random HAVING count(random) > 1;
   random | count 
  --------+-------
!       0 |     2
! (1 row)

SELECT random FROM RANDOM_TBL
WHERE random NOT BETWEEN 80 AND 120;
random
--------
! 0
! 0
! (2 rows)

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

*** ./expected/misc.out	Mon Oct 28 00:06:11 2002
--- ./results/misc.out	Mon Oct 28 00:07:06 2002
***************
*** 40,73 ****
  -- copy
  --
  COPY onek TO '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
  DELETE FROM onek;
  COPY onek FROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
  SELECT unique1 FROM onek WHERE unique1 < 2 ORDER BY unique1;
   unique1 
  ---------
!        0
!        1
! (2 rows)

DELETE FROM onek2;
COPY onek2 FROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
SELECT unique1 FROM onek2 WHERE unique1 < 2 ORDER BY unique1;
unique1
---------
! 0
! 1
! (2 rows)

COPY BINARY stud_emp TO '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/stud_emp.data';
DELETE FROM stud_emp;
COPY BINARY stud_emp FROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/stud_emp.data';
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)

  -- COPY aggtest FROM stdin;
  -- 56	7.8
--- 40,71 ----
  -- copy
  --
  COPY onek TO '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
+ ERROR:  COPY command, running in backend with effective uid 70, could not open file '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data' for writing.  Errno = Permission denied (13).
  DELETE FROM onek;
  COPY onek FROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
+ ERROR:  COPY command, running in backend with effective uid 70, could not open file '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data' for reading.  Errno = No such file or directory (2).
  SELECT unique1 FROM onek WHERE unique1 < 2 ORDER BY unique1;
   unique1 
  ---------
! (0 rows)

  DELETE FROM onek2;
  COPY onek2 FROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data';
+ ERROR:  COPY command, running in backend with effective uid 70, could not open file '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/onek.data' for reading.  Errno = No such file or directory (2).
  SELECT unique1 FROM onek2 WHERE unique1 < 2 ORDER BY unique1;
   unique1 
  ---------
! (0 rows)

  COPY BINARY stud_emp TO '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/stud_emp.data';
+ ERROR:  COPY command, running in backend with effective uid 70, could not open file '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/stud_emp.data' for writing.  Errno = Permission denied (13).
  DELETE FROM stud_emp;
  COPY BINARY stud_emp FROM '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/stud_emp.data';
+ ERROR:  COPY command, running in backend with effective uid 70, could not open file '/usr/ports/databases/postgresql-devel/work/postgresql-7.3b3/src/test/regress/results/stud_emp.data' for reading.  Errno = No such file or directory (2).
  SELECT * FROM stud_emp;
   name | age | location | salary | manager | gpa | percent 
! ------+-----+----------+--------+---------+-----+---------
! (0 rows)

-- COPY aggtest FROM stdin;
-- 56 7.8
***************
*** 460,467 ****
mike | posthacking
joe | basketball
sally | basketball
! jeff | posthacking
! (4 rows)

  --
  -- the next two queries demonstrate how functions generate bogus duplicates.
--- 458,464 ----
   mike  | posthacking
   joe   | basketball
   sally | basketball
! (3 rows)

--
-- the next two queries demonstrate how functions generate bogus duplicates.
***************
*** 512,520 ****
mike | posthacking | peet's coffee
joe | basketball | hightops
sally | basketball | hightops
! jeff | posthacking | advil
! jeff | posthacking | peet's coffee
! (6 rows)

  --
  -- just like the last two, but make sure that the target list fixup and
--- 509,515 ----
   mike  | posthacking | peet's coffee
   joe   | basketball  | hightops
   sally | basketball  | hightops
! (4 rows)

--
-- just like the last two, but make sure that the target list fixup and
***************
*** 536,544 ****
peet's coffee | mike | posthacking
hightops | joe | basketball
hightops | sally | basketball
! advil | jeff | posthacking
! peet's coffee | jeff | posthacking
! (6 rows)

  SELECT (p.hobbies).equipment.name, name(p.hobbies), p.name FROM ONLY person p;
       name      |    name     | name  
--- 531,537 ----
   peet's coffee | mike  | posthacking
   hightops      | joe   | basketball
   hightops      | sally | basketball
! (4 rows)

SELECT (p.hobbies).equipment.name, name(p.hobbies), p.name FROM ONLY person p;
name | name | name
***************
*** 556,564 ****
peet's coffee | posthacking | mike
hightops | basketball | joe
hightops | basketball | sally
! advil | posthacking | jeff
! peet's coffee | posthacking | jeff
! (6 rows)

  SELECT user_relns() AS user_relns
     ORDER BY user_relns;
--- 549,555 ----
   peet's coffee | posthacking | mike
   hightops      | basketball  | joe
   hightops      | basketball  | sally
! (4 rows)

SELECT user_relns() AS user_relns
ORDER BY user_relns;

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

*** ./expected/portals_p2.out	Mon Jul 16 00:07:00 2001
--- ./results/portals_p2.out	Mon Oct 28 00:07:10 2002
***************
*** 31,110 ****
  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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

  CLOSE foo13;
  CLOSE foo14;
--- 31,97 ----
  FETCH all in foo13;
   unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 
  ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

FETCH all in foo14;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

FETCH all in foo15;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

FETCH all in foo16;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

FETCH all in foo17;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

FETCH all in foo18;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

FETCH all in foo19;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

FETCH all in foo20;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

FETCH all in foo21;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

FETCH all in foo22;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

FETCH all in foo23;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

FETCH all in foo24;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

FETCH all in foo25;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)

CLOSE foo13;
CLOSE foo14;

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

*** ./expected/limit.out	Fri Oct 19 21:55:39 2001
--- ./results/limit.out	Mon Oct 28 00:07:19 2002
***************
*** 7,46 ****
  		ORDER BY unique1 LIMIT 2;
   two | unique1 | unique2 | stringu1 
  -----+---------+---------+----------
!      |      51 |      76 | ZBAAAA
!      |      52 |     985 | ACAAAA
! (2 rows)

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)

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)

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)

  SELECT ''::text AS zero, unique1, unique2, stringu1 
  		FROM onek WHERE unique1 < 50 
--- 7,34 ----
  		ORDER BY unique1 LIMIT 2;
   two | unique1 | unique2 | stringu1 
  -----+---------+---------+----------
! (0 rows)

SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek WHERE unique1 > 60
ORDER BY unique1 LIMIT 5;
five | unique1 | unique2 | stringu1
------+---------+---------+----------
! (0 rows)

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)

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)

SELECT ''::text AS zero, unique1, unique2, stringu1
FROM onek WHERE unique1 < 50
***************
*** 54,110 ****
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)

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)

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)

SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek
ORDER BY unique1 LIMIT 5 OFFSET 900;
five | unique1 | unique2 | stringu1
------+---------+---------+----------
! | 900 | 913 | QIAAAA
! | 901 | 931 | RIAAAA
! | 902 | 702 | SIAAAA
! | 903 | 641 | TIAAAA
! | 904 | 793 | UIAAAA
! (5 rows)

--- 42,67 ----
  		ORDER BY unique1 DESC LIMIT 20 OFFSET 39;
   eleven | unique1 | unique2 | stringu1 
  --------+---------+---------+----------
! (0 rows)

SELECT ''::text AS ten, unique1, unique2, stringu1
FROM onek
ORDER BY unique1 OFFSET 990;
ten | unique1 | unique2 | stringu1
-----+---------+---------+----------
! (0 rows)

SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek
ORDER BY unique1 OFFSET 990 LIMIT 5;
five | unique1 | unique2 | stringu1
------+---------+---------+----------
! (0 rows)

SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek
ORDER BY unique1 LIMIT 5 OFFSET 900;
five | unique1 | unique2 | stringu1
------+---------+---------+----------
! (0 rows)

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

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749