I would like to know if the couchbase dev team has recommendations to allow the primary key to handle a range query
For each document, I have a low and high numeric range value. I would like to create an index to allow me to find those documents that have a low and high value that are in the range of a given single query value.
I have seen the availability of spatial indexes. But the logic is a bit different, they deem the 2 points as latitude and longitude and then you provide a bounding box to see if document lat/long are inside the box.
Anybody have ideas on how to find the documents that have both a low and high value that include a given search value.