Skip to content

Commit 9a90b42

Browse files
author
Vladlen Popolitov
committed
README.md updated with usage examples
1 parent 1b9806a commit 9a90b42

File tree

1 file changed

+3
-25
lines changed

1 file changed

+3
-25
lines changed

‎README.md

Lines changed: 3 additions & 25 deletions
Original file line numberDiff line numberDiff line change
@@ -153,12 +153,6 @@ CREATE INDEX idx_test_int4 ON test_int4 USING gist (v _int4_aa_ops);
153153

154154
SET enable_seqscan=off;
155155

156-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v && '{43,50}' ORDER BY t;
157-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v @> '{43,50}' ORDER BY t;
158-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v <@ '{0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
159-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v = '{0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
160-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v % '{0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
161-
162156
SELECT t, v FROM test_int4 WHERE v && '{43,50}' ORDER BY t;
163157
SELECT t, v FROM test_int4 WHERE v @> '{43,50}' ORDER BY t;
164158
SELECT t, v FROM test_int4 WHERE 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

183177
SET enable_seqscan=off;
184178

185-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v && '{43,50}' ORDER BY t;
186-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v @> '{43,50}' ORDER BY t;
187-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v <@ '{0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
188-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v = '{0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
189-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v % '{0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
190-
191179
SELECT t, v FROM test_int4 WHERE v && '{43,50}' ORDER BY t;
192180
SELECT t, v FROM test_int4 WHERE v @> '{43,50}' ORDER BY t;
193181
SELECT t, v FROM test_int4 WHERE 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

210198
SET enable_seqscan=off;
211199

212-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v && '{43,50}' ORDER BY t;
213-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v @> '{43,50}' ORDER BY t;
214-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v <@ '{0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
215-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v = '{0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
216-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v % '{0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
217-
218200
SELECT t, v FROM test_int4 WHERE v && '{43,50}' ORDER BY t;
219201
SELECT t, v FROM test_int4 WHERE v @> '{43,50}' ORDER BY t;
220202
SELECT t, v FROM test_int4 WHERE 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

272254
SET enable_seqscan=off;
273255

274-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v && '{43,50}' ORDER BY t;
275-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v @> '{43,50}' ORDER BY t;
276-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v <@ '{0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
277-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v = '{0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
278-
EXPLAIN (COSTS OFF) SELECT t, v FROM test_int4 WHERE v % '{0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
279-
280256
SELECT t, v FROM test_int4 WHERE v && '{43,50}' ORDER BY t;
281257
SELECT t, v FROM test_int4 WHERE v @> '{43,50}' ORDER BY t;
282258
SELECT t, v FROM test_int4 WHERE v <@ '{0,1,2,3,4,5,6,7,8,9,10}' ORDER BY t;
@@ -304,13 +280,15 @@ WITH q as (
304280
SELECT row_number() OVER (ORDER BY i) idx, ctid FROM test_array
305281
)
306282
UPDATE test_array SET add_info = '2016-05-16 14:21:25'::timestamp +
307-
format('%s days', q.idx)::interval
283+
format('%s days', q.idx)::interval
308284
FROM q WHERE test_array.ctid = q.ctid;
309285

310286
CREATE INDEX idx_array ON test_array
311287
USING rum (i aa_rum_anyarray_addon_ops, add_info)
312288
WITH (attach = 'add_info', to = 'i');
313289

290+
SET enable_seqscan=off;
291+
314292
SELECT * FROM test_array WHERE i && '{1}' ORDER BY add_info <=> '2016-05-16 14:21:25' LIMIT 10;
315293
```
316294

0 commit comments

Comments
 (0)