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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749