*** /home/pavel/src/postgresql/src/test/regress/expected/create_index.out 2011-12-27 15:44:37.182133008 +0100 --- /home/pavel/src/postgresql/src/test/regress/results/create_index.out 2011-12-29 13:24:06.335065038 +0100 *************** *** 290,296 **** SELECT count(*) FROM suffix_text_tbl WHERE t < 'Aztec Ct '; count ------- ! 1705 (1 row) SELECT count(*) FROM suffix_text_tbl WHERE t ~<~ 'Aztec Ct '; --- 290,296 ---- SELECT count(*) FROM suffix_text_tbl WHERE t < 'Aztec Ct '; count ------- ! 272 (1 row) SELECT count(*) FROM suffix_text_tbl WHERE t ~<~ 'Aztec Ct '; *************** *** 302,308 **** SELECT count(*) FROM suffix_text_tbl WHERE t <= 'Aztec Ct '; count ------- ! 1706 (1 row) SELECT count(*) FROM suffix_text_tbl WHERE t ~<=~ 'Aztec Ct '; --- 302,308 ---- SELECT count(*) FROM suffix_text_tbl WHERE t <= 'Aztec Ct '; count ------- ! 273 (1 row) SELECT count(*) FROM suffix_text_tbl WHERE t ~<=~ 'Aztec Ct '; *************** *** 326,332 **** SELECT count(*) FROM suffix_text_tbl WHERE t >= 'Worth St '; count ------- ! 50 (1 row) SELECT count(*) FROM suffix_text_tbl WHERE t ~>=~ 'Worth St '; --- 326,332 ---- SELECT count(*) FROM suffix_text_tbl WHERE t >= 'Worth St '; count ------- ! 1483 (1 row) SELECT count(*) FROM suffix_text_tbl WHERE t ~>=~ 'Worth St '; *************** *** 338,344 **** SELECT count(*) FROM suffix_text_tbl WHERE t > 'Worth St '; count ------- ! 48 (1 row) SELECT count(*) FROM suffix_text_tbl WHERE t ~>~ 'Worth St '; --- 338,344 ---- SELECT count(*) FROM suffix_text_tbl WHERE t > 'Worth St '; count ------- ! 1481 (1 row) SELECT count(*) FROM suffix_text_tbl WHERE t ~>~ 'Worth St '; *************** *** 945,951 **** SELECT count(*) FROM suffix_text_tbl WHERE t < 'Aztec Ct '; count ------- ! 1705 (1 row) EXPLAIN (COSTS OFF) --- 945,951 ---- SELECT count(*) FROM suffix_text_tbl WHERE t < 'Aztec Ct '; count ------- ! 272 (1 row) EXPLAIN (COSTS OFF) *************** *** 975,981 **** SELECT count(*) FROM suffix_text_tbl WHERE t <= 'Aztec Ct '; count ------- ! 1706 (1 row) EXPLAIN (COSTS OFF) --- 975,981 ---- SELECT count(*) FROM suffix_text_tbl WHERE t <= 'Aztec Ct '; count ------- ! 273 (1 row) EXPLAIN (COSTS OFF) *************** *** 1035,1041 **** SELECT count(*) FROM suffix_text_tbl WHERE t >= 'Worth St '; count ------- ! 50 (1 row) EXPLAIN (COSTS OFF) --- 1035,1041 ---- SELECT count(*) FROM suffix_text_tbl WHERE t >= 'Worth St '; count ------- ! 1483 (1 row) EXPLAIN (COSTS OFF) *************** *** 1065,1071 **** SELECT count(*) FROM suffix_text_tbl WHERE t > 'Worth St '; count ------- ! 48 (1 row) EXPLAIN (COSTS OFF) --- 1065,1071 ---- SELECT count(*) FROM suffix_text_tbl WHERE t > 'Worth St '; count ------- ! 1481 (1 row) EXPLAIN (COSTS OFF) *************** *** 1411,1417 **** SELECT count(*) FROM suffix_text_tbl WHERE t < 'Aztec Ct '; count ------- ! 1705 (1 row) EXPLAIN (COSTS OFF) --- 1411,1417 ---- SELECT count(*) FROM suffix_text_tbl WHERE t < 'Aztec Ct '; count ------- ! 272 (1 row) EXPLAIN (COSTS OFF) *************** *** 1445,1451 **** SELECT count(*) FROM suffix_text_tbl WHERE t <= 'Aztec Ct '; count ------- ! 1706 (1 row) EXPLAIN (COSTS OFF) --- 1445,1451 ---- SELECT count(*) FROM suffix_text_tbl WHERE t <= 'Aztec Ct '; count ------- ! 273 (1 row) EXPLAIN (COSTS OFF) *************** *** 1513,1519 **** SELECT count(*) FROM suffix_text_tbl WHERE t >= 'Worth St '; count ------- ! 50 (1 row) EXPLAIN (COSTS OFF) --- 1513,1519 ---- SELECT count(*) FROM suffix_text_tbl WHERE t >= 'Worth St '; count ------- ! 1483 (1 row) EXPLAIN (COSTS OFF) *************** *** 1547,1553 **** SELECT count(*) FROM suffix_text_tbl WHERE t > 'Worth St '; count ------- ! 48 (1 row) EXPLAIN (COSTS OFF) --- 1547,1553 ---- SELECT count(*) FROM suffix_text_tbl WHERE t > 'Worth St '; count ------- ! 1481 (1 row) EXPLAIN (COSTS OFF) ======================================================================