*** 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 indexdef FROM 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_rewrite r, 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) ----------------------