@@ -153,12 +153,6 @@ CREATE INDEX idx_test_int4 ON test_int4 USING gist (v _int4_aa_ops);
153153
154154SET enable_seqscan= off;
155155
156- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v &&' {43,50}' ORDER BY t;
157- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v @> ' {43,50}' ORDER BY t;
158- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v< @' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
159- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v= ' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
160- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v %' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
161-
162156SELECT t, vFROM test_int4WHERE v &&' {43,50}' ORDER BY t;
163157SELECT t, vFROM test_int4WHERE v @> ' {43,50}' ORDER BY t;
164158SELECT t, vFROM test_int4WHERE v< @' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
@@ -182,12 +176,6 @@ CREATE INDEX idx_test_int4 ON test_int4 USING gin (v _int4_aa_ops);
182176
183177SET enable_seqscan= off;
184178
185- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v &&' {43,50}' ORDER BY t;
186- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v @> ' {43,50}' ORDER BY t;
187- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v< @' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
188- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v= ' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
189- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v %' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
190-
191179SELECT t, vFROM test_int4WHERE v &&' {43,50}' ORDER BY t;
192180SELECT t, vFROM test_int4WHERE v @> ' {43,50}' ORDER BY t;
193181SELECT t, vFROM test_int4WHERE v< @' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
@@ -209,12 +197,6 @@ CREATE INDEX idx_test_int4 ON test_int4 USING rum (v _int4_aa_ops);
209197
210198SET enable_seqscan= off;
211199
212- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v &&' {43,50}' ORDER BY t;
213- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v @> ' {43,50}' ORDER BY t;
214- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v< @' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
215- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v= ' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
216- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v %' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
217-
218200SELECT t, vFROM test_int4WHERE v &&' {43,50}' ORDER BY t;
219201SELECT t, vFROM test_int4WHERE v @> ' {43,50}' ORDER BY t;
220202SELECT t, vFROM test_int4WHERE v< @' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
@@ -271,12 +253,6 @@ CREATE INDEX idx_test_int4 ON test_int4 USING rum (v aa_rum_anyarray_ops);
271253
272254SET enable_seqscan= off;
273255
274- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v &&' {43,50}' ORDER BY t;
275- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v @> ' {43,50}' ORDER BY t;
276- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v< @' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
277- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v= ' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
278- EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v %' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
279-
280256SELECT t, vFROM test_int4WHERE v &&' {43,50}' ORDER BY t;
281257SELECT t, vFROM test_int4WHERE v @> ' {43,50}' ORDER BY t;
282258SELECT t, vFROM test_int4WHERE v< @' {0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
@@ -304,13 +280,15 @@ WITH q as (
304280SELECT row_number() OVER (ORDER BY i) idx, ctidFROM test_array
305281)
306282UPDATE test_arraySET add_info= ' 2016-05-16 14:21:25' timestamp +
307- ' %s days' q .idx )::interval
283+ format(' %s days' q .idx )::interval
308284FROM qWHERE test_array .ctid = q .ctid ;
309285
310286CREATE INDEX idx_array ON test_array
311287USING rum (i aa_rum_anyarray_addon_ops, add_info)
312288WITH (attach= ' add_info' = ' i'
313289
290+ SET enable_seqscan= off;
291+
314292SELECT * FROM test_arrayWHERE i &&' {1}' ORDER BY add_info<=> ' 2016-05-16 14:21:25' LIMIT 10 ;
315293```
316294
