| 1 | |
| 2 | <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"> |
| 3 | <html> |
| 4 | <head> |
| 5 | <link type="text/css" rel="stylesheet" href="style.css" /> |
| 6 | </head> |
| 7 | <body> |
| 8 | <div id="page"> |
| 9 | |
| 10 | <div id='header'> |
| 11 | <a href="index.html"> |
| 12 | <img style="border:none" alt="Redis Documentation" src="redis.png"> |
| 13 | </a> |
| 14 | </div> |
| 15 | |
| 16 | <div id="pagecontent"> |
| 17 | <div class="index"> |
| 18 | <!-- This is a (PRE) block. Make sure it's left aligned or your toc title will be off. --> |
| 19 | <b>ZrangebyscoreCommand: Contents</b><br> <a href="#ZRANGEBYSCORE _key_ _min_ _max_ `[`LIMIT _offset_ _count_`]` (Redis >">ZRANGEBYSCORE _key_ _min_ _max_ `[`LIMIT _offset_ _count_`]` (Redis ></a><br> <a href="#ZRANGEBYSCORE _key_ _min_ _max_ `[`LIMIT _offset_ _count_`]` `[`WITHSCORES`]` (Redis >">ZRANGEBYSCORE _key_ _min_ _max_ `[`LIMIT _offset_ _count_`]` `[`WITHSCORES`]` (Redis ></a><br> <a href="#Exclusive intervals and infinity">Exclusive intervals and infinity</a><br> <a href="#Return value">Return value</a><br> <a href="#Examples">Examples</a> |
| 20 | </div> |
| 21 | |
| 22 | <h1 class="wikiname">ZrangebyscoreCommand</h1> |
| 23 | |
| 24 | <div class="summary"> |
| 25 | |
| 26 | </div> |
| 27 | |
| 28 | <div class="narrow"> |
| 29 | #sidebar <a href="SortedSetCommandsSidebar.html">SortedSetCommandsSidebar</a><h1><a name="ZRANGEBYSCORE _key_ _min_ _max_ `[`LIMIT _offset_ _count_`]` (Redis >">ZRANGEBYSCORE _key_ _min_ _max_ `[`LIMIT _offset_ _count_`]` (Redis ></a></h1> 1.1) = |
| 30 | <h1><a name="ZRANGEBYSCORE _key_ _min_ _max_ `[`LIMIT _offset_ _count_`]` `[`WITHSCORES`]` (Redis >">ZRANGEBYSCORE _key_ _min_ _max_ `[`LIMIT _offset_ _count_`]` `[`WITHSCORES`]` (Redis ></a></h1> 1.3.4) = |
| 31 | <i>Time complexity: O(log(N))+O(M) with N being the number of elements in the sorted set and M the number of elements returned by the command, so if M is constant (for instance you always ask for the first ten elements with LIMIT) you can consider it O(log(N))</i><blockquote>Return the all the elements in the sorted set at key with a score between_min_ and <i>max</i> (including elements with score equal to min or max).</blockquote> |
| 32 | <blockquote>The elements having the same score are returned sorted lexicographically asASCII strings (this follows from a property of Redis sorted sets and does notinvolve further computation).</blockquote> |
| 33 | <blockquote>Using the optional LIMIT it's possible to get only a range of the matchingelements in an SQL-alike way. Note that if <i>offset</i> is large the commandsneeds to traverse the list for <i>offset</i> elements and this adds up to theO(M) figure.</blockquote><h2><a name="Exclusive intervals and infinity">Exclusive intervals and infinity</a></h2> |
| 34 | <i>min</i> and <i>max</i> can be -inf and +inf, so that you are not required to know what's the greatest or smallest element in order to take, for instance, elements "up to a given value".<br/><br/>Also while the interval is for default closed (inclusive) it's possible to specify open intervals prefixing the score with a "(" character, so for instance: |
| 35 | <pre class="codeblock python" name="code"> |
| 36 | ZRANGEBYSCORE zset (1.3 5 |
| 37 | </pre> |
| 38 | Will return all the values with score <b>> 1.3 and <= 5</b>, while for instance: |
| 39 | <pre class="codeblock python python" name="code"> |
| 40 | ZRANGEBYSCORE zset (5 (10 |
| 41 | </pre> |
| 42 | Will return all the values with score <b>> 5 and < 10</b> (5 and 10 excluded). |
| 43 | <h2><a name="Return value">Return value</a></h2><a href="ReplyTypes.html">Multi bulk reply</a>, specifically a list of elements in the specified score range. |
| 44 | <h2><a name="Examples">Examples</a></h2> |
| 45 | <pre class="codeblock python python python" name="code"> |
| 46 | redis> zadd zset 1 foo |
| 47 | (integer) 1 |
| 48 | redis> zadd zset 2 bar |
| 49 | (integer) 1 |
| 50 | redis> zadd zset 3 biz |
| 51 | (integer) 1 |
| 52 | redis> zadd zset 4 foz |
| 53 | (integer) 1 |
| 54 | redis> zrangebyscore zset -inf +inf |
| 55 | 1. "foo" |
| 56 | 2. "bar" |
| 57 | 3. "biz" |
| 58 | 4. "foz" |
| 59 | redis> zrangebyscore zset 1 2 |
| 60 | 1. "foo" |
| 61 | 2. "bar" |
| 62 | redis> zrangebyscore zset (1 2 |
| 63 | 1. "bar" |
| 64 | redis> zrangebyscore zset (1 (2 |
| 65 | (empty list or set) |
| 66 | </pre> |
| 67 | </div> |
| 68 | |
| 69 | </div> |
| 70 | </div> |
| 71 | </body> |
| 72 | </html> |
| 73 | |