Well-behaved ranges

A “well-behaved” range has the following characteristics:

Beginning with the leftmost key segment and working to the right, the first 0 to n segments are set to equal values for both the range start and the range end.
The next 0 or 1 segments are set to non-equal values for the range start and range end.
The remaining segments (if any) are cleared for the range start and filled for the range end.

It is desirable for a range to be “well-behaved” because “well-behaved” ranges produce the same results for all database managers.

The scripts in the first and second examples of this section both create “well-behaved” ranges. The ranges produced will be the same, regardless of the database manager being used.

Well-behaved ranges

Documentation Feedback try { var yaCounter1293845 = new Ya.Metrika(1293845); } catch(e){} <div style="position:absolute"><img src="//mc.yandex.ru/watch/1293845" alt="" /></div>

Documentation Feedback