diff options
| author | Teodor Sigaev <teodor@sigaev.ru> | 2006-07-11 19:49:14 +0000 |
|---|---|---|
| committer | Teodor Sigaev <teodor@sigaev.ru> | 2006-07-11 19:49:14 +0000 |
| commit | 001d30ee6b34308f72790c698bc7f43afffab286 (patch) | |
| tree | bc70114c53b12826ac7a29ad7c8e82b443fb1f47 /src/test/regress/expected | |
| parent | 6d57ed7797dcdc4021cc53eae27b8d8ce1bd5fed (diff) | |
| download | postgresql-001d30ee6b34308f72790c698bc7f43afffab286.tar.gz | |
Add support to GIN for =(anyarray,anyarray) operation
Diffstat (limited to 'src/test/regress/expected')
| -rw-r--r-- | src/test/regress/expected/create_index.out | 12 | ||||
| -rw-r--r-- | src/test/regress/expected/opr_sanity.out | 3 |
2 files changed, 14 insertions, 1 deletions
diff --git a/src/test/regress/expected/create_index.out b/src/test/regress/expected/create_index.out index a07dc64a65..715462e3d5 100644 --- a/src/test/regress/expected/create_index.out +++ b/src/test/regress/expected/create_index.out @@ -244,6 +244,12 @@ SELECT * FROM array_index_op_test WHERE i ~ '{38,34,32,89}' ORDER BY seqno; 98 | {38,34,32,89} | {AAAAAAAAAAAAAAAAAA71621,AAAA8857,AAAAAAAAAAAAAAAAAAA65037,AAAAAAAAAAAAAAAA31334,AAAAAAAAAA48845} (3 rows) +SELECT * FROM array_index_op_test WHERE i = '{47,77}' ORDER BY seqno; + seqno | i | t +-------+---------+----------------------------------------------------------------------------------------------------------------- + 95 | {47,77} | {AAAAAAAAAAAAAAAAA764,AAAAAAAAAAA74076,AAAAAAAAAA18107,AAAAA40681,AAAAAAAAAAAAAAA35875,AAAAA60038,AAAAAAA56483} +(1 row) + CREATE INDEX textarrayidx ON array_index_op_test USING gin (t); SELECT * FROM array_index_op_test WHERE t @ '{AAAAAAAA72908}' ORDER BY seqno; seqno | i | t @@ -303,6 +309,12 @@ SELECT * FROM array_index_op_test WHERE t ~ '{AAAAAAAA72908,AAAAAAAAAAAAAAAAAAA1 45 | {99,45} | {AAAAAAAA72908,AAAAAAAAAAAAAAAAAAA17075,AA88409,AAAAAAAAAAAAAAAAAA36842,AAAAAAA48038,AAAAAAAAAAAAAA10611} (2 rows) +SELECT * FROM array_index_op_test WHERE t = '{AAAAAAAAAA646,A87088}' ORDER BY seqno; + seqno | i | t +-------+------------+------------------------ + 96 | {23,97,43} | {AAAAAAAAAA646,A87088} +(1 row) + RESET enable_seqscan; RESET enable_indexscan; RESET enable_bitmapscan; diff --git a/src/test/regress/expected/opr_sanity.out b/src/test/regress/expected/opr_sanity.out index 329905fb4d..1161d0474c 100644 --- a/src/test/regress/expected/opr_sanity.out +++ b/src/test/regress/expected/opr_sanity.out @@ -833,7 +833,8 @@ ORDER BY 1, 2, 3; 2742 | 1 | && 2742 | 2 | @ 2742 | 3 | ~ -(27 rows) + 2742 | 4 | = +(28 rows) -- Check that all operators linked to by opclass entries have selectivity -- estimators. This is not absolutely required, but it seems a reasonable |