v7.0.3 Regress Tests Errors - Mailing list pgsql-admin
| From | Paul Huppe |
|---|---|
| Subject | v7.0.3 Regress Tests Errors |
| Date | |
| Msg-id | 3A96673F.B48DDB15@NRCan.gc.ca Whole thread Raw |
| Responses |
Re: v7.0.3 Regress Tests Errors
Re: v7.0.3 Regress Tests Errors |
| List | pgsql-admin |
Hi,
I am installing v7.0.3 and just finished compiling the source. I ran
the regression tests and I am getting quite a few errors. I have
attached the output from the tests.
Thanks,
Paul.
*** expected/create_type.out Wed Jan 5 12:31:08 2000
--- results/create_type.out Fri Feb 23 08:14:26 2001
***************
*** 7,12 ****
--- 7,13 ----
output = widget_out,
alignment = double
);
+ ERROR: TypeCreate: function 'widget_in(opaque)' does not exist
CREATE TYPE city_budget (
internallength = 16,
input = int44in,
----------------------
*** expected/triggers.out Sat Jan 15 14:18:23 2000
--- results/triggers.out Fri Feb 23 08:14:46 2001
***************
*** 24,33 ****
--- 24,35 ----
for each row
execute procedure
check_primary_key ('fkey1', 'fkey2', 'pkeys', 'pkey1', 'pkey2');
+ ERROR: CreateTrigger: function check_primary_key() does not exist
create trigger check_fkeys_pkey2_exist
before insert or update on fkeys
for each row
execute procedure check_primary_key ('fkey3', 'fkeys2', 'pkey23');
+ ERROR: CreateTrigger: function check_primary_key() does not exist
--
-- For fkeys2:
-- (fkey21, fkey22) --> pkeys (pkey1, pkey2)
***************
*** 37,42 ****
--- 39,45 ----
for each row
execute procedure
check_primary_key ('fkey21', 'fkey22', 'pkeys', 'pkey1', 'pkey2');
+ ERROR: CreateTrigger: function check_primary_key() does not exist
--
-- For pkeys:
-- ON DELETE/UPDATE (pkey1, pkey2) CASCADE:
***************
*** 48,53 ****
--- 51,57 ----
execute procedure
check_foreign_key (2, 'cascade', 'pkey1', 'pkey2',
'fkeys', 'fkey1', 'fkey2', 'fkeys2', 'fkey21', 'fkey22');
+ ERROR: CreateTrigger: function check_foreign_key() does not exist
--
-- For fkeys2:
-- ON DELETE/UPDATE (pkey23) RESTRICT:
***************
*** 57,62 ****
--- 61,67 ----
before delete or update on fkeys2
for each row
execute procedure check_foreign_key (1, 'restrict', 'pkey23', 'fkeys', 'fkey3');
+ ERROR: CreateTrigger: function check_foreign_key() does not exist
insert into fkeys2 values (10, '1', 1);
insert into fkeys2 values (30, '3', 2);
insert into fkeys2 values (40, '4', 5);
***************
*** 63,69 ****
insert into fkeys2 values (50, '5', 3);
-- no key in pkeys
insert into fkeys2 values (70, '5', 3);
- ERROR: check_fkeys2_pkey_exist: tuple references non-existing key in pkeys
insert into fkeys values (10, '1', 2);
insert into fkeys values (30, '3', 3);
insert into fkeys values (40, '4', 2);
--- 68,73 ----
***************
*** 70,91 ****
insert into fkeys values (50, '5', 2);
-- no key in pkeys
insert into fkeys values (70, '5', 1);
- ERROR: check_fkeys_pkey_exist: tuple references non-existing key in pkeys
-- no key in fkeys2
insert into fkeys values (60, '6', 4);
- ERROR: check_fkeys_pkey2_exist: tuple references non-existing key in fkeys2
delete from pkeys where pkey1 = 30 and pkey2 = '3';
- NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted
- ERROR: check_fkeys2_fkey_restrict: tuple referenced in fkeys
delete from pkeys where pkey1 = 40 and pkey2 = '4';
- NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted
- NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted
update pkeys set pkey1 = 7, pkey2 = '70' where pkey1 = 50 and pkey2 = '5';
- NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted
- ERROR: check_fkeys2_fkey_restrict: tuple referenced in fkeys
update pkeys set pkey1 = 7, pkey2 = '70' where pkey1 = 10 and pkey2 = '1';
! NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted
! NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted
DROP TABLE pkeys;
DROP TABLE fkeys;
DROP TABLE fkeys2;
--- 74,86 ----
insert into fkeys values (50, '5', 2);
-- no key in pkeys
insert into fkeys values (70, '5', 1);
-- no key in fkeys2
insert into fkeys values (60, '6', 4);
delete from pkeys where pkey1 = 30 and pkey2 = '3';
delete from pkeys where pkey1 = 40 and pkey2 = '4';
update pkeys set pkey1 = 7, pkey2 = '70' where pkey1 = 50 and pkey2 = '5';
update pkeys set pkey1 = 7, pkey2 = '70' where pkey1 = 10 and pkey2 = '1';
! ERROR: Cannot insert a duplicate key into unique index pkeys_i
DROP TABLE pkeys;
DROP TABLE fkeys;
DROP TABLE fkeys2;
***************
*** 135,145 ****
--- 130,142 ----
for each row
execute procedure
ttdummy (price_on, price_off);
+ ERROR: CreateTrigger: function ttdummy() does not exist
create trigger ttserial
before insert or update on tttest
for each row
execute procedure
autoinc (price_on, ttdummy_seq);
+ ERROR: CreateTrigger: function autoinc() does not exist
insert into tttest values (1, 1, null);
insert into tttest values (2, 2, null);
insert into tttest values (3, 3, 0);
***************
*** 146,154 ****
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | 10 | 999999
! 2 | 2 | 20 | 999999
! 3 | 3 | 30 | 999999
(3 rows)
delete from tttest where price_id = 2;
--- 143,151 ----
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | | 999999
! 2 | 2 | | 999999
! 3 | 3 | 0 | 999999
(3 rows)
delete from tttest where price_id = 2;
***************
*** 155,164 ****
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | 10 | 999999
! 3 | 3 | 30 | 999999
! 2 | 2 | 20 | 40
! (3 rows)
-- what do we see ?
-- get current prices
--- 152,160 ----
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | | 999999
! 3 | 3 | 0 | 999999
! (2 rows)
-- what do we see ?
-- get current prices
***************
*** 165,172 ****
select * from tttest where price_off = 999999;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | 10 | 999999
! 3 | 3 | 30 | 999999
(2 rows)
-- change price for price_id == 3
--- 161,168 ----
select * from tttest where price_off = 999999;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | | 999999
! 3 | 3 | 0 | 999999
(2 rows)
-- change price for price_id == 3
***************
*** 174,184 ****
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | 10 | 999999
! 2 | 2 | 20 | 40
! 3 | 30 | 50 | 999999
! 3 | 3 | 30 | 50
! (4 rows)
-- now we want to change pric_id in ALL tuples
-- this gets us not what we need
--- 170,178 ----
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | | 999999
! 3 | 30 | 0 | 999999
! (2 rows)
-- now we want to change pric_id in ALL tuples
-- this gets us not what we need
***************
*** 186,215 ****
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | 10 | 999999
! 2 | 2 | 20 | 40
! 3 | 3 | 30 | 50
! 5 | 30 | 60 | 999999
! 3 | 30 | 50 | 60
! (5 rows)
-- restore data as before last update:
select set_ttdummy(0);
! set_ttdummy
! -------------
! 1
! (1 row)
!
delete from tttest where price_id = 5;
update tttest set price_off = 999999 where price_val = 30;
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | 10 | 999999
! 2 | 2 | 20 | 40
! 3 | 3 | 30 | 50
! 3 | 30 | 50 | 999999
! (4 rows)
-- and try change price_id now!
update tttest set price_id = 5 where price_id = 3;
--- 180,201 ----
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | | 999999
! 5 | 30 | 0 | 999999
! (2 rows)
-- restore data as before last update:
select set_ttdummy(0);
! ERROR: Function 'set_ttdummy(int4)' does not exist
! Unable to identify a function that satisfies the given argument types
! You may need to add explicit typecasts
delete from tttest where price_id = 5;
update tttest set price_off = 999999 where price_val = 30;
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | | 999999
! (1 row)
-- and try change price_id now!
update tttest set price_id = 5 where price_id = 3;
***************
*** 216,254 ****
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | 10 | 999999
! 2 | 2 | 20 | 40
! 5 | 3 | 30 | 50
! 5 | 30 | 50 | 999999
! (4 rows)
-- isn't it what we need ?
select set_ttdummy(1);
! set_ttdummy
! -------------
! 0
! (1 row)
!
-- we want to correct some "date"
update tttest set price_on = -1 where price_id = 1;
- ERROR: ttdummy (tttest): you can't change price_on and/or price_off columns (use set_ttdummy)
-- but this doesn't work
-- try in this way
select set_ttdummy(0);
! set_ttdummy
! -------------
! 1
! (1 row)
!
update tttest set price_on = -1 where price_id = 1;
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
- 2 | 2 | 20 | 40
- 5 | 3 | 30 | 50
- 5 | 30 | 50 | 999999
1 | 1 | -1 | 999999
! (4 rows)
-- isn't it what we need ?
-- get price for price_id == 5 as it was @ "date" 35
--- 202,229 ----
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 1 | 1 | | 999999
! (1 row)
-- isn't it what we need ?
select set_ttdummy(1);
! ERROR: Function 'set_ttdummy(int4)' does not exist
! Unable to identify a function that satisfies the given argument types
! You may need to add explicit typecasts
-- we want to correct some "date"
update tttest set price_on = -1 where price_id = 1;
-- but this doesn't work
-- try in this way
select set_ttdummy(0);
! ERROR: Function 'set_ttdummy(int4)' does not exist
! Unable to identify a function that satisfies the given argument types
! You may need to add explicit typecasts
update tttest set price_on = -1 where price_id = 1;
select * from tttest;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
1 | 1 | -1 | 999999
! (1 row)
-- isn't it what we need ?
-- get price for price_id == 5 as it was @ "date" 35
***************
*** 255,262 ****
select * from tttest where price_on <= 35 and price_off > 35 and price_id = 5;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! 5 | 3 | 30 | 50
! (1 row)
drop table tttest;
drop sequence ttdummy_seq;
--- 230,236 ----
select * from tttest where price_on <= 35 and price_off > 35 and price_id = 5;
price_id | price_val | price_on | price_off
----------+-----------+----------+-----------
! (0 rows)
drop table tttest;
drop sequence ttdummy_seq;
----------------------
*** expected/create_operator.out Wed Jan 5 12:31:08 2000
--- results/create_operator.out Fri Feb 23 08:14:41 2001
***************
*** 14,19 ****
--- 14,20 ----
commutator = >% ,
negator = >=%
);
+ ERROR: OperatorGet: right type 'widget' nonexistent
CREATE OPERATOR @#@ (
rightarg = int4, -- left unary
procedure = int4fac
----------------------
*** expected/create_index.out Wed Feb 16 22:40:00 2000
--- results/create_index.out Fri Feb 23 08:14:47 2001
***************
*** 58,67 ****
WHERE home_base @ '(200,200),(2000,1000)'::box
ORDER BY home_base USING <<;
home_base
! -----------------------
! (337,455),(240,359)
! (1444,403),(1346,344)
! (2 rows)
--
-- HASH
--- 58,65 ----
WHERE home_base @ '(200,200),(2000,1000)'::box
ORDER BY home_base USING <<;
home_base
! -----------
! (0 rows)
--
-- HASH
----------------------
*** expected/create_view.out Wed Jan 5 12:31:08 2000
--- results/create_view.out Fri Feb 23 08:14:53 2001
***************
*** 12,17 ****
--- 12,20 ----
interpt_pp(ih.thepath, r.thepath) AS exit
FROM ihighway ih, ramp r
WHERE ih.thepath ## r.thepath;
+ ERROR: Function 'interpt_pp(path, path)' does not exist
+ Unable to identify a function that satisfies the given argument types
+ You may need to add explicit typecasts
CREATE VIEW toyemp AS
SELECT name, age, location, 12*salary AS annualsal
FROM emp;
----------------------
*** expected/select.out Tue Feb 15 15:49:29 2000
--- results/select.out Fri Feb 23 08:15:08 2001
***************
*** 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)
--
-- partial btree index
--- 75,81 ----
ORDER BY unique1 using <, string4 using >;
unique1 | string4
---------+---------
! (0 rows)
--
-- partial btree index
***************
*** 235,300 ****
-- SELECT name, age FROM person*; ??? check if different
SELECT p.name, p.age FROM person* p;
name | age
! ---------+-----
! mike | 40
! joe | 20
! sally | 34
! sandra | 19
! alex | 30
! sue | 50
! denise | 24
! sarah | 88
! teresa | 38
! nan | 28
! leah | 68
! wendy | 78
! melissa | 28
! joan | 18
! mary | 8
! jane | 58
! liza | 38
! jean | 28
! jenifer | 38
! juanita | 58
! susan | 78
! zena | 98
! martie | 88
! chris | 78
! pat | 18
! zola | 58
! louise | 98
! edna | 18
! bertha | 88
! sumi | 38
! koko | 88
! gina | 18
! rean | 48
! sharon | 78
! paula | 68
! julie | 68
! belinda | 38
! karen | 48
! carina | 58
! diane | 18
! esther | 98
! trudy | 88
! fanny | 8
! carmen | 78
! lita | 25
! pamela | 48
! sandy | 38
! trisha | 88
! vera | 78
! velma | 68
! sharon | 25
! sam | 30
! bill | 20
! fred | 28
! larry | 60
! jeff | 23
! cim | 30
! linda | 19
! (58 rows)
--
-- awk '{print $1,$2;}' person.data |
--- 108,115 ----
-- SELECT name, age FROM person*; ??? check if different
SELECT p.name, p.age FROM person* p;
name | age
! ------+-----
! (0 rows)
--
-- awk '{print $1,$2;}' person.data |
***************
*** 305,368 ****
--
SELECT p.name, p.age FROM person* p ORDER BY age using >, name;
name | age
! ---------+-----
! esther | 98
! louise | 98
! zena | 98
! bertha | 88
! koko | 88
! martie | 88
! sarah | 88
! trisha | 88
! trudy | 88
! carmen | 78
! chris | 78
! sharon | 78
! susan | 78
! vera | 78
! wendy | 78
! julie | 68
! leah | 68
! paula | 68
! velma | 68
! larry | 60
! carina | 58
! jane | 58
! juanita | 58
! zola | 58
! sue | 50
! karen | 48
! pamela | 48
! rean | 48
! mike | 40
! belinda | 38
! jenifer | 38
! liza | 38
! sandy | 38
! sumi | 38
! teresa | 38
! sally | 34
! alex | 30
! cim | 30
! sam | 30
! fred | 28
! jean | 28
! melissa | 28
! nan | 28
! lita | 25
! sharon | 25
! denise | 24
! jeff | 23
! bill | 20
! joe | 20
! linda | 19
! sandra | 19
! diane | 18
! edna | 18
! gina | 18
! joan | 18
! pat | 18
! fanny | 8
! mary | 8
! (58 rows)
--- 120,125 ----
--
SELECT p.name, p.age FROM person* p ORDER BY age using >, name;
name | age
! ------+-----
! (0 rows)
----------------------
*** expected/select_distinct.out Thu Jan 6 01:40:54 2000
--- results/select_distinct.out Fri Feb 23 08:15:23 2001
***************
*** 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 |
***************
*** 102,126 ****
SELECT DISTINCT p.age FROM person* p ORDER BY age using >;
age
-----
! 98
! 88
! 78
! 68
! 60
! 58
! 50
! 48
! 40
! 38
! 34
! 30
! 28
! 25
! 24
! 23
! 20
! 19
! 18
! 8
! (20 rows)
--- 46,50 ----
SELECT DISTINCT p.age FROM person* p ORDER BY age using >;
age
-----
! (0 rows)
----------------------
*** expected/select_distinct_on.out Thu Jan 27 13:11:50 2000
--- results/select_distinct_on.out Fri Feb 23 08:15:21 2001
***************
*** 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 Sat Jan 8 22:48:37 2000
--- results/aggregates.out Fri Feb 23 08:15:29 2001
***************
*** 4,135 ****
SELECT avg(four) AS avg_1 FROM onek;
avg_1
-------
! 1
(1 row)
SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
avg_32
--------
! 32
(1 row)
SELECT avg(b) AS avg_107_943 FROM aggtest;
avg_107_943
-------------
! 107.943
(1 row)
SELECT avg(gpa) AS avg_3_4 FROM student;
avg_3_4
---------
! 3.4
(1 row)
SELECT sum(four) AS sum_1500 FROM onek;
sum_1500
----------
! 1500
(1 row)
SELECT sum(a) AS sum_198 FROM aggtest;
sum_198
---------
! 198
(1 row)
SELECT sum(b) AS avg_431_773 FROM aggtest;
avg_431_773
-------------
! 431.773
(1 row)
SELECT sum(gpa) AS avg_6_8 FROM student;
avg_6_8
---------
! 6.8
(1 row)
SELECT max(four) AS max_3 FROM onek;
max_3
-------
! 3
(1 row)
SELECT max(a) AS max_100 FROM aggtest;
max_100
---------
! 100
(1 row)
SELECT max(aggtest.b) AS max_324_78 FROM aggtest;
max_324_78
------------
! 324.78
(1 row)
SELECT max(student.gpa) AS max_3_7 FROM student;
max_3_7
---------
! 3.7
(1 row)
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
! (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)
--- 4,111 ----
SELECT avg(four) AS avg_1 FROM onek;
avg_1
-------
!
(1 row)
SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100;
avg_32
--------
!
(1 row)
SELECT avg(b) AS avg_107_943 FROM aggtest;
avg_107_943
-------------
!
(1 row)
SELECT avg(gpa) AS avg_3_4 FROM student;
avg_3_4
---------
!
(1 row)
SELECT sum(four) AS sum_1500 FROM onek;
sum_1500
----------
!
(1 row)
SELECT sum(a) AS sum_198 FROM aggtest;
sum_198
---------
!
(1 row)
SELECT sum(b) AS avg_431_773 FROM aggtest;
avg_431_773
-------------
!
(1 row)
SELECT sum(gpa) AS avg_6_8 FROM student;
avg_6_8
---------
!
(1 row)
SELECT max(four) AS max_3 FROM onek;
max_3
-------
!
(1 row)
SELECT max(a) AS max_100 FROM aggtest;
max_100
---------
!
(1 row)
SELECT max(aggtest.b) AS max_324_78 FROM aggtest;
max_324_78
------------
!
(1 row)
SELECT max(student.gpa) AS max_3_7 FROM student;
max_3_7
---------
!
(1 row)
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;
! ERROR: floating point exception! The last floating point operation either exceeded legal ranges or was a divide by
zero
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/transactions.out Sat Jan 8 22:48:39 2000
--- results/transactions.out Fri Feb 23 08:15:29 2001
***************
*** 33,42 ****
-- should have members again
SELECT * FROM aggtest;
a | b
! -----+---------
! 56 | 7.8
! 100 | 99.097
! 0 | 0.09561
! 42 | 324.78
! (4 rows)
--- 33,38 ----
-- should have members again
SELECT * FROM aggtest;
a | b
! ---+---
! (0 rows)
----------------------
*** expected/random.out Thu Jan 6 01:40:54 2000
--- results/random.out Fri Feb 23 08:15:27 2001
***************
*** 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/portals.out Sat Jan 8 22:48:37 2000
--- results/portals.out Fri Feb 23 08:15:31 2001
***************
*** 28,662 ****
FETCH 1 in foo1;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! (1 row)
FETCH 2 in foo2;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! (2 rows)
FETCH 3 in foo3;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! (3 rows)
FETCH 4 in foo4;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! (4 rows)
FETCH 5 in foo5;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! (5 rows)
FETCH 6 in foo6;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! (6 rows)
FETCH 7 in foo7;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! (7 rows)
FETCH 8 in foo8;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! (8 rows)
FETCH 9 in foo9;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! (9 rows)
FETCH 10 in foo10;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! (10 rows)
FETCH 11 in foo11;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! (11 rows)
FETCH 12 in foo12;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! (12 rows)
FETCH 13 in foo13;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! (13 rows)
FETCH 14 in foo14;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! (14 rows)
FETCH 15 in foo15;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143
|LCAAAA | OAAAAA | OOOOxx
! (15 rows)
FETCH 16 in foo16;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143
|LCAAAA | OAAAAA | OOOOxx
! 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13
|OKAAAA | PAAAAA | VVVVxx
! (16 rows)
FETCH 17 in foo17;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143
|LCAAAA | OAAAAA | OOOOxx
! 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13
|OKAAAA | PAAAAA | VVVVxx
! 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175
|FZAAAA | QAAAAA | AAAAxx
! (17 rows)
FETCH 18 in foo18;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143
|LCAAAA | OAAAAA | OOOOxx
! 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13
|OKAAAA | PAAAAA | VVVVxx
! 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175
|FZAAAA | QAAAAA | AAAAxx
! 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171
|NOAAAA | RAAAAA | HHHHxx
! (18 rows)
FETCH 19 in foo19;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143
|LCAAAA | OAAAAA | OOOOxx
! 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13
|OKAAAA | PAAAAA | VVVVxx
! 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175
|FZAAAA | QAAAAA | AAAAxx
! 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171
|NOAAAA | RAAAAA | HHHHxx
! 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43
|RUAAAA | SAAAAA | OOOOxx
! (19 rows)
FETCH 20 in foo20;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143
|LCAAAA | OAAAAA | OOOOxx
! 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13
|OKAAAA | PAAAAA | VVVVxx
! 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175
|FZAAAA | QAAAAA | AAAAxx
! 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171
|NOAAAA | RAAAAA | HHHHxx
! 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43
|RUAAAA | SAAAAA | OOOOxx
! 6969 | 19 | 1 | 1 | 9 | 9 | 69 | 969 | 969 | 1969 | 6969 | 138 | 139
|BIAAAA | TAAAAA | VVVVxx
! (20 rows)
FETCH 21 in foo21;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143
|LCAAAA | OAAAAA | OOOOxx
! 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13
|OKAAAA | PAAAAA | VVVVxx
! 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175
|FZAAAA | QAAAAA | AAAAxx
! 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171
|NOAAAA | RAAAAA | HHHHxx
! 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43
|RUAAAA | SAAAAA | OOOOxx
! 6969 | 19 | 1 | 1 | 9 | 9 | 69 | 969 | 969 | 1969 | 6969 | 138 | 139
|BIAAAA | TAAAAA | VVVVxx
! 9460 | 20 | 0 | 0 | 0 | 0 | 60 | 460 | 1460 | 4460 | 9460 | 120 | 121
|WZAAAA | UAAAAA | AAAAxx
! (21 rows)
FETCH 22 in foo22;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143
|LCAAAA | OAAAAA | OOOOxx
! 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13
|OKAAAA | PAAAAA | VVVVxx
! 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175
|FZAAAA | QAAAAA | AAAAxx
! 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171
|NOAAAA | RAAAAA | HHHHxx
! 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43
|RUAAAA | SAAAAA | OOOOxx
! 6969 | 19 | 1 | 1 | 9 | 9 | 69 | 969 | 969 | 1969 | 6969 | 138 | 139
|BIAAAA | TAAAAA | VVVVxx
! 9460 | 20 | 0 | 0 | 0 | 0 | 60 | 460 | 1460 | 4460 | 9460 | 120 | 121
|WZAAAA | UAAAAA | AAAAxx
! 59 | 21 | 1 | 3 | 9 | 19 | 59 | 59 | 59 | 59 | 59 | 118 | 119
|HCAAAA | VAAAAA | HHHHxx
! (22 rows)
FETCH 23 in foo23;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143
|LCAAAA | OAAAAA | OOOOxx
! 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13
|OKAAAA | PAAAAA | VVVVxx
! 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175
|FZAAAA | QAAAAA | AAAAxx
! 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171
|NOAAAA | RAAAAA | HHHHxx
! 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43
|RUAAAA | SAAAAA | OOOOxx
! 6969 | 19 | 1 | 1 | 9 | 9 | 69 | 969 | 969 | 1969 | 6969 | 138 | 139
|BIAAAA | TAAAAA | VVVVxx
! 9460 | 20 | 0 | 0 | 0 | 0 | 60 | 460 | 1460 | 4460 | 9460 | 120 | 121
|WZAAAA | UAAAAA | AAAAxx
! 59 | 21 | 1 | 3 | 9 | 19 | 59 | 59 | 59 | 59 | 59 | 118 | 119
|HCAAAA | VAAAAA | HHHHxx
! 8020 | 22 | 0 | 0 | 0 | 0 | 20 | 20 | 20 | 3020 | 8020 | 40 | 41
|MWAAAA | WAAAAA | OOOOxx
! (23 rows)
FETCH backward 1 in foo23;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 59 | 21 | 1 | 3 | 9 | 19 | 59 | 59 | 59 | 59 | 59 | 118 | 119
|HCAAAA | VAAAAA | HHHHxx
! (1 row)
FETCH backward 2 in foo22;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 9460 | 20 | 0 | 0 | 0 | 0 | 60 | 460 | 1460 | 4460 | 9460 | 120 | 121
|WZAAAA | UAAAAA | AAAAxx
! 6969 | 19 | 1 | 1 | 9 | 9 | 69 | 969 | 969 | 1969 | 6969 | 138 | 139
|BIAAAA | TAAAAA | VVVVxx
! (2 rows)
FETCH backward 3 in foo21;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 6969 | 19 | 1 | 1 | 9 | 9 | 69 | 969 | 969 | 1969 | 6969 | 138 | 139
|BIAAAA | TAAAAA | VVVVxx
! 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43
|RUAAAA | SAAAAA | OOOOxx
! 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171
|NOAAAA | RAAAAA | HHHHxx
! (3 rows)
FETCH backward 4 in foo20;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43
|RUAAAA | SAAAAA | OOOOxx
! 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171
|NOAAAA | RAAAAA | HHHHxx
! 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175
|FZAAAA | QAAAAA | AAAAxx
! 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13
|OKAAAA | PAAAAA | VVVVxx
! (4 rows)
FETCH backward 5 in foo19;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171
|NOAAAA | RAAAAA | HHHHxx
! 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175
|FZAAAA | QAAAAA | AAAAxx
! 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13
|OKAAAA | PAAAAA | VVVVxx
! 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143
|LCAAAA | OAAAAA | OOOOxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! (5 rows)
FETCH backward 6 in foo18;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175
|FZAAAA | QAAAAA | AAAAxx
! 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13
|OKAAAA | PAAAAA | VVVVxx
! 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143
|LCAAAA | OAAAAA | OOOOxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! (6 rows)
FETCH backward 7 in foo17;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13
|OKAAAA | PAAAAA | VVVVxx
! 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143
|LCAAAA | OAAAAA | OOOOxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! (7 rows)
FETCH backward 8 in foo16;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143
|LCAAAA | OAAAAA | OOOOxx
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! (8 rows)
FETCH backward 9 in foo15;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87
|DGAAAA | NAAAAA | HHHHxx
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! (9 rows)
FETCH backward 10 in foo14;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45
|WSAAAA | MAAAAA | AAAAxx
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! (10 rows)
FETCH backward 11 in foo13;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9
|WFAAAA | LAAAAA | VVVVxx
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! (11 rows)
FETCH backward 12 in foo12;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29
|OYAAAA | KAAAAA | OOOOxx
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! (11 rows)
FETCH backward 13 in foo11;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87
|BNAAAA | JAAAAA | HHHHxx
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! (10 rows)
FETCH backward 14 in foo10;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43
|FKAAAA | IAAAAA | AAAAxx
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! (9 rows)
FETCH backward 15 in foo9;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3
|TXAAAA | HAAAAA | VVVVxx
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! (8 rows)
FETCH backward 16 in foo8;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115
|NMAAAA | GAAAAA | OOOOxx
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! (7 rows)
FETCH backward 17 in foo7;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19
|BWAAAA | FAAAAA | HHHHxx
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! (6 rows)
FETCH backward 18 in foo6;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129
|OPAAAA | EAAAAA | AAAAxx
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! (5 rows)
FETCH backward 19 in foo5;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101
|WOAAAA | DAAAAA | VVVVxx
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! (4 rows)
FETCH backward 20 in foo4;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41
|OBAAAA | CAAAAA | OOOOxx
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! (3 rows)
FETCH backward 21 in foo3;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183
|TUAAAA | BAAAAA | HHHHxx
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! (2 rows)
FETCH backward 22 in foo2;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1
|MAAAAA | AAAAAA | AAAAxx
! (1 row)
FETCH backward 23 in foo1;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
--- 28,254 ----
FETCH 1 in foo1;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 2 in foo2;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 3 in foo3;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 4 in foo4;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 5 in foo5;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 6 in foo6;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 7 in foo7;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 8 in foo8;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 9 in foo9;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 10 in foo10;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 11 in foo11;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 12 in foo12;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 13 in foo13;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 14 in foo14;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 15 in foo15;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 16 in foo16;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 17 in foo17;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 18 in foo18;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 19 in foo19;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 20 in foo20;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 21 in foo21;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 22 in foo22;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH 23 in foo23;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 1 in foo23;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 2 in foo22;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 3 in foo21;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 4 in foo20;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 5 in foo19;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 6 in foo18;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 7 in foo17;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 8 in foo16;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 9 in foo15;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 10 in foo14;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 11 in foo13;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 12 in foo12;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 13 in foo11;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 14 in foo10;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 15 in foo9;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 16 in foo8;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 17 in foo7;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 18 in foo6;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 19 in foo5;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 20 in foo4;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 21 in foo3;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 22 in foo2;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! (0 rows)
FETCH backward 23 in foo1;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
----------------------
*** expected/btree_index.out Sat Jan 8 22:48:37 2000
--- results/btree_index.out Fri Feb 23 08:15:29 2001
***************
*** 6,100 ****
FROM bt_i4_heap b
WHERE b.seqno < 1;
seqno | random
! -------+------------
! 0 | 1935401906
! (1 row)
SELECT b.*
FROM bt_i4_heap b
WHERE b.seqno >= 9999;
seqno | random
! -------+------------
! 9999 | 1227676208
! (1 row)
SELECT b.*
FROM bt_i4_heap b
WHERE b.seqno = 4500;
seqno | random
! -------+------------
! 4500 | 2080851358
! (1 row)
SELECT b.*
FROM bt_name_heap b
WHERE b.seqno < '1'::name;
seqno | random
! -------+------------
! 0 | 1935401906
! (1 row)
SELECT b.*
FROM bt_name_heap b
WHERE b.seqno >= '9999'::name;
seqno | random
! -------+------------
! 9999 | 1227676208
! (1 row)
SELECT b.*
FROM bt_name_heap b
WHERE b.seqno = '4500'::name;
seqno | random
! -------+------------
! 4500 | 2080851358
! (1 row)
SELECT b.*
FROM bt_txt_heap b
WHERE b.seqno < '1'::text;
seqno | random
! -------+------------
! 0 | 1935401906
! (1 row)
SELECT b.*
FROM bt_txt_heap b
WHERE b.seqno >= '9999'::text;
seqno | random
! -------+------------
! 9999 | 1227676208
! (1 row)
SELECT b.*
FROM bt_txt_heap b
WHERE b.seqno = '4500'::text;
seqno | random
! -------+------------
! 4500 | 2080851358
! (1 row)
SELECT b.*
FROM bt_f8_heap b
WHERE b.seqno < '1'::float8;
seqno | random
! -------+------------
! 0 | 1935401906
! (1 row)
SELECT b.*
FROM bt_f8_heap b
WHERE b.seqno >= '9999'::float8;
seqno | random
! -------+------------
! 9999 | 1227676208
! (1 row)
SELECT b.*
FROM bt_f8_heap b
WHERE b.seqno = '4500'::float8;
seqno | random
! -------+------------
! 4500 | 2080851358
! (1 row)
--- 6,88 ----
FROM bt_i4_heap b
WHERE b.seqno < 1;
seqno | random
! -------+--------
! (0 rows)
SELECT b.*
FROM bt_i4_heap b
WHERE b.seqno >= 9999;
seqno | random
! -------+--------
! (0 rows)
SELECT b.*
FROM bt_i4_heap b
WHERE b.seqno = 4500;
seqno | random
! -------+--------
! (0 rows)
SELECT b.*
FROM bt_name_heap b
WHERE b.seqno < '1'::name;
seqno | random
! -------+--------
! (0 rows)
SELECT b.*
FROM bt_name_heap b
WHERE b.seqno >= '9999'::name;
seqno | random
! -------+--------
! (0 rows)
SELECT b.*
FROM bt_name_heap b
WHERE b.seqno = '4500'::name;
seqno | random
! -------+--------
! (0 rows)
SELECT b.*
FROM bt_txt_heap b
WHERE b.seqno < '1'::text;
seqno | random
! -------+--------
! (0 rows)
SELECT b.*
FROM bt_txt_heap b
WHERE b.seqno >= '9999'::text;
seqno | random
! -------+--------
! (0 rows)
SELECT b.*
FROM bt_txt_heap b
WHERE b.seqno = '4500'::text;
seqno | random
! -------+--------
! (0 rows)
SELECT b.*
FROM bt_f8_heap b
WHERE b.seqno < '1'::float8;
seqno | random
! -------+--------
! (0 rows)
SELECT b.*
FROM bt_f8_heap b
WHERE b.seqno >= '9999'::float8;
seqno | random
! -------+--------
! (0 rows)
SELECT b.*
FROM bt_f8_heap b
WHERE b.seqno = '4500'::float8;
seqno | random
! -------+--------
! (0 rows)
----------------------
*** expected/hash_index.out Sat Jan 8 22:48:37 2000
--- results/hash_index.out Fri Feb 23 08:15:30 2001
***************
*** 5,13 ****
SELECT hash_i4_heap.*
WHERE hash_i4_heap.random = 843938989;
seqno | random
! -------+-----------
! 15 | 843938989
! (1 row)
--
-- hash index
--- 5,12 ----
SELECT hash_i4_heap.*
WHERE hash_i4_heap.random = 843938989;
seqno | random
! -------+--------
! (0 rows)
--
-- hash index
***************
*** 26,34 ****
SELECT hash_name_heap.*
WHERE hash_name_heap.random = '1505703298'::name;
seqno | random
! -------+------------
! 9838 | 1505703298
! (1 row)
--
-- hash index
--- 25,32 ----
SELECT hash_name_heap.*
WHERE hash_name_heap.random = '1505703298'::name;
seqno | random
! -------+--------
! (0 rows)
--
-- hash index
***************
*** 47,55 ****
SELECT hash_txt_heap.*
WHERE hash_txt_heap.random = '1351610853'::text;
seqno | random
! -------+------------
! 5677 | 1351610853
! (1 row)
--
-- hash index
--- 45,52 ----
SELECT hash_txt_heap.*
WHERE hash_txt_heap.random = '1351610853'::text;
seqno | random
! -------+--------
! (0 rows)
--
-- hash index
***************
*** 68,76 ****
SELECT hash_f8_heap.*
WHERE hash_f8_heap.random = '444705537'::float8;
seqno | random
! -------+-----------
! 7853 | 444705537
! (1 row)
--
-- hash index
--- 65,72 ----
SELECT hash_f8_heap.*
WHERE hash_f8_heap.random = '444705537'::float8;
seqno | random
! -------+--------
! (0 rows)
--
-- hash index
***************
*** 105,112 ****
WHERE h.random = 1;
i1492 | i1
-------+----
! 1492 | 1
! (1 row)
UPDATE hash_i4_heap
SET seqno = 20000
--- 101,107 ----
WHERE h.random = 1;
i1492 | i1
-------+----
! (0 rows)
UPDATE hash_i4_heap
SET seqno = 20000
***************
*** 116,123 ****
WHERE h.random = 1492795354;
i20000
--------
! 20000
! (1 row)
UPDATE hash_name_heap
SET random = '0123456789abcdef'::name
--- 111,117 ----
WHERE h.random = 1492795354;
i20000
--------
! (0 rows)
UPDATE hash_name_heap
SET random = '0123456789abcdef'::name
***************
*** 126,134 ****
FROM hash_name_heap h
WHERE h.random = '0123456789abcdef'::name;
i6543 | c0_to_f
! -------+------------------
! 6543 | 0123456789abcdef
! (1 row)
UPDATE hash_name_heap
SET seqno = 20000
--- 120,127 ----
FROM hash_name_heap h
WHERE h.random = '0123456789abcdef'::name;
i6543 | c0_to_f
! -------+---------
! (0 rows)
UPDATE hash_name_heap
SET seqno = 20000
***************
*** 150,158 ****
FROM hash_txt_heap h
WHERE h.random = '0123456789abcdefghijklmnop'::text;
i4002 | c0_to_p
! -------+----------------------------
! 4002 | 0123456789abcdefghijklmnop
! (1 row)
UPDATE hash_txt_heap
SET seqno = 20000
--- 143,150 ----
FROM hash_txt_heap h
WHERE h.random = '0123456789abcdefghijklmnop'::text;
i4002 | c0_to_p
! -------+---------
! (0 rows)
UPDATE hash_txt_heap
SET seqno = 20000
***************
*** 162,169 ****
WHERE h.random = '959363399'::text;
t20000
--------
! 20000
! (1 row)
UPDATE hash_f8_heap
SET random = '-1234.1234'::float8
--- 154,160 ----
WHERE h.random = '959363399'::text;
t20000
--------
! (0 rows)
UPDATE hash_f8_heap
SET random = '-1234.1234'::float8
***************
*** 173,180 ****
WHERE h.random = '-1234.1234'::float8;
i8096 | f1234_1234
-------+------------
! 8906 | -1234.1234
! (1 row)
UPDATE hash_f8_heap
SET seqno = 20000
--- 164,170 ----
WHERE h.random = '-1234.1234'::float8;
i8096 | f1234_1234
-------+------------
! (0 rows)
UPDATE hash_f8_heap
SET seqno = 20000
***************
*** 184,191 ****
WHERE h.random = '488912369'::float8;
f20000
--------
! 20000
! (1 row)
-- UPDATE hash_ovfl_heap
-- SET x = 1000
--- 174,180 ----
WHERE h.random = '488912369'::float8;
f20000
--------
! (0 rows)
-- UPDATE hash_ovfl_heap
-- SET x = 1000
----------------------
*** expected/select_views.out Sat Jan 8 22:48:37 2000
--- results/select_views.out Fri Feb 23 08:15:52 2001
***************
*** 4,1196 ****
--
SELECT * FROM street;
name |
thepath
| cname
!
------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------
! Access Rd 25 | [(-121.9283,37.894),(-121.9283,37.9)]
| Oakland
! Agua Fria Creek | [(-121.9254,37.922),(-121.9281,37.889)]
| Oakland
! Andrea Cir | [(-121.733218,37.88641),(-121.733286,37.90617)]
| Oakland
! Apricot Lane | [(-121.9471,37.401),(-121.9456,37.392)]
| Oakland
! Arlington Dr | [(-121.8802,37.408),(-121.8807,37.394)]
| Oakland
! Arlington Road | [(-121.7957,37.898),(-121.7956,37.906)]
| Oakland
! Arroyo Las Positas | [(-121.7973,37.997),(-121.7957,37.005)]
| Oakland
! Arroyo Seco | [(-121.7073,37.766),(-121.6997,37.729)]
| Oakland
! Calaveras Creek | [(-121.8203,37.035),(-121.8207,37.931)]
| Oakland
! Corriea Way | [(-121.9501,37.402),(-121.9505,37.398)]
| Oakland
! Cowing Road | [(-122.0002,37.934),(-121.9772,37.782)]
| Oakland
! Driscoll Road | [(-121.9482,37.403),(-121.948451,37.39995)]
| Oakland
! Enos Way | [(-121.7677,37.896),(-121.7673,37.91)]
| Oakland
! Fairview Ave | [(-121.999,37.428),(-121.9863,37.351)]
| Oakland
! I- 580 | [(-121.9322,37.989),(-121.9243,37.006),(-121.9217,37.014)]
| Oakland
! I- 580 |
[(-122.018,37.019),(-122.0009,37.032),(-121.9787,37.983),(-121.958,37.984),(-121.9571,37.986)]
| Oakland
! I- 580 Ramp |
[(-121.8521,37.011),(-121.8479,37.999),(-121.8476,37.999),(-121.8456,37.01),(-121.8455,37.011)]
| Oakland
! I- 580 Ramp | [(-121.8743,37.014),(-121.8722,37.999),(-121.8714,37.999)]
| Oakland
! I- 580 Ramp |
[(-121.9043,37.998),(-121.9036,37.013),(-121.902632,37.0174),(-121.9025,37.018)]
| Oakland
! I- 580 Ramp |
[(-121.9368,37.986),(-121.936483,37.98832),(-121.9353,37.997),(-121.93504,37.00035),(-121.9346,37.006),(-121.933764,37.00031),(-121.9333,37.997),(-121.9322,37.989)]
| Oakland
! I- 580/I-680 Ramp | ((-121.9207,37.988),(-121.9192,37.016))
| Oakland
! I- 680 |
((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
| Oakland
! I- 680 |
[(-121.9101,37.715),(-121.911269,37.74682),(-121.9119,37.764),(-121.9124,37.776),(-121.9174,37.905),(-121.9194,37.957),(-121.9207,37.988)]
| Oakland
! I- 680 | [(-121.9184,37.934),(-121.917,37.913),(-121.9122,37.83),(-121.9052,37.702)]
| Oakland
! I- 680 Ramp |
[(-121.8833,37.376),(-121.8833,37.392),(-121.883,37.4),(-121.8835,37.402),(-121.8852,37.422)]
| Oakland
! I- 680 Ramp | [(-121.92,37.438),(-121.9218,37.424),(-121.9238,37.408),(-121.9252,37.392)]
| Oakland
! I- 680 Ramp | [(-121.9238,37.402),(-121.9234,37.395),(-121.923,37.399)]
| Oakland
! I- 880 |
((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))
| Oakland
! I- 880 |
[(-121.948,37.933),(-121.9471,37.925),(-121.9467,37.923),(-121.946,37.918),(-121.9452,37.912),(-121.937,37.852)]
| Oakland
! Johnson Dr | [(-121.9145,37.901),(-121.915,37.877)]
| Oakland
! Juniper St | [(-121.7823,37.897),(-121.7815,37.9)]
| Oakland
! Las Positas Road | [(-121.764488,37.99199),(-121.75569,37.02022)]
| Oakland
! Livermore Ave | [(-121.7687,37.448),(-121.769,37.375)]
| Oakland
! Livermore Ave | [(-121.772719,37.99085),(-121.7728,37.001)]
| Oakland
! Mission Blvd | [(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]
| Oakland
! Navajo Ct | [(-121.8779,37.901),(-121.8783,37.9)]
| Oakland
! Pimlico Dr | [(-121.8616,37.998),(-121.8618,37.008)]
| Oakland
! Rosedale Ct | [(-121.9232,37.9),(-121.924,37.897)]
| Oakland
! Saginaw Ct | [(-121.8803,37.898),(-121.8806,37.901)]
| Oakland
! Sp Railroad | [(-121.893564,37.99009),(-121.897,37.016)]
| Oakland
! Sp Railroad | [(-121.9565,37.898),(-121.9562,37.9)]
| Oakland
! State Hwy 84 |
[(-121.9565,37.898),(-121.956589,37.89911),(-121.9569,37.903),(-121.956,37.91),(-121.9553,37.919)]
| Oakland
! Sunol Ridge Trl | [(-121.9419,37.455),(-121.9345,37.38)]
| Oakland
! Tassajara Creek | [(-121.87866,37.98898),(-121.8782,37.015)]
| Oakland
! Theresa Way | [(-121.7289,37.906),(-121.728,37.899)]
| Oakland
! Tissiack Way | [(-121.920364,37),(-121.9208,37.995)]
| Oakland
! Vallecitos Road | [(-121.8699,37.916),(-121.8703,37.891)]
| Oakland
! Warm Springs Blvd | [(-121.933956,37),(-121.9343,37.97)]
| Oakland
! Welch Creek Road | [(-121.7695,37.386),(-121.7737,37.413)]
| Oakland
! Whitlock Creek | [(-121.74683,37.91276),(-121.733107,37)]
| Oakland
! 1st St | [(-121.75508,37.89294),(-121.753581,37.90031)]
| Oakland
! Arden Road | [(-122.0978,37.177),(-122.1,37.177)]
| Oakland
! Ash St | [(-122.0408,37.31),(-122.04,37.292)]
| Oakland
! Bridgepointe Dr | [(-122.0514,37.305),(-122.0509,37.299)]
| Oakland
! Butterfield Dr | [(-122.0838,37.002),(-122.0834,37.987)]
| Oakland
! Celia St | [(-122.0611,37.3),(-122.0616,37.299)]
| Oakland
! Claremont Pl | [(-122.0542,37.995),(-122.0542,37.008)]
| Oakland
! Crystaline Dr | [(-121.925856,37),(-121.925869,37.00527)]
| Oakland
! Decoto Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]
| Oakland
! Eden Creek | [(-122.022037,37.00675),(-122.0221,37.998)]
| Oakland
! Hesperian Blvd | [(-122.097,37.333),(-122.0956,37.31),(-122.0946,37.293)]
| Oakland
! I- 580 |
[(-121.727,37.074),(-121.7229,37.093),(-121.722301,37.09522),(-121.721001,37.10005),(-121.7194,37.106),(-121.7188,37.109),(-121.7168,37.12),(-121.7163,37.123),(-121.7145,37.127),(-121.7096,37.148),(-121.707731,37.1568),(-121.7058,37.166),(-121.7055,37.168),(-121.7044,37.174),(-121.7038,37.172),(-121.7037,37.172),(-121.7027,37.175),(-121.7001,37.181),(-121.6957,37.191),(-121.6948,37.192),(-121.6897,37.204),(-121.6697,37.185)]
|Oakland
! I- 680 |
((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
| Oakland
! I- 880 |
((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))
| Oakland
! I- 880 |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]
| Oakland
! I- 880 |
[(-122.0831,37.312),(-122.0819,37.296),(-122.081,37.285),(-122.0786,37.248),(-122.078,37.24),(-122.077642,37.23496),(-122.076983,37.22567),(-122.076599,37.22026),(-122.076229,37.21505),(-122.0758,37.209)]
| Oakland
! I- 880 Ramp | [(-122.0019,37.301),(-122.002,37.293)]
| Oakland
! I- 880 Ramp |
[(-122.0041,37.313),(-122.0018,37.315),(-122.0007,37.315),(-122.0005,37.313),(-122.0002,37.308),(-121.9995,37.289)]
| Oakland
! I- 880 Ramp |
[(-122.0041,37.313),(-122.0038,37.308),(-122.0039,37.284),(-122.0013,37.287),(-121.9995,37.289)]
| Oakland
! I- 880 Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]
| Oakland
! I- 880 Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]
| Oakland
! I- 880 Ramp | [(-122.085,37.34),(-122.0801,37.316),(-122.081,37.285)]
| Oakland
! I- 880 Ramp | [(-122.085,37.34),(-122.0866,37.316),(-122.0819,37.296)]
| Oakland
! Kildare Road | [(-122.0968,37.016),(-122.0959,37)]
| Oakland
! Mildred Ct | [(-122.0002,37.388),(-121.9998,37.386)]
| Oakland
! Miramar Ave | [(-122.1009,37.025),(-122.099089,37.03209)]
| Oakland
! Mission Blvd | [(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]
| Oakland
! Moores Ave | [(-122.0087,37.301),(-122.0094,37.292)]
| Oakland
! Oakridge Road | [(-121.8316,37.049),(-121.828382,37)]
| Oakland
! Paseo Padre Pkwy | [(-121.9143,37.005),(-121.913522,37)]
| Oakland
! Periwinkle Road | [(-122.0451,37.301),(-122.044758,37.29844)]
| Oakland
! Railroad Ave | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]
| Oakland
! Ranspot Dr | [(-122.0972,37.999),(-122.0959,37)]
| Oakland
! Santa Maria Ave | [(-122.0773,37),(-122.0773,37.98)]
| Oakland
! Sp Railroad | [(-122.0734,37.001),(-122.0734,37.997)]
| Oakland
! Stanton Ave | [(-122.100392,37.0697),(-122.099513,37.06052)]
| Oakland
! Thackeray Ave | [(-122.072,37.305),(-122.0715,37.298)]
| Oakland
! Tissiack Way | [(-121.920364,37),(-121.9208,37.995)]
| Oakland
! Warm Springs Blvd | [(-121.933956,37),(-121.9343,37.97)]
| Oakland
! Western Pacific Railroad Spur | [(-122.0394,37.018),(-122.0394,37.961)]
| Oakland
! Whitlock Creek | [(-121.74683,37.91276),(-121.733107,37)]
| Oakland
! Avenue 134th | [(-122.1823,37.002),(-122.1851,37.992)]
| Oakland
! Avenue 140th | [(-122.1656,37.003),(-122.1691,37.988)]
| Oakland
! B St | [(-122.1749,37.451),(-122.1743,37.443)]
| Oakland
! Bancroft Ave | [(-122.15714,37.4242),(-122.156,37.409)]
| Oakland
! Bancroft Ave | [(-122.1643,37.523),(-122.1631,37.508),(-122.1621,37.493)]
| Oakland
! Birch St | [(-122.1617,37.425),(-122.1614,37.417)]
| Oakland
! Birch St | [(-122.1673,37.509),(-122.1661,37.492)]
| Oakland
! Broadmore Ave | [(-122.095,37.522),(-122.0936,37.497)]
| Oakland
! Butterfield Dr | [(-122.0838,37.002),(-122.0834,37.987)]
| Oakland
! C St | [(-122.1768,37.46),(-122.1749,37.435)]
| Oakland
! Cameron Ave | [(-122.1316,37.502),(-122.1327,37.481)]
| Oakland
! Chapman Dr | [(-122.0421,37.504),(-122.0414,37.498)]
| Oakland
! Charles St | [(-122.0255,37.505),(-122.0252,37.499)]
| Oakland
! Claremont Pl | [(-122.0542,37.995),(-122.0542,37.008)]
| Oakland
! Coliseum Way | [(-122.2001,37.47),(-122.1978,37.516)]
| Oakland
! D St | [(-122.1811,37.505),(-122.1805,37.497)]
| Oakland
! Decoto Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]
| Oakland
! E St | [(-122.1832,37.505),(-122.1826,37.498),(-122.182,37.49)]
| Oakland
! Eden Ave | [(-122.1143,37.505),(-122.1142,37.491)]
| Oakland
! Eden Creek | [(-122.022037,37.00675),(-122.0221,37.998)]
| Oakland
! Hegenberger Exwy | [(-122.1946,37.52),(-122.1947,37.497)]
| Oakland
! Herrier St | [(-122.1943,37.006),(-122.1936,37.998)]
| Oakland
! I- 580 |
[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)]
| Oakland
! I- 580 |
[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)]
| Oakland
! I- 580 Ramp | [(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)]
| Oakland
! I- 580 Ramp | [(-122.1414,37.383),(-122.1407,37.376),(-122.1403,37.372),(-122.139,37.356)]
| Oakland
! I- 880 |
[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)]
| Oakland
! I- 880 |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]
| Oakland
! I- 880 |
[(-122.0978,37.528),(-122.096,37.496),(-122.0931,37.453),(-122.09277,37.4496),(-122.090189,37.41442),(-122.0896,37.405),(-122.085,37.34)]
| Oakland
! I- 880 |
[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)]
| Oakland
! I- 880 Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]
| Oakland
! I- 880 Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]
| Oakland
! Kaiser Dr | [(-122.067163,37.47821),(-122.060402,37.51961)]
| Oakland
! La Playa Dr | [(-122.1039,37.545),(-122.101,37.493)]
| Oakland
! Locust St | [(-122.1606,37.007),(-122.1593,37.987)]
| Oakland
! Magnolia St | [(-122.0971,37.5),(-122.0962,37.484)]
| Oakland
! Mattos Dr | [(-122.0005,37.502),(-122.000898,37.49683)]
| Oakland
! Maubert Ave | [(-122.1114,37.009),(-122.1096,37.995)]
| Oakland
! McClure Ave | [(-122.1431,37.001),(-122.1436,37.998)]
| Oakland
! National Ave | [(-122.1192,37.5),(-122.1281,37.489)]
| Oakland
! Portsmouth Ave | [(-122.1064,37.315),(-122.1064,37.308)]
| Oakland
! Railroad Ave | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]
| Oakland
! Ranspot Dr | [(-122.0972,37.999),(-122.0959,37)]
| Oakland
! Redwood Road | [(-122.1493,37.98),(-122.1437,37.001)]
| Oakland
! Santa Maria Ave | [(-122.0773,37),(-122.0773,37.98)]
| Oakland
! Skyline Blvd | [(-122.1738,37.01),(-122.1714,37.996)]
| Oakland
! Skyline Dr | [(-122.0277,37.5),(-122.0284,37.498)]
| Oakland
! Sp Railroad | [(-122.0734,37.001),(-122.0734,37.997)]
| Oakland
! Sp Railroad | [(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)]
| Oakland
! Sp Railroad | [(-122.1947,37.497),(-122.193328,37.4848)]
| Oakland
! State Hwy 92 |
[(-122.1085,37.326),(-122.1095,37.322),(-122.1111,37.316),(-122.1119,37.313),(-122.1125,37.311),(-122.1131,37.308),(-122.1167,37.292),(-122.1187,37.285),(-122.12,37.28)]
| Oakland
! State Hwy 92 Ramp | [(-122.1086,37.321),(-122.1089,37.315),(-122.1111,37.316)]
| Oakland
! Western Pacific Railroad Spur | [(-122.0394,37.018),(-122.0394,37.961)]
| Oakland
! Willimet Way | [(-122.0964,37.517),(-122.0949,37.493)]
| Oakland
! Wisconsin St | [(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)]
| Oakland
! 100th Ave | [(-122.1657,37.429),(-122.1647,37.432)]
| Oakland
! 107th Ave | [(-122.1555,37.403),(-122.1531,37.41)]
| Oakland
! 85th Ave | [(-122.1877,37.466),(-122.186,37.476)]
| Oakland
! 89th Ave | [(-122.1822,37.459),(-122.1803,37.471)]
| Oakland
! 98th Ave | [(-122.1568,37.498),(-122.1558,37.502)]
| Oakland
! 98th Ave | [(-122.1693,37.438),(-122.1682,37.444)]
| Oakland
! Allen Ct | [(-122.0131,37.602),(-122.0117,37.597)]
| Berkeley
! Alvarado Niles Road | [(-122.0325,37.903),(-122.0316,37.9)]
| Berkeley
! Arizona St | [(-122.0381,37.901),(-122.0367,37.898)]
| Berkeley
! Avenue 134th | [(-122.1823,37.002),(-122.1851,37.992)]
| Berkeley
! Avenue 140th | [(-122.1656,37.003),(-122.1691,37.988)]
| Berkeley
! Broadway | [(-122.2409,37.586),(-122.2395,37.601)]
| Berkeley
! Buckingham Blvd | [(-122.2231,37.59),(-122.2214,37.606)]
| Berkeley
! Butterfield Dr | [(-122.0838,37.002),(-122.0834,37.987)]
| Berkeley
! California St | [(-122.2032,37.005),(-122.2016,37.996)]
| Berkeley
! Campus Dr | [(-122.1704,37.905),(-122.1678,37.868),(-122.1671,37.865)]
| Berkeley
! Carson St | [(-122.1846,37.9),(-122.1843,37.901)]
| Berkeley
! Central Ave | [(-122.2343,37.602),(-122.2331,37.595)]
| Berkeley
! Champion St | [(-122.214,37.991),(-122.2147,37.002)]
| Berkeley
! Claremont Pl | [(-122.0542,37.995),(-122.0542,37.008)]
| Berkeley
! Coliseum Way | [(-122.2113,37.626),(-122.2085,37.592),(-122.2063,37.568)]
| Berkeley
! Cornell Ave | [(-122.2956,37.925),(-122.2949,37.906),(-122.2939,37.875)]
| Berkeley
! Creston Road | [(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)]
| Berkeley
! Crow Canyon Creek | [(-122.043,37.905),(-122.0368,37.71)]
| Berkeley
! Cull Creek | [(-122.0624,37.875),(-122.0582,37.527)]
| Berkeley
! Decoto Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]
| Berkeley
! Deering St | [(-122.2146,37.904),(-122.2126,37.897)]
| Berkeley
! Dimond Ave | [(-122.2167,37.994),(-122.2162,37.006)]
| Berkeley
! Donna Way | [(-122.1333,37.606),(-122.1316,37.599)]
| Berkeley
! Eden Creek | [(-122.022037,37.00675),(-122.0221,37.998)]
| Berkeley
! Euclid Ave | [(-122.2671,37.009),(-122.2666,37.987)]
| Berkeley
! Foothill Blvd | [(-122.2414,37.9),(-122.2403,37.893)]
| Berkeley
! Fountain St | [(-122.2306,37.593),(-122.2293,37.605)]
| Berkeley
! Grizzly Peak Blvd | [(-122.2213,37.638),(-122.2127,37.581)]
| Berkeley
! Grove Way |
[(-122.0643,37.884),(-122.062679,37.89162),(-122.061796,37.89578),(-122.0609,37.9)]
| Berkeley
! Herrier St | [(-122.1943,37.006),(-122.1936,37.998)]
| Berkeley
! Hesperian Blvd | [(-122.1132,37.6),(-122.1123,37.586)]
| Berkeley
! I- 580 |
[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)]
| Berkeley
! I- 580 |
[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)]
| Berkeley
! I- 580 |
[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)]
| Berkeley
! I- 580 Ramp | [(-122.093241,37.90351),(-122.09364,37.89634),(-122.093788,37.89212)]
| Berkeley
! I- 580 Ramp | [(-122.0934,37.896),(-122.09257,37.89961),(-122.0911,37.906)]
| Berkeley
! I- 580 Ramp | [(-122.0941,37.897),(-122.0943,37.902)]
| Berkeley
! I- 580 Ramp | [(-122.096,37.888),(-122.0962,37.891),(-122.0964,37.9)]
| Berkeley
! I- 580 Ramp | [(-122.101,37.898),(-122.1005,37.902),(-122.0989,37.911)]
| Berkeley
! I- 580 Ramp | [(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)]
| Berkeley
! I- 880 |
[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)]
| Berkeley
! I- 880 |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]
| Berkeley
! I- 880 |
[(-122.1365,37.902),(-122.1358,37.898),(-122.1333,37.881),(-122.1323,37.874),(-122.1311,37.866),(-122.1308,37.865),(-122.1307,37.864),(-122.1289,37.851),(-122.1277,37.843),(-122.1264,37.834),(-122.1231,37.812),(-122.1165,37.766),(-122.1104,37.72),(-122.109695,37.71094),(-122.109,37.702),(-122.108312,37.69168),(-122.1076,37.681)]
| Berkeley
! I- 880 |
[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)]
| Berkeley
! I- 880 |
[(-122.2214,37.711),(-122.2202,37.699),(-122.2199,37.695),(-122.219,37.682),(-122.2184,37.672),(-122.2173,37.652),(-122.2159,37.638),(-122.2144,37.616),(-122.2138,37.612),(-122.2135,37.609),(-122.212,37.592),(-122.2116,37.586),(-122.2111,37.581)]
| Berkeley
! I- 880 |
[(-122.2707,37.975),(-122.2693,37.972),(-122.2681,37.966),(-122.267,37.962),(-122.2659,37.957),(-122.2648,37.952),(-122.2636,37.946),(-122.2625,37.935),(-122.2617,37.927),(-122.2607,37.921),(-122.2593,37.916),(-122.258,37.911),(-122.2536,37.898),(-122.2432,37.858),(-122.2408,37.845),(-122.2386,37.827),(-122.2374,37.811)]
| Berkeley
! I- 880 Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]
| Berkeley
! I- 880 Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]
| Berkeley
! I- 880 Ramp | [(-122.1029,37.61),(-122.1013,37.587),(-122.0999,37.569)]
| Berkeley
! I- 880 Ramp | [(-122.1379,37.891),(-122.1383,37.897),(-122.1377,37.902)]
| Berkeley
! I- 880 Ramp |
[(-122.1379,37.931),(-122.137597,37.92736),(-122.1374,37.925),(-122.1373,37.924),(-122.1369,37.914),(-122.1358,37.905),(-122.1365,37.908),(-122.1358,37.898)]
| Berkeley
! I- 880 Ramp | [(-122.2536,37.898),(-122.254,37.902)]
| Berkeley
! Jackson St | [(-122.0845,37.6),(-122.0842,37.606)]
| Berkeley
! Joyce St | [(-122.0792,37.604),(-122.0774,37.581)]
| Berkeley
! Keeler Ave | [(-122.2578,37.906),(-122.2579,37.899)]
| Berkeley
! Laguna Ave | [(-122.2099,37.989),(-122.2089,37)]
| Berkeley
! Lakehurst Cir | [(-122.284729,37.89025),(-122.286096,37.90364)]
| Berkeley
! Lakeshore Ave | [(-122.2586,37.99),(-122.2556,37.006)]
| Berkeley
! Linden St | [(-122.2867,37.998),(-122.2864,37.008)]
| Berkeley
! Locust St | [(-122.1606,37.007),(-122.1593,37.987)]
| Berkeley
! Marin Ave | [(-122.2741,37.894),(-122.272,37.901)]
| Berkeley
! Martin Luther King Jr Way | [(-122.2712,37.608),(-122.2711,37.599)]
| Berkeley
! Maubert Ave | [(-122.1114,37.009),(-122.1096,37.995)]
| Berkeley
! McClure Ave | [(-122.1431,37.001),(-122.1436,37.998)]
| Berkeley
! Miller Road | [(-122.0902,37.645),(-122.0865,37.545)]
| Berkeley
! Mission Blvd | [(-122.0006,37.896),(-121.9989,37.88)]
| Berkeley
! Oakland Inner Harbor | [(-122.2625,37.913),(-122.260016,37.89484)]
| Berkeley
! Oneil Ave | [(-122.076754,37.62476),(-122.0745,37.595)]
| Berkeley
! Parkridge Dr | [(-122.1438,37.884),(-122.1428,37.9)]
| Berkeley
! Parkside Dr | [(-122.0475,37.603),(-122.0443,37.596)]
| Berkeley
! Paseo Padre Pkwy | [(-122.0021,37.639),(-121.996,37.628)]
| Berkeley
! Pearl St | [(-122.2383,37.594),(-122.2366,37.615)]
| Berkeley
! Railroad Ave | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]
| Berkeley
! Ranspot Dr | [(-122.0972,37.999),(-122.0959,37)]
| Berkeley
! Redding St | [(-122.1978,37.901),(-122.1975,37.895)]
| Berkeley
! Redwood Road | [(-122.1493,37.98),(-122.1437,37.001)]
| Berkeley
! Roca Dr | [(-122.0335,37.609),(-122.0314,37.599)]
| Berkeley
! Sacramento St | [(-122.2799,37.606),(-122.2797,37.597)]
| Berkeley
! Saddle Brook Dr | [(-122.1478,37.909),(-122.1454,37.904),(-122.1451,37.888)]
| Berkeley
! San Andreas Dr | [(-122.0609,37.9),(-122.0614,37.895)]
| Berkeley
! Santa Maria Ave | [(-122.0773,37),(-122.0773,37.98)]
| Berkeley
! Shattuck Ave | [(-122.2686,37.904),(-122.2686,37.897)]
| Berkeley
! Shoreline Dr | [(-122.2657,37.603),(-122.2648,37.6)]
| Berkeley
! Skyline Blvd | [(-122.1738,37.01),(-122.1714,37.996)]
| Berkeley
! Skywest Dr | [(-122.1161,37.62),(-122.1123,37.586)]
| Berkeley
! Sp Railroad | [(-122.0734,37.001),(-122.0734,37.997)]
| Berkeley
! Sp Railroad | [(-122.0914,37.601),(-122.087,37.56),(-122.086408,37.5551)]
| Berkeley
! Sp Railroad | [(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)]
| Berkeley
! State Hwy 123 |
[(-122.3004,37.986),(-122.2998,37.969),(-122.2995,37.962),(-122.2992,37.952),(-122.299,37.942),(-122.2987,37.935),(-122.2984,37.924),(-122.2982,37.92),(-122.2976,37.904),(-122.297,37.88),(-122.2966,37.869),(-122.2959,37.848),(-122.2961,37.843)]
| Berkeley
! State Hwy 13 |
[(-122.1797,37.943),(-122.179871,37.91849),(-122.18,37.9),(-122.179023,37.86615),(-122.1787,37.862),(-122.1781,37.851),(-122.1777,37.845),(-122.1773,37.839),(-122.177,37.833)]
| Berkeley
! State Hwy 238 |
((-122.098,37.908),(-122.0983,37.907),(-122.099,37.905),(-122.101,37.898),(-122.101535,37.89711),(-122.103173,37.89438),(-122.1046,37.892),(-122.106,37.89))
| Berkeley
! State Hwy 238 Ramp | [(-122.1288,37.9),(-122.1293,37.895),(-122.1296,37.906)]
| Berkeley
! Stuart St | [(-122.2518,37.6),(-122.2507,37.601),(-122.2491,37.606)]
| Berkeley
! Tupelo Ter | [(-122.059087,37.6113),(-122.057021,37.59942)]
| Berkeley
! West Loop Road | [(-122.0576,37.604),(-122.0602,37.586)]
| Berkeley
! Western Pacific Railroad Spur | [(-122.0394,37.018),(-122.0394,37.961)]
| Berkeley
! Wisconsin St | [(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)]
| Berkeley
! Wp Railroad | [(-122.254,37.902),(-122.2506,37.891)]
| Berkeley
! 19th Ave | [(-122.2366,37.897),(-122.2359,37.905)]
| Berkeley
! 5th St | [(-122.296,37.615),(-122.2953,37.598)]
| Berkeley
! 82nd Ave | [(-122.1695,37.596),(-122.1681,37.603)]
| Berkeley
! Ada St | [(-122.2487,37.398),(-122.2496,37.401)]
| Lafayette
! California St | [(-122.2032,37.005),(-122.2016,37.996)]
| Lafayette
! Capricorn Ave | [(-122.2176,37.404),(-122.2164,37.384)]
| Lafayette
! Chambers Dr | [(-122.2004,37.352),(-122.1972,37.368)]
| Lafayette
! Chambers Lane | [(-122.2001,37.359),(-122.1975,37.371)]
| Lafayette
! Champion St | [(-122.214,37.991),(-122.2147,37.002)]
| Lafayette
! Coolidge Ave | [(-122.2007,37.058),(-122.1992,37.06)]
| Lafayette
! Creston Road | [(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)]
| Lafayette
! Dimond Ave | [(-122.2167,37.994),(-122.2162,37.006)]
| Lafayette
! Edgewater Dr | [(-122.201,37.379),(-122.2042,37.41)]
| Lafayette
! Euclid Ave | [(-122.2671,37.009),(-122.2666,37.987)]
| Lafayette
! Heartwood Dr | [(-122.2006,37.341),(-122.1992,37.338)]
| Lafayette
! Hollis St | [(-122.2885,37.397),(-122.289,37.414)]
| Lafayette
! I- 580 |
[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)]
| Lafayette
! I- 80 Ramp | [(-122.2962,37.413),(-122.2959,37.382),(-122.2951,37.372)]
| Lafayette
! I- 880 Ramp | [(-122.2771,37.002),(-122.278,37)]
| Lafayette
! Indian Way | [(-122.2066,37.398),(-122.2045,37.411)]
| Lafayette
! Laguna Ave | [(-122.2099,37.989),(-122.2089,37)]
| Lafayette
! Lakeshore Ave | [(-122.2586,37.99),(-122.2556,37.006)]
| Lafayette
! Linden St | [(-122.2867,37.998),(-122.2864,37.008)]
| Lafayette
! Mandalay Road | [(-122.2322,37.397),(-122.2321,37.403)]
| Lafayette
! Proctor Ave | [(-122.2267,37.406),(-122.2251,37.386)]
| Lafayette
! Sheridan Road | [(-122.2279,37.425),(-122.2253,37.411),(-122.2223,37.377)]
| Lafayette
! State Hwy 13 |
[(-122.2049,37.2),(-122.20328,37.17975),(-122.1989,37.125),(-122.198078,37.11641),(-122.1975,37.11)]
| Lafayette
! State Hwy 13 Ramp | [(-122.2244,37.427),(-122.223,37.414),(-122.2214,37.396),(-122.2213,37.388)]
| Lafayette
! State Hwy 24 |
[(-122.2674,37.246),(-122.2673,37.248),(-122.267,37.261),(-122.2668,37.271),(-122.2663,37.298),(-122.2659,37.315),(-122.2655,37.336),(-122.265007,37.35882),(-122.264443,37.37286),(-122.2641,37.381),(-122.2638,37.388),(-122.2631,37.396),(-122.2617,37.405),(-122.2615,37.407),(-122.2605,37.412)]
| Lafayette
! Taurus Ave | [(-122.2159,37.416),(-122.2128,37.389)]
| Lafayette
! 5th St | [(-122.278,37),(-122.2792,37.005),(-122.2803,37.009)]
| Lafayette
! 98th Ave | [(-122.2001,37.258),(-122.1974,37.27)]
| Lafayette
! (282 rows)
SELECT name, #thepath FROM iexit ORDER BY 1, 2;
! name | ?column?
! ------------------------------------+----------
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 2
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 3
! I- 580 | 4
! I- 580 | 4
! I- 580 | 4
! I- 580 | 4
! I- 580 | 5
! I- 580 | 5
! I- 580 | 5
! I- 580 | 5
! I- 580 | 5
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 6
! I- 580 | 7
! I- 580 | 7
! I- 580 | 7
! I- 580 | 7
! I- 580 | 7
! I- 580 | 7
! I- 580 | 7
! I- 580 | 8
! I- 580 | 8
! I- 580 | 8
! I- 580 | 8
! I- 580 | 8
! I- 580 | 8
! I- 580 | 8
! I- 580 | 8
! I- 580 | 9
! I- 580 | 9
! I- 580 | 9
! I- 580 | 9
! I- 580 | 9
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 12
! I- 580 | 13
! I- 580 | 13
! I- 580 | 13
! I- 580 | 13
! I- 580 | 13
! I- 580 | 13
! I- 580 | 14
! I- 580 | 14
! I- 580 | 14
! I- 580 | 14
! I- 580 | 14
! I- 580 | 14
! I- 580 | 14
! I- 580 | 14
! I- 580 | 18
! I- 580 | 18
! I- 580 | 18
! I- 580 | 18
! I- 580 | 18
! I- 580 | 18
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 21
! I- 580 | 22
! I- 580 | 22
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 2
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 3
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 4
! I- 580 Ramp | 5
! I- 580 Ramp | 5
! I- 580 Ramp | 5
! I- 580 Ramp | 5
! I- 580 Ramp | 5
! I- 580 Ramp | 5
! I- 580 Ramp | 5
! I- 580 Ramp | 5
! I- 580 Ramp | 5
! I- 580 Ramp | 5
! I- 580 Ramp | 5
! I- 580 Ramp | 5
! I- 580 Ramp | 5
! I- 580 Ramp | 5
! I- 580 Ramp | 6
! I- 580 Ramp | 6
! I- 580 Ramp | 6
! I- 580 Ramp | 7
! I- 580 Ramp | 8
! I- 580 Ramp | 8
! I- 580 Ramp | 8
! I- 580 Ramp | 8
! I- 580 Ramp | 8
! I- 580 Ramp | 8
! I- 580/I-680 Ramp | 2
! I- 580/I-680 Ramp | 2
! I- 580/I-680 Ramp | 2
! I- 580/I-680 Ramp | 2
! I- 580/I-680 Ramp | 2
! I- 580/I-680 Ramp | 2
! I- 580/I-680 Ramp | 4
! I- 580/I-680 Ramp | 4
! I- 580/I-680 Ramp | 4
! I- 580/I-680 Ramp | 4
! I- 580/I-680 Ramp | 5
! I- 580/I-680 Ramp | 6
! I- 580/I-680 Ramp | 6
! I- 580/I-680 Ramp | 6
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 2
! I- 680 | 3
! I- 680 | 3
! I- 680 | 3
! I- 680 | 4
! I- 680 | 4
! I- 680 | 4
! I- 680 | 5
! I- 680 | 5
! I- 680 | 5
! I- 680 | 7
! I- 680 | 7
! I- 680 | 7
! I- 680 | 7
! I- 680 | 8
! I- 680 | 8
! I- 680 | 8
! I- 680 | 8
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 10
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 | 16
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 2
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 3
! I- 680 Ramp | 4
! I- 680 Ramp | 4
! I- 680 Ramp | 4
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 5
! I- 680 Ramp | 6
! I- 680 Ramp | 6
! I- 680 Ramp | 6
! I- 680 Ramp | 6
! I- 680 Ramp | 7
! I- 680 Ramp | 7
! I- 680 Ramp | 7
! I- 680 Ramp | 7
! I- 680 Ramp | 8
! I- 680 Ramp | 8
! I- 680 Ramp | 8
! I- 680 Ramp | 8
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 2
! I- 80 | 3
! I- 80 | 3
! I- 80 | 3
! I- 80 | 4
! I- 80 | 4
! I- 80 | 4
! I- 80 | 4
! I- 80 | 4
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 5
! I- 80 | 11
! I- 80 | 11
! I- 80 | 11
! I- 80 | 11
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 2
! I- 80 Ramp | 3
! I- 80 Ramp | 3
! I- 80 Ramp | 3
! I- 80 Ramp | 3
! I- 80 Ramp | 3
! I- 80 Ramp | 3
! I- 80 Ramp | 3
! I- 80 Ramp | 3
! I- 80 Ramp | 3
! I- 80 Ramp | 4
! I- 80 Ramp | 4
! I- 80 Ramp | 4
! I- 80 Ramp | 4
! I- 80 Ramp | 5
! I- 80 Ramp | 5
! I- 80 Ramp | 5
! I- 80 Ramp | 5
! I- 80 Ramp | 5
! I- 80 Ramp | 5
! I- 80 Ramp | 5
! I- 80 Ramp | 7
! I- 80 Ramp | 7
! I- 80 Ramp | 7
! I- 80 Ramp | 7
! I- 880 | 2
! I- 880 | 2
! I- 880 | 2
! I- 880 | 2
! I- 880 | 2
! I- 880 | 5
! I- 880 | 5
! I- 880 | 5
! I- 880 | 5
! I- 880 | 5
! I- 880 | 5
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 6
! I- 880 | 7
! I- 880 | 7
! I- 880 | 7
! I- 880 | 7
! I- 880 | 7
! I- 880 | 7
! I- 880 | 7
! I- 880 | 9
! I- 880 | 9
! I- 880 | 9
! I- 880 | 9
! I- 880 | 9
! I- 880 | 9
! I- 880 | 9
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 10
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 12
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 13
! I- 880 | 14
! I- 880 | 14
! I- 880 | 14
! I- 880 | 14
! I- 880 | 14
! I- 880 | 14
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 17
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 | 19
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 2
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 3
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 4
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 5
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 6
! I- 880 Ramp | 8
! I- 880 Ramp | 8
! I- 880 Ramp | 8
! I- 980 | 2
! I- 980 | 2
! I- 980 | 2
! I- 980 | 2
! I- 980 | 2
! I- 980 | 2
! I- 980 | 2
! I- 980 | 2
! I- 980 | 3
! I- 980 | 3
! I- 980 | 3
! I- 980 | 3
! I- 980 | 3
! I- 980 | 3
! I- 980 | 3
! I- 980 | 3
! I- 980 | 3
! I- 980 | 4
! I- 980 | 4
! I- 980 | 5
! I- 980 | 5
! I- 980 | 7
! I- 980 | 7
! I- 980 | 7
! I- 980 | 7
! I- 980 | 12
! I- 980 Ramp | 3
! I- 980 Ramp | 3
! I- 980 Ramp | 3
! I- 980 Ramp | 7
! (894 rows)
!
SELECT * FROM toyemp WHERE name = 'sharon';
name | age | location | annualsal
! --------+-----+----------+-----------
! sharon | 25 | (15,12) | 12000
! (1 row)
--- 4,16 ----
--
SELECT * FROM street;
name | thepath | cname
! ------+---------+-------
! (0 rows)
SELECT name, #thepath FROM iexit ORDER BY 1, 2;
! ERROR: Relation 'iexit' does not exist
SELECT * FROM toyemp WHERE name = 'sharon';
name | age | location | annualsal
! ------+-----+----------+-----------
! (0 rows)
----------------------
*** expected/alter_table.out Tue Mar 14 18:06:55 2000
--- results/alter_table.out Fri Feb 23 08:16:03 2001
***************
*** 3,8 ****
--- 3,9 ----
-- add attribute
--
CREATE TABLE tmp (initial int4);
+ ERROR: Relation 'tmp' already exists
ALTER TABLE tmp ADD COLUMN a int4;
ALTER TABLE tmp ADD COLUMN b name;
ALTER TABLE tmp ADD COLUMN c text;
***************
*** 40,47 ****
'1/3', '1,name', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
ERROR: Relation 'tmp' does not have attribute 'k'
SELECT * FROM tmp;
! initial | a | b | c | d | e | f | g | h | i | j | l | m | n | p | q | r | s | t | u | v | w | x | y | z
! ---------+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---
(0 rows)
DROP TABLE tmp;
--- 41,48 ----
'1/3', '1,name', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
ERROR: Relation 'tmp' does not have attribute 'k'
SELECT * FROM tmp;
! two | stringu1 | ten | string4 | a | b | c | d | e | f | g | h | i | j | l | m | n | p | q | r | s | t | u | v | w |
x| y | z
!
-----+----------+-----+---------+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---
(0 rows)
DROP TABLE tmp;
***************
*** 103,261 ****
SELECT unique1 FROM ten_k WHERE unique1 < 20;
unique1
---------
! 0
! 1
! 2
! 3
! 4
! 5
! 6
! 7
! 8
! 9
! 10
! 11
! 12
! 13
! 14
! 15
! 16
! 17
! 18
! 19
! (20 rows)
-- 20 values, sorted
SELECT unique2 FROM ten_k WHERE unique2 < 20;
unique2
---------
! 0
! 1
! 2
! 3
! 4
! 5
! 6
! 7
! 8
! 9
! 10
! 11
! 12
! 13
! 14
! 15
! 16
! 17
! 18
! 19
! (20 rows)
-- 100 values, sorted
SELECT hundred FROM ten_k WHERE hundred = 50;
hundred
---------
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! (100 rows)
ALTER TABLE ten_k RENAME TO tenk1;
-- 5 values, sorted
--- 104,122 ----
SELECT unique1 FROM ten_k WHERE unique1 < 20;
unique1
---------
! (0 rows)
-- 20 values, sorted
SELECT unique2 FROM ten_k WHERE unique2 < 20;
unique2
---------
! (0 rows)
-- 100 values, sorted
SELECT hundred FROM ten_k WHERE hundred = 50;
hundred
---------
! (0 rows)
ALTER TABLE ten_k RENAME TO tenk1;
-- 5 values, sorted
***************
*** 262,273 ****
SELECT unique1 FROM tenk1 WHERE unique1 < 5;
unique1
---------
! 0
! 1
! 2
! 3
! 4
! (5 rows)
-- FOREIGN KEY CONSTRAINT adding TEST
CREATE TABLE tmp2 (a int primary key);
--- 123,129 ----
SELECT unique1 FROM tenk1 WHERE unique1 < 5;
unique1
---------
! (0 rows)
-- FOREIGN KEY CONSTRAINT adding TEST
CREATE TABLE tmp2 (a int primary key);
----------------------
*** expected/portals_p2.out Sat Jan 8 22:48:37 2000
--- results/portals_p2.out Fri Feb 23 08:15:53 2001
***************
*** 32,111 ****
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;
--- 32,98 ----
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/rules.out Wed Apr 19 20:32:57 2000
--- results/rules.out Fri Feb 23 08:16:15 2001
***************
*** 1164,1170 ****
SELECT viewname, definition FROM pg_views ORDER BY viewname;
viewname |
definition
--------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- iexit | SELECT ih.name, ih.thepath, interpt_pp(ih.thepath, r.thepath) AS exit FROM ihighway ih, ramp r
WHERE(ih.thepath ## r.thepath);
pg_indexes | SELECT c.relname AS tablename, i.relname AS indexname, pg_get_indexdef(x.indexrelid) AS
indexdefFROM pg_index x, pg_class c, pg_class i WHERE ((c.oid = x.indrelid) AND (i.oid = x.indexrelid));
pg_rules | SELECT c.relname AS tablename, r.rulename, pg_get_ruledef(r.rulename) AS definition FROM
pg_rewriter, pg_class c WHERE ((r.rulename !~ '^_RET'::text) AND (c.oid = r.ev_class));
pg_tables | SELECT c.relname AS tablename, pg_get_userbyid(c.relowner) AS tableowner, c.relhasindex AS
hasindexes,c.relhasrules AS hasrules, (c.reltriggers > 0) AS hastriggers FROM pg_class c WHERE (((c.relkind =
'r'::"char")OR (c.relkind = 's'::"char")) AND (NOT (EXISTS (SELECT pg_rewrite.rulename FROM pg_rewrite WHERE
((pg_rewrite.ev_class= c.oid) AND (pg_rewrite.ev_type = '1'::"char"))))));
--- 1164,1169 ----
***************
*** 1184,1190 ****
shoelace_obsolete | SELECT shoelace.sl_name, shoelace.sl_avail, shoelace.sl_color, shoelace.sl_len,
shoelace.sl_unit,shoelace.sl_len_cm FROM shoelace WHERE (NOT (EXISTS (SELECT shoe.shoename FROM shoe WHERE
(shoe.slcolor= shoelace.sl_color))));
street | SELECT r.name, r.thepath, c.cname FROM road r, real_city c WHERE (c.outline ## r.thepath);
toyemp | SELECT emp.name, emp.age, emp."location", (12 * emp.salary) AS annualsal FROM emp;
! (20 rows)
SELECT tablename, rulename, definition FROM pg_rules
ORDER BY tablename, rulename;
--- 1183,1189 ----
shoelace_obsolete | SELECT shoelace.sl_name, shoelace.sl_avail, shoelace.sl_color, shoelace.sl_len,
shoelace.sl_unit,shoelace.sl_len_cm FROM shoelace WHERE (NOT (EXISTS (SELECT shoe.shoename FROM shoe WHERE
(shoe.slcolor= shoelace.sl_color))));
street | SELECT r.name, r.thepath, c.cname FROM road r, real_city c WHERE (c.outline ## r.thepath);
toyemp | SELECT emp.name, emp.age, emp."location", (12 * emp.salary) AS annualsal FROM emp;
! (19 rows)
SELECT tablename, rulename, definition FROM pg_rules
ORDER BY tablename, rulename;
----------------------
*** expected/limit.out Sat Jan 8 22:48:37 2000
--- results/limit.out Fri Feb 23 08:16:27 2001
***************
*** 7,15 ****
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
--- 7,13 ----
ORDER BY unique1 LIMIT 2;
two | unique1 | unique2 | stringu1
-----+---------+---------+----------
! (0 rows)
SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek WHERE unique1 > 60
***************
*** 16,27 ****
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
--- 14,20 ----
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
***************
*** 28,36 ****
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
--- 21,27 ----
ORDER BY unique1 LIMIT 5;
two | unique1 | unique2 | stringu1
-----+---------+---------+----------
! (0 rows)
SELECT ''::text AS three, unique1, unique2, stringu1
FROM onek WHERE unique1 > 100
***************
*** 37,46 ****
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
--- 28,34 ----
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,71 ****
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
--- 42,48 ----
ORDER BY unique1 DESC LIMIT 20 OFFSET 39;
eleven | unique1 | unique2 | stringu1
--------+---------+---------+----------
! (0 rows)
SELECT ''::text AS ten, unique1, unique2, stringu1
FROM onek
***************
*** 72,88 ****
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
--- 49,55 ----
ORDER BY unique1 OFFSET 990;
ten | unique1 | unique2 | stringu1
-----+---------+---------+----------
! (0 rows)
SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek
***************
*** 89,100 ****
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
--- 56,62 ----
ORDER BY unique1 OFFSET 990 LIMIT 5;
five | unique1 | unique2 | stringu1
------+---------+---------+----------
! (0 rows)
SELECT ''::text AS five, unique1, unique2, stringu1
FROM onek
***************
*** 101,110 ****
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)
--- 63,67 ----
ORDER BY unique1 LIMIT 5, 900;
five | unique1 | unique2 | stringu1
------+---------+---------+----------
! (0 rows)
----------------------
$ make runcheck
MULTIBYTE=;export MULTIBYTE; \
/bin/sh ./run_check.sh sparc-sun-solaris2.8
=============== Removing old ./tmp_check directory ... ================
=============== Create ./tmp_check directory ================
=============== Installing new build into ./tmp_check ================
=============== Initializing check database instance ================
=============== Starting regression postmaster ================
Regression postmaster is running - PID=8998 PGPORT=65432
=============== Creating regression database... ================
CREATE DATABASE
=============== Installing PL/pgSQL... ================
=============== Running regression queries... ================
parallel group1 (12 tests) ...
text char name boolean oid int2 float4 int4 varchar int8 float8 numeric
test boolean ... ok
test char ... ok
test name ... ok
test varchar ... ok
test text ... ok
test int2 ... ok
test int4 ... ok
test int8 ... ok
test oid ... ok
test float4 ... ok
test float8 ... ok
test numeric ... ok
sequential test strings ... ok
sequential test numerology ... ok
parallel group2 (15 tests) ...
path comments lseg polygon box circle reltime interval tinterval point inet timestamp type_sanity
opr_sanity oidjoins
test point ... ok
test lseg ... ok
test box ... ok
test path ... ok
test polygon ... ok
test circle ... ok
test interval ... ok
test timestamp ... ok
test reltime ... ok
test tinterval ... ok
test inet ... ok
test comments ... ok
test oidjoins ... ok
test type_sanity ... ok
test opr_sanity ... ok
sequential test abstime ... ok
sequential test geometry ... ok
sequential test horology ... ok
sequential test create_function_1 ... ./run_check.sh: sql/create_function_1.sql: cannot open
diff: expected/create_function_1.out: No such file or directory
ok
sequential test create_type ... FAILED
sequential test create_table ... ok
sequential test create_function_2 ... ./run_check.sh: sql/create_function_2.sql: cannot open
diff: expected/create_function_2.out: No such file or directory
ok
sequential test copy ... ./run_check.sh: sql/copy.sql: cannot open
diff: expected/copy.out: No such file or directory
ok
parallel group3 (6 tests) ...
./run_check.sh: sql/constraints.sql: cannot open
constraints create_aggregate create_operator create_misc triggers create_index
test constraints ... diff: expected/constraints.out: No such file or directory
ok
test triggers ... FAILED
test create_misc ... ok
test create_aggregate ... ok
test create_operator ... FAILED
test create_index ... FAILED
sequential test create_view ... FAILED
sequential test sanity_check ... ok
sequential test errors ... ok
sequential test select ... FAILED
parallel group4 (16 tests) ...
select_distinct_on select_distinct random union arrays select_having aggregates transactions select_into
btree_index hash_index portals subselect select_implicit join case
test select_into ... ok
test select_distinct ... FAILED
test select_distinct_on ... FAILED
test select_implicit ... ok
test select_having ... ok
test subselect ... ok
test union ... ok
test case ... ok
test join ... ok
test aggregates ... FAILED
test transactions ... FAILED
test random ... FAILED
test portals ... FAILED
test arrays ... ok
test btree_index ... FAILED
test hash_index ... FAILED
sequential test misc ... ./run_check.sh: sql/misc.sql: cannot open
diff: expected/misc.out: No such file or directory
ok
parallel group5 (5 tests) ...
select_views portals_p2 alter_table foreign_key rules
test select_views ... FAILED
test alter_table ... FAILED
test portals_p2 ... FAILED
test rules ... FAILED
test foreign_key ... ok
parallel group6 (3 tests) ...
limit temp plpgsql
test limit ... FAILED
test plpgsql ... ok
test temp ... ok
=============== Terminating regression postmaster ================
ACTUAL RESULTS OF REGRESSION TEST ARE NOW IN FILES run_check.out
AND regress.out
To run the optional big test(s) too, type 'make bigcheck'
These big tests can take over an hour to complete
These actually are: numeric_big
$
Attachment
pgsql-admin by date: