Postgres 6.5.1 success - Mailing list pgsql-ports
| From | Cheng Leong |
|---|---|
| Subject | Postgres 6.5.1 success |
| Date | |
| Msg-id | 37C5B7E3.74726D4D@planetall.com Whole thread Raw |
| List | pgsql-ports |
compiled 6.5.1 onto RedHat v6.0 Linux 2.2.5-15 running on i586 compile and install a-ok regression summary follows, e-mail if you want more logs, it looks like mostly floating point rounding differences Cheng Leong -- NioTerra http://www.nioterra.com 512/708-1727 1404A W.12th St. Austin, TX 78703=============== Notes... ================= postmaster must already be running for the regression tests to succeed. The time zone is now set to PST8PDT explicitly by this regression test client frontend. Please report any apparent problems to ports@postgresql.org See regress/README for more information. =============== destroying old regression database... ================= ERROR: destroydb: database 'regression' does not exist destroydb: database destroy failed on regression. =============== creating new regression database... ================= =============== installing PL/pgSQL... ================= =============== running regression queries... ================= boolean .. ok char .. ok name .. ok varchar .. ok text .. ok strings .. ok int2 .. ok int4 .. ok int8 .. ok oid .. ok float4 .. ok float8 .. failed numerology .. ok point .. ok lseg .. ok box .. ok path .. ok polygon .. ok circle .. ok geometry .. failed timespan .. ok datetime .. ok reltime .. ok abstime .. ok tinterval .. ok horology .. ok inet .. ok comments .. ok oidjoins .. ok type_sanity .. ok opr_sanity .. ok create_function_1 .. ok create_type .. ok create_table .. ok create_function_2 .. ok constraints .. ok triggers .. ok copy .. failed create_misc .. ok create_aggregate .. ok create_operator .. ok create_view .. ok create_index .. ok sanity_check .. ok errors .. ok select .. failed select_into .. ok select_distinct .. failed select_distinct_on .. failed select_implicit .. ok select_having .. ok subselect .. ok union .. ok case .. ok join .. ok aggregates .. failed transactions .. ok random .. failed portals .. ok misc .. failed arrays .. ok btree_index .. ok hash_index .. ok select_views .. ok alter_table .. ok portals_p2 .. failed rules .. ok limit .. failed plpgsql .. ok temp .. ok numeric .. ok *** expected/float8.out Sat Jan 23 18:12:59 1999 --- results/float8.out Mon Aug 23 21:40:50 1999 *************** *** 189,201 **** QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f; ERROR: Bad float8 input format -- overflow QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f; ! ERROR: pow() result is out of range QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ; ERROR: can't take log of zero QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ; ERROR: can't take log of a negative number QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f; ! ERROR: exp() result is out of range QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f; ERROR: float8div: divide by zero error QUERY: SELECT '' AS five, FLOAT8_TBL.*; --- 189,217 ---- QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f; ERROR: Bad float8 input format -- overflow QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f; ! bad|?column? ! ---+-------- ! |0 ! |NaN ! |NaN ! |NaN ! |NaN ! (5 rows) ! QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ; ERROR: can't take log of zero QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ; ERROR: can't take log of a negative number QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f; ! bad| ?column? ! ---+-------------------- ! | 1 ! |7.39912306090513e-16 ! | 0 ! | 0 ! | 1 ! (5 rows) ! QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f; ERROR: float8div: divide by zero error QUERY: SELECT '' AS five, FLOAT8_TBL.*; ---------------------- *** expected/geometry.out Sun Dec 13 17:49:18 1998 --- results/geometry.out Mon Aug 23 21:40:59 1999 *************** *** 112,118 **** |(-5,-12) |[(10,-10),(-3,-4)] |(-1.60487804878049,-4.64390243902439) |(10,10) |[(10,-10),(-3,-4)] |(2.39024390243902,-6.48780487804878) |(0,0) |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264) ! |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140473) |(-3,4) |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303) |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925) |(-5,-12) |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616) --- 112,118 ---- |(-5,-12) |[(10,-10),(-3,-4)] |(-1.60487804878049,-4.64390243902439) |(10,10) |[(10,-10),(-3,-4)] |(2.39024390243902,-6.48780487804878) |(0,0) |[(-1000000,200),(300000,-40)]|(0.0028402365895872,15.384614860264) ! |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472) |(-3,4) |[(-1000000,200),(300000,-40)]|(-2.99789812267519,15.3851688427303) |(5.1,34.5)|[(-1000000,200),(300000,-40)]|(5.09647083221496,15.3836744976925) |(-5,-12) |[(-1000000,200),(300000,-40)]|(-4.99494420845634,15.3855375281616) *************** *** 409,433 **** QUERY: SELECT '' AS six, polygon(f1) FROM CIRCLE_TBL; six|polygon ! ---+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ! |((-3,0),(-2.59807621135332,1.5),(-1.5,2.59807621135332),(-1.83690953073357e-16,3),(1.5,2.59807621135332),(2.59807621135332,1.5),(3,3.67381906146713e-16),(2.59807621135332,-1.5),(1.5,-2.59807621135332),(5.5107285922007e-16,-3),(-1.5,-2.59807621135332),(-2.59807621135332,-1.5)) ! |((-99,2),(-85.6025403784439,52),(-49,88.6025403784439),(0.999999999999994,102),(51,88.6025403784439),(87.6025403784439,52),(101,2.00000000000001),(87.6025403784439,-48),(51,-84.6025403784438),(1.00000000000002,-98),(-49,-84.6025403784439),(-85.6025403784438,-48)) ! |((-4,3),(-3.33012701892219,5.5),(-1.5,7.33012701892219),(1,8),(3.5,7.33012701892219),(5.33012701892219,5.5),(6,3),(5.33012701892219,0.500000000000001),(3.5,-1.33012701892219),(1,-2),(-1.5,-1.33012701892219),(-3.33012701892219,0.499999999999998)) ! |((-2,2),(-1.59807621135332,3.5),(-0.5,4.59807621135332),(1,5),(2.5,4.59807621135332),(3.59807621135332,3.5),(4,2),(3.59807621135332,0.500000000000001),(2.5,-0.598076211353315),(1,-1),(-0.5,-0.598076211353316),(-1.59807621135332,0.499999999999999)) ! |((90,200),(91.3397459621556,205),(95,208.660254037844),(100,210),(105,208.660254037844),(108.660254037844,205),(110,200),(108.660254037844,195),(105,191.339745962156),(100,190),(95,191.339745962156),(91.3397459621556,195)) ! |((0,0),(13.3974596215561,50),(50,86.6025403784439),(100,100),(150,86.6025403784439),(186.602540378444,50),(200,1.22460635382238e-14),(186.602540378444,-50),(150,-86.6025403784438),(100,-100),(50,-86.6025403784439),(13.3974596215562,-50)) (6 rows) QUERY: SELECT '' AS six, polygon(8, f1) FROM CIRCLE_TBL; six|polygon ! ---+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ! |((-3,0),(-2.12132034355964,2.12132034355964),(-1.83690953073357e-16,3),(2.12132034355964,2.12132034355964),(3,3.67381906146713e-16),(2.12132034355964,-2.12132034355964),(5.5107285922007e-16,-3),(-2.12132034355964,-2.12132034355964)) ! |((-99,2),(-69.7106781186548,72.7106781186548),(0.999999999999994,102),(71.7106781186547,72.7106781186548),(101,2.00000000000001),(71.7106781186548,-68.7106781186547),(1.00000000000002,-98),(-69.7106781186547,-68.7106781186548)) ! |((-4,3),(-2.53553390593274,6.53553390593274),(1,8),(4.53553390593274,6.53553390593274),(6,3),(4.53553390593274,-0.535533905932737),(1,-2),(-2.53553390593274,-0.535533905932738)) ! |((-2,2),(-1.12132034355964,4.12132034355964),(1,5),(3.12132034355964,4.12132034355964),(4,2),(3.12132034355964,-0.121320343559642),(1,-1),(-1.12132034355964,-0.121320343559643)) ! |((90,200),(92.9289321881345,207.071067811865),(100,210),(107.071067811865,207.071067811865),(110,200),(107.071067811865,192.928932188135),(100,190),(92.9289321881345,192.928932188135)) ! |((0,0),(29.2893218813452,70.7106781186548),(100,100),(170.710678118655,70.7106781186548),(200,1.22460635382238e-14),(170.710678118655,-70.7106781186547),(100,-100),(29.2893218813453,-70.7106781186548)) (6 rows) QUERY: SELECT '' AS six, circle(f1, 50.0) --- 409,433 ---- QUERY: SELECT '' AS six, polygon(f1) FROM CIRCLE_TBL; six|polygon ! ---+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ! |((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359078377e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718156754e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077235131e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138)) ! |((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795)) ! |((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887966),(-3.33012701896897,0.500000000081028)) ! |((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048617)) ! |((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162)) ! |((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239385585e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795)) (6 rows) QUERY: SELECT '' AS six, polygon(8, f1) FROM CIRCLE_TBL; six|polygon ! ---+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ! |((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359078377e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718156754e-11),(2.12132034353258,-2.12132034358671),(-4.59307077235131e-11,-3),(-2.12132034359753,-2.12132034352175)) ! |((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.710678119196,72.7106781181134),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917)) ! |((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586)) ! |((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752)) ! |((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261)) ! |((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181134),(200,-1.02068239385585e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917)) (6 rows) QUERY: SELECT '' AS six, circle(f1, 50.0) ---------------------- *** expected/copy.out Mon Aug 23 21:40:32 1999 --- results/copy.out Mon Aug 23 21:42:28 1999 *************** *** 1,8 **** --- 1,10 ---- QUERY: COPY aggtest FROM '/usr/src/pgsql/src/test/regress/input/../data/agg.data'; QUERY: COPY onek FROM '/usr/src/pgsql/src/test/regress/input/../data/onek.data'; QUERY: COPY onek TO '/usr/src/pgsql/src/test/regress/input/../results/onek.data'; + ERROR: COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/onek.data'for writing. Errno = Permission denied (13). QUERY: DELETE FROM onek; QUERY: COPY onek FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data'; + ERROR: COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/onek.data'for reading. Errno = No such file or directory (2). QUERY: COPY tenk1 FROM '/usr/src/pgsql/src/test/regress/input/../data/tenk.data'; QUERY: COPY slow_emp4000 FROM '/usr/src/pgsql/src/test/regress/input/../data/rect.data'; QUERY: COPY person FROM '/usr/src/pgsql/src/test/regress/input/../data/person.data'; ---------------------- *** expected/select.out Mon Feb 1 21:45:39 1999 --- results/select.out Mon Aug 23 21:44:00 1999 *************** *** 1,176 **** QUERY: SELECT onek.* WHERE onek.unique1 < 10; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 0| 998| 0| 0| 0| 0| 0| 0| 0| 0| 0| 0| 1|AAAAAA |KMBAAA |OOOOxx ! 1| 214| 1| 1| 1| 1| 1| 1| 1| 1| 1| 2| 3|BAAAAA |GIAAAA |OOOOxx ! 2| 326| 0| 2| 2| 2| 2| 2| 2| 2| 2| 4| 5|CAAAAA |OMAAAA |OOOOxx ! 3| 431| 1| 3| 3| 3| 3| 3| 3| 3| 3| 6| 7|DAAAAA |PQAAAA |VVVVxx ! 4| 833| 0| 0| 4| 4| 4| 4| 4| 4| 4| 8| 9|EAAAAA |BGBAAA |HHHHxx ! 5| 541| 1| 1| 5| 5| 5| 5| 5| 5| 5| 10| 11|FAAAAA |VUAAAA |HHHHxx ! 6| 978| 0| 2| 6| 6| 6| 6| 6| 6| 6| 12| 13|GAAAAA |QLBAAA |OOOOxx ! 7| 647| 1| 3| 7| 7| 7| 7| 7| 7| 7| 14| 15|HAAAAA |XYAAAA |VVVVxx ! 8| 653| 0| 0| 8| 8| 8| 8| 8| 8| 8| 16| 17|IAAAAA |DZAAAA |HHHHxx ! 9| 49| 1| 1| 9| 9| 9| 9| 9| 9| 9| 18| 19|JAAAAA |XBAAAA |HHHHxx ! (10 rows) QUERY: SELECT onek.unique1, onek.stringu1 WHERE onek.unique1 < 20 ORDER BY unique1 using >; unique1|stringu1 -------+-------- ! 19|TAAAAA ! 18|SAAAAA ! 17|RAAAAA ! 16|QAAAAA ! 15|PAAAAA ! 14|OAAAAA ! 13|NAAAAA ! 12|MAAAAA ! 11|LAAAAA ! 10|KAAAAA ! 9|JAAAAA ! 8|IAAAAA ! 7|HAAAAA ! 6|GAAAAA ! 5|FAAAAA ! 4|EAAAAA ! 3|DAAAAA ! 2|CAAAAA ! 1|BAAAAA ! 0|AAAAAA ! (20 rows) QUERY: SELECT onek.unique1, onek.stringu1 WHERE onek.unique1 > 980 ORDER BY stringu1 using <; unique1|stringu1 -------+-------- ! 988|AMAAAA ! 989|BMAAAA ! 990|CMAAAA ! 991|DMAAAA ! 992|EMAAAA ! 993|FMAAAA ! 994|GMAAAA ! 995|HMAAAA ! 996|IMAAAA ! 997|JMAAAA ! 998|KMAAAA ! 999|LMAAAA ! 981|TLAAAA ! 982|ULAAAA ! 983|VLAAAA ! 984|WLAAAA ! 985|XLAAAA ! 986|YLAAAA ! 987|ZLAAAA ! (19 rows) QUERY: SELECT onek.unique1, onek.string4 WHERE onek.unique1 > 980 ORDER BY string4 using <, unique1 using >; unique1|string4 -------+------- ! 999|AAAAxx ! 995|AAAAxx ! 983|AAAAxx ! 982|AAAAxx ! 981|AAAAxx ! 998|HHHHxx ! 997|HHHHxx ! 993|HHHHxx ! 990|HHHHxx ! 986|HHHHxx ! 996|OOOOxx ! 991|OOOOxx ! 988|OOOOxx ! 987|OOOOxx ! 985|OOOOxx ! 994|VVVVxx ! 992|VVVVxx ! 989|VVVVxx ! 984|VVVVxx ! (19 rows) QUERY: SELECT onek.unique1, onek.string4 WHERE onek.unique1 > 980 ORDER BY string4 using >, unique1 using <; unique1|string4 -------+------- ! 984|VVVVxx ! 989|VVVVxx ! 992|VVVVxx ! 994|VVVVxx ! 985|OOOOxx ! 987|OOOOxx ! 988|OOOOxx ! 991|OOOOxx ! 996|OOOOxx ! 986|HHHHxx ! 990|HHHHxx ! 993|HHHHxx ! 997|HHHHxx ! 998|HHHHxx ! 981|AAAAxx ! 982|AAAAxx ! 983|AAAAxx ! 995|AAAAxx ! 999|AAAAxx ! (19 rows) QUERY: SELECT onek.unique1, onek.string4 WHERE onek.unique1 < 20 ORDER BY unique1 using >, string4 using <; unique1|string4 -------+------- ! 19|OOOOxx ! 18|VVVVxx ! 17|HHHHxx ! 16|OOOOxx ! 15|VVVVxx ! 14|AAAAxx ! 13|OOOOxx ! 12|AAAAxx ! 11|OOOOxx ! 10|AAAAxx ! 9|HHHHxx ! 8|HHHHxx ! 7|VVVVxx ! 6|OOOOxx ! 5|HHHHxx ! 4|HHHHxx ! 3|VVVVxx ! 2|OOOOxx ! 1|OOOOxx ! 0|OOOOxx ! (20 rows) QUERY: SELECT onek.unique1, onek.string4 WHERE onek.unique1 < 20 ORDER BY unique1 using <, string4 using >; unique1|string4 -------+------- ! 0|OOOOxx ! 1|OOOOxx ! 2|OOOOxx ! 3|VVVVxx ! 4|HHHHxx ! 5|HHHHxx ! 6|OOOOxx ! 7|VVVVxx ! 8|HHHHxx ! 9|HHHHxx ! 10|AAAAxx ! 11|OOOOxx ! 12|AAAAxx ! 13|OOOOxx ! 14|AAAAxx ! 15|VVVVxx ! 16|OOOOxx ! 17|HHHHxx ! 18|VVVVxx ! 19|OOOOxx ! (20 rows) QUERY: SELECT two, stringu1, ten, string4 INTO TABLE tmp --- 1,49 ---- QUERY: SELECT onek.* WHERE onek.unique1 < 10; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: SELECT onek.unique1, onek.stringu1 WHERE onek.unique1 < 20 ORDER BY unique1 using >; unique1|stringu1 -------+-------- ! (0 rows) QUERY: SELECT onek.unique1, onek.stringu1 WHERE onek.unique1 > 980 ORDER BY stringu1 using <; unique1|stringu1 -------+-------- ! (0 rows) QUERY: SELECT onek.unique1, onek.string4 WHERE onek.unique1 > 980 ORDER BY string4 using <, unique1 using >; unique1|string4 -------+------- ! (0 rows) QUERY: SELECT onek.unique1, onek.string4 WHERE onek.unique1 > 980 ORDER BY string4 using >, unique1 using <; unique1|string4 -------+------- ! (0 rows) QUERY: SELECT onek.unique1, onek.string4 WHERE onek.unique1 < 20 ORDER BY unique1 using >, string4 using <; unique1|string4 -------+------- ! (0 rows) QUERY: SELECT onek.unique1, onek.string4 WHERE onek.unique1 < 20 ORDER BY unique1 using <, string4 using >; unique1|string4 -------+------- ! (0 rows) QUERY: SELECT two, stringu1, ten, string4 INTO TABLE tmp ---------------------- *** expected/select_distinct.out Mon Feb 1 21:45:39 1999 --- results/select_distinct.out Mon Aug 23 21:44:01 1999 *************** *** 1,80 **** QUERY: SELECT DISTINCT two FROM tmp; two --- ! 0 ! 1 ! (2 rows) QUERY: SELECT DISTINCT ten FROM tmp; ten --- ! 0 ! 1 ! 2 ! 3 ! 4 ! 5 ! 6 ! 7 ! 8 ! 9 ! (10 rows) QUERY: SELECT DISTINCT string4 FROM tmp; string4 ------- ! AAAAxx ! HHHHxx ! OOOOxx ! VVVVxx ! (4 rows) QUERY: SELECT DISTINCT two, string4, ten FROM tmp ORDER BY two using <, string4 using <, ten using <; two|string4|ten ---+-------+--- ! 0|AAAAxx | 0 ! 0|AAAAxx | 2 ! 0|AAAAxx | 4 ! 0|AAAAxx | 6 ! 0|AAAAxx | 8 ! 0|HHHHxx | 0 ! 0|HHHHxx | 2 ! 0|HHHHxx | 4 ! 0|HHHHxx | 6 ! 0|HHHHxx | 8 ! 0|OOOOxx | 0 ! 0|OOOOxx | 2 ! 0|OOOOxx | 4 ! 0|OOOOxx | 6 ! 0|OOOOxx | 8 ! 0|VVVVxx | 0 ! 0|VVVVxx | 2 ! 0|VVVVxx | 4 ! 0|VVVVxx | 6 ! 0|VVVVxx | 8 ! 1|AAAAxx | 1 ! 1|AAAAxx | 3 ! 1|AAAAxx | 5 ! 1|AAAAxx | 7 ! 1|AAAAxx | 9 ! 1|HHHHxx | 1 ! 1|HHHHxx | 3 ! 1|HHHHxx | 5 ! 1|HHHHxx | 7 ! 1|HHHHxx | 9 ! 1|OOOOxx | 1 ! 1|OOOOxx | 3 ! 1|OOOOxx | 5 ! 1|OOOOxx | 7 ! 1|OOOOxx | 9 ! 1|VVVVxx | 1 ! 1|VVVVxx | 3 ! 1|VVVVxx | 5 ! 1|VVVVxx | 7 ! 1|VVVVxx | 9 ! (40 rows) QUERY: SELECT DISTINCT p.age FROM person* p ORDER BY age using >; age --- 1,24 ---- QUERY: SELECT DISTINCT two FROM tmp; two --- ! (0 rows) QUERY: SELECT DISTINCT ten FROM tmp; ten --- ! (0 rows) QUERY: SELECT DISTINCT string4 FROM tmp; string4 ------- ! (0 rows) QUERY: SELECT DISTINCT two, string4, ten FROM tmp ORDER BY two using <, string4 using <, ten using <; two|string4|ten ---+-------+--- ! (0 rows) QUERY: SELECT DISTINCT p.age FROM person* p ORDER BY age using >; age ---------------------- *** expected/select_distinct_on.out Mon Feb 1 21:45:40 1999 --- results/select_distinct_on.out Mon Aug 23 21:44:01 1999 *************** *** 3,15 **** ORDER BY two using <, string4 using <, ten using <; two|string4|ten ---+-------+--- ! 0|AAAAxx | 0 ! 0|HHHHxx | 0 ! 0|OOOOxx | 0 ! 0|VVVVxx | 0 ! 1|AAAAxx | 1 ! 1|HHHHxx | 1 ! 1|OOOOxx | 1 ! 1|VVVVxx | 1 ! (8 rows) --- 3,7 ---- ORDER BY two using <, string4 using <, ten using <; two|string4|ten ---+-------+--- ! (0 rows) ---------------------- *** expected/aggregates.out Tue Apr 29 09:23:15 1997 --- results/aggregates.out Mon Aug 23 21:44:12 1999 *************** *** 1,7 **** QUERY: SELECT avg(four) AS avg_1 FROM onek; avg_1 ----- ! 1 (1 row) QUERY: SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100; --- 1,7 ---- QUERY: SELECT avg(four) AS avg_1 FROM onek; avg_1 ----- ! (1 row) QUERY: SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100; *************** *** 25,31 **** QUERY: SELECT sum(four) AS sum_1500 FROM onek; sum_1500 -------- ! 1500 (1 row) QUERY: SELECT sum(a) AS sum_198 FROM aggtest; --- 25,31 ---- QUERY: SELECT sum(four) AS sum_1500 FROM onek; sum_1500 -------- ! (1 row) QUERY: SELECT sum(a) AS sum_198 FROM aggtest; *************** *** 49,55 **** QUERY: SELECT max(four) AS max_3 FROM onek; max_3 ----- ! 3 (1 row) QUERY: SELECT max(a) AS max_100 FROM aggtest; --- 49,55 ---- QUERY: SELECT max(four) AS max_3 FROM onek; max_3 ----- ! (1 row) QUERY: SELECT max(a) AS max_100 FROM aggtest; *************** *** 73,96 **** QUERY: SELECT count(four) AS cnt_1000 FROM onek; cnt_1000 -------- ! 1000 (1 row) QUERY: SELECT newavg(four) AS avg_1 FROM onek; avg_1 ----- ! 1 (1 row) QUERY: SELECT newsum(four) AS sum_1500 FROM onek; sum_1500 -------- ! 1500 (1 row) QUERY: SELECT newcnt(four) AS cnt_1000 FROM onek; cnt_1000 -------- ! 1000 (1 row) --- 73,96 ---- QUERY: SELECT count(four) AS cnt_1000 FROM onek; cnt_1000 -------- ! 0 (1 row) QUERY: SELECT newavg(four) AS avg_1 FROM onek; avg_1 ----- ! 0 (1 row) QUERY: SELECT newsum(four) AS sum_1500 FROM onek; sum_1500 -------- ! 0 (1 row) QUERY: SELECT newcnt(four) AS cnt_1000 FROM onek; cnt_1000 -------- ! 0 (1 row) ---------------------- *** expected/random.out Mon Aug 17 11:11:15 1998 --- results/random.out Mon Aug 23 21:44:14 1999 *************** *** 1,7 **** QUERY: SELECT count(*) FROM onek; count ----- ! 1000 (1 row) QUERY: SELECT count(*) AS random INTO RANDOM_TBL --- 1,7 ---- QUERY: SELECT count(*) FROM onek; count ----- ! 0 (1 row) QUERY: SELECT count(*) AS random INTO RANDOM_TBL *************** *** 13,23 **** GROUP BY random HAVING count(random) > 1; random|count ------+----- ! (0 rows) QUERY: SELECT random FROM RANDOM_TBL WHERE random NOT BETWEEN 80 AND 120; random ------ ! (0 rows) --- 13,26 ---- GROUP BY random HAVING count(random) > 1; random|count ------+----- ! 0| 2 ! (1 row) QUERY: SELECT random FROM RANDOM_TBL WHERE random NOT BETWEEN 80 AND 120; random ------ ! 0 ! 0 ! (2 rows) ---------------------- *** expected/misc.out Mon Aug 23 21:40:32 1999 --- results/misc.out Mon Aug 23 21:44:18 1999 *************** *** 12,45 **** onek2.stringu1 = tmp.stringu1; QUERY: DROP TABLE tmp; QUERY: COPY onek TO '/usr/src/pgsql/src/test/regress/input/../results/onek.data'; QUERY: DELETE FROM onek; QUERY: COPY onek FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data'; QUERY: SELECT unique1 FROM onek WHERE unique1 < 2; unique1 ------- ! 0 ! 1 ! (2 rows) QUERY: DELETE FROM onek2; QUERY: COPY onek2 FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data'; QUERY: SELECT unique1 FROM onek2 WHERE unique1 < 2; unique1 ------- ! 0 ! 1 ! (2 rows) QUERY: COPY BINARY stud_emp TO '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data'; QUERY: DELETE FROM stud_emp; QUERY: COPY BINARY stud_emp FROM '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data'; QUERY: SELECT * FROM stud_emp; name |age|location |salary|manager|gpa|percent ! -----+---+----------+------+-------+---+------- ! jeff | 23|(8,7.7) | 600|sharon |3.5| ! cim | 30|(10.5,4.7)| 400| |3.4| ! linda| 19|(0.9,6.1) | 100| |2.9| ! (3 rows) QUERY: SELECT * FROM a_star*; class| a --- 12,43 ---- onek2.stringu1 = tmp.stringu1; QUERY: DROP TABLE tmp; QUERY: COPY onek TO '/usr/src/pgsql/src/test/regress/input/../results/onek.data'; + ERROR: COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/onek.data'for writing. Errno = Permission denied (13). QUERY: DELETE FROM onek; QUERY: COPY onek FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data'; + ERROR: COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/onek.data'for reading. Errno = No such file or directory (2). QUERY: SELECT unique1 FROM onek WHERE unique1 < 2; unique1 ------- ! (0 rows) QUERY: DELETE FROM onek2; QUERY: COPY onek2 FROM '/usr/src/pgsql/src/test/regress/input/../results/onek.data'; + ERROR: COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/onek.data'for reading. Errno = No such file or directory (2). QUERY: SELECT unique1 FROM onek2 WHERE unique1 < 2; unique1 ------- ! (0 rows) QUERY: COPY BINARY stud_emp TO '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data'; + ERROR: COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data'for writing. Errno = Permission denied (13). QUERY: DELETE FROM stud_emp; QUERY: COPY BINARY stud_emp FROM '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data'; + ERROR: COPY command, running in backend with effective uid 503, could not open file '/usr/src/pgsql/src/test/regress/input/../results/stud_emp.data'for reading. Errno = No such file or directory (2). QUERY: SELECT * FROM stud_emp; name|age|location|salary|manager|gpa|percent ! ----+---+--------+------+-------+---+------- ! (0 rows) QUERY: SELECT * FROM a_star*; class| a *************** *** 376,383 **** mike |posthacking joe |basketball sally|basketball ! jeff |posthacking ! (4 rows) QUERY: SELECT DISTINCT hobbies_r.name, hobbies_r.equipment.name FROM hobbies_r; name |name --- 374,380 ---- mike |posthacking joe |basketball sally|basketball ! (3 rows) QUERY: SELECT DISTINCT hobbies_r.name, hobbies_r.equipment.name FROM hobbies_r; name |name *************** *** 414,421 **** mike |posthacking|advil joe |basketball |peet's coffee sally|basketball |hightops ! jeff |posthacking|advil ! (4 rows) QUERY: SELECT p.hobbies.equipment.name, p.name, p.hobbies.name FROM person p; name |name |name --- 411,417 ---- mike |posthacking|advil joe |basketball |peet's coffee sally|basketball |hightops ! (3 rows) QUERY: SELECT p.hobbies.equipment.name, p.name, p.hobbies.name FROM person p; name |name |name *************** *** 431,438 **** advil |mike |posthacking hightops|joe |basketball hightops|sally|basketball ! advil |jeff |posthacking ! (4 rows) QUERY: SELECT p.hobbies.equipment.name, p.hobbies.name, p.name FROM person p; name |name |name --- 427,433 ---- advil |mike |posthacking hightops|joe |basketball hightops|sally|basketball ! (3 rows) QUERY: SELECT p.hobbies.equipment.name, p.hobbies.name, p.name FROM person p; name |name |name *************** *** 448,455 **** advil |posthacking|mike peet's coffee|basketball |joe hightops |basketball |sally ! advil |posthacking|jeff ! (4 rows) QUERY: SELECT user_relns() AS user_relns ORDER BY user_relns; --- 443,449 ---- advil |posthacking|mike peet's coffee|basketball |joe hightops |basketball |sally ! (3 rows) QUERY: SELECT user_relns() AS user_relns ORDER BY user_relns; ---------------------- *** expected/portals_p2.out Mon May 5 01:43:59 1997 --- results/portals_p2.out Mon Aug 23 21:44:38 1999 *************** *** 28,107 **** QUERY: FETCH all in foo13; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 50| 253| 0| 2| 0| 10| 0| 50| 50| 50| 50| 0| 1|YBAAAA |TJAAAA |HHHHxx ! (1 row) QUERY: FETCH all in foo14; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 51| 76| 1| 3| 1| 11| 1| 51| 51| 51| 51| 2| 3|ZBAAAA |YCAAAA |AAAAxx ! (1 row) QUERY: FETCH all in foo15; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 52| 985| 0| 0| 2| 12| 2| 52| 52| 52| 52| 4| 5|ACAAAA |XLBAAA |HHHHxx ! (1 row) QUERY: FETCH all in foo16; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 53| 196| 1| 1| 3| 13| 3| 53| 53| 53| 53| 6| 7|BCAAAA |OHAAAA |AAAAxx ! (1 row) QUERY: FETCH all in foo17; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 54| 356| 0| 2| 4| 14| 4| 54| 54| 54| 54| 8| 9|CCAAAA |SNAAAA |AAAAxx ! (1 row) QUERY: FETCH all in foo18; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 55| 627| 1| 3| 5| 15| 5| 55| 55| 55| 55| 10| 11|DCAAAA |DYAAAA |VVVVxx ! (1 row) QUERY: FETCH all in foo19; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 56| 54| 0| 0| 6| 16| 6| 56| 56| 56| 56| 12| 13|ECAAAA |CCAAAA |OOOOxx ! (1 row) QUERY: FETCH all in foo20; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 57| 942| 1| 1| 7| 17| 7| 57| 57| 57| 57| 14| 15|FCAAAA |GKBAAA |OOOOxx ! (1 row) QUERY: FETCH all in foo21; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 58| 114| 0| 2| 8| 18| 8| 58| 58| 58| 58| 16| 17|GCAAAA |KEAAAA |OOOOxx ! (1 row) QUERY: FETCH all in foo22; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 59| 593| 1| 3| 9| 19| 9| 59| 59| 59| 59| 18| 19|HCAAAA |VWAAAA |HHHHxx ! (1 row) QUERY: FETCH all in foo23; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 60| 483| 0| 0| 0| 0| 0| 60| 60| 60| 60| 0| 1|ICAAAA |PSAAAA |VVVVxx ! (1 row) QUERY: FETCH all in foo24; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 50| 253| 0| 2| 0| 10| 0| 50| 50| 50| 50| 0| 1|YBAAAA |TJAAAA |HHHHxx ! (1 row) QUERY: FETCH all in foo25; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! 60| 483| 0| 0| 0| 0| 0| 60| 60| 60| 60| 0| 1|ICAAAA |PSAAAA |VVVVxx ! (1 row) QUERY: CLOSE foo13; QUERY: CLOSE foo14; --- 28,94 ---- QUERY: FETCH all in foo13; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: FETCH all in foo14; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: FETCH all in foo15; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: FETCH all in foo16; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: FETCH all in foo17; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: FETCH all in foo18; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: FETCH all in foo19; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: FETCH all in foo20; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: FETCH all in foo21; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: FETCH all in foo22; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: FETCH all in foo23; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: FETCH all in foo24; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: FETCH all in foo25; unique1|unique2|two|four|ten|twenty|hundred|thousand|twothousand|fivethous|tenthous|odd|even|stringu1|stringu2|string4 -------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+------- ! (0 rows) QUERY: CLOSE foo13; QUERY: CLOSE foo14; ---------------------- *** expected/limit.out Mon Feb 8 08:14:22 1999 --- results/limit.out Mon Aug 23 21:45:16 1999 *************** *** 3,42 **** ORDER BY unique1 LIMIT 2; two|unique1|unique2|stringu1 ---+-------+-------+-------- ! | 51| 76|ZBAAAA ! | 52| 985|ACAAAA ! (2 rows) QUERY: SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek WHERE unique1 > 60 ORDER BY unique1 LIMIT 5; five|unique1|unique2|stringu1 ----+-------+-------+-------- ! | 61| 560|JCAAAA ! | 62| 633|KCAAAA ! | 63| 296|LCAAAA ! | 64| 479|MCAAAA ! | 65| 64|NCAAAA ! (5 rows) QUERY: SELECT ''::text AS two, unique1, unique2, stringu1 FROM onek WHERE unique1 > 60 AND unique1 < 63 ORDER BY unique1 LIMIT 5; two|unique1|unique2|stringu1 ---+-------+-------+-------- ! | 61| 560|JCAAAA ! | 62| 633|KCAAAA ! (2 rows) QUERY: SELECT ''::text AS three, unique1, unique2, stringu1 FROM onek WHERE unique1 > 100 ORDER BY unique1 LIMIT 3 OFFSET 20; three|unique1|unique2|stringu1 -----+-------+-------+-------- ! | 121| 700|REAAAA ! | 122| 519|SEAAAA ! | 123| 777|TEAAAA ! (3 rows) QUERY: SELECT ''::text AS zero, unique1, unique2, stringu1 FROM onek WHERE unique1 < 50 --- 3,30 ---- ORDER BY unique1 LIMIT 2; two|unique1|unique2|stringu1 ---+-------+-------+-------- ! (0 rows) QUERY: SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek WHERE unique1 > 60 ORDER BY unique1 LIMIT 5; five|unique1|unique2|stringu1 ----+-------+-------+-------- ! (0 rows) QUERY: SELECT ''::text AS two, unique1, unique2, stringu1 FROM onek WHERE unique1 > 60 AND unique1 < 63 ORDER BY unique1 LIMIT 5; two|unique1|unique2|stringu1 ---+-------+-------+-------- ! (0 rows) QUERY: SELECT ''::text AS three, unique1, unique2, stringu1 FROM onek WHERE unique1 > 100 ORDER BY unique1 LIMIT 3 OFFSET 20; three|unique1|unique2|stringu1 -----+-------+-------+-------- ! (0 rows) QUERY: SELECT ''::text AS zero, unique1, unique2, stringu1 FROM onek WHERE unique1 < 50 *************** *** 50,106 **** ORDER BY unique1 DESC LIMIT 20 OFFSET 39; eleven|unique1|unique2|stringu1 ------+-------+-------+-------- ! | 10| 520|KAAAAA ! | 9| 49|JAAAAA ! | 8| 653|IAAAAA ! | 7| 647|HAAAAA ! | 6| 978|GAAAAA ! | 5| 541|FAAAAA ! | 4| 833|EAAAAA ! | 3| 431|DAAAAA ! | 2| 326|CAAAAA ! | 1| 214|BAAAAA ! | 0| 998|AAAAAA ! (11 rows) QUERY: SELECT ''::text AS ten, unique1, unique2, stringu1 FROM onek ORDER BY unique1 OFFSET 990; ten|unique1|unique2|stringu1 ---+-------+-------+-------- ! | 990| 369|CMAAAA ! | 991| 426|DMAAAA ! | 992| 363|EMAAAA ! | 993| 661|FMAAAA ! | 994| 695|GMAAAA ! | 995| 144|HMAAAA ! | 996| 258|IMAAAA ! | 997| 21|JMAAAA ! | 998| 549|KMAAAA ! | 999| 152|LMAAAA ! (10 rows) QUERY: SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek ORDER BY unique1 OFFSET 990 LIMIT 5; five|unique1|unique2|stringu1 ----+-------+-------+-------- ! | 990| 369|CMAAAA ! | 991| 426|DMAAAA ! | 992| 363|EMAAAA ! | 993| 661|FMAAAA ! | 994| 695|GMAAAA ! (5 rows) QUERY: SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek ORDER BY unique1 LIMIT 5, 900; five|unique1|unique2|stringu1 ----+-------+-------+-------- ! | 900| 913|QIAAAA ! | 901| 931|RIAAAA ! | 902| 702|SIAAAA ! | 903| 641|TIAAAA ! | 904| 793|UIAAAA ! (5 rows) --- 38,63 ---- ORDER BY unique1 DESC LIMIT 20 OFFSET 39; eleven|unique1|unique2|stringu1 ------+-------+-------+-------- ! (0 rows) QUERY: SELECT ''::text AS ten, unique1, unique2, stringu1 FROM onek ORDER BY unique1 OFFSET 990; ten|unique1|unique2|stringu1 ---+-------+-------+-------- ! (0 rows) QUERY: SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek ORDER BY unique1 OFFSET 990 LIMIT 5; five|unique1|unique2|stringu1 ----+-------+-------+-------- ! (0 rows) QUERY: SELECT ''::text AS five, unique1, unique2, stringu1 FROM onek ORDER BY unique1 LIMIT 5, 900; five|unique1|unique2|stringu1 ----+-------+-------+-------- ! (0 rows) ----------------------
pgsql-ports by date: