# Db::key_range

`

###

    #include <db_cxx.h>

    int
    Db::key_range(DbTxn *txnid
    	Dbt *key, DB_KEY_RANGE *key_range, u_int32_t flags);

# Description

The Db::key_range method returns an estimate of the proportion of keys that are less than, equal to and greater than the specified key. The underlying database must be of type Btree.

The information is returned in the key_range argument, which contains three elements of type double, less, equal and greater. Values are in the range of 0 to 1, e.g., if the field less is 0.05, that indicates that 5% of the keys in the database are less than the key argument. The value for equal will be zero if there is no matching key and non-zero otherwise.

If the file is being accessed under transaction protection, the txnid parameter is a transaction ID returned from DbEnv::txn_begin, otherwise, NULL. The Db::key_range method does not retain the locks it acquires for the life of the transaction, so estimates may not be repeatable.

The flags parameter is currently unused, and must be set to 0.

The Db::key_range method either returns a non-zero error value or throws an exception that encapsulates a non-zero error value on failure, and returns 0 on success.

# Errors

The Db::key_range method may fail and throw an exception or return a non-zero error for the following conditions:

DB_LOCK_DEADLOCK
  The operation was selected to resolve a deadlock.

EINVAL
  An invalid flag value or parameter was specified.

  The underlying database was not of type Btree.

The Db::key_range method may fail and throw an exception or return a non-zero error for errors specified for other Berkeley DB and C library or system methods. If a catastrophic error has occurred, the Db::key_range method may fail and either return DB_RUNRECOVERY or throw an exception encapsulating DB_RUNRECOVERY, in which case all subsequent Berkeley DB calls will fail in the same way.

### Class

Db

# See Also

Db::close, Db::cursor, Db::del, Db::err, Db::fd, Db::get, Db::get_byteswapped, Db::get_type, Db::join, Db::key_range, Db::open, Db::put, Db::remove, Db::set_bt_compare, Db::set_bt_minkey, Db::set_bt_prefix, Db::set_cachesize, Db::set_dup_compare, Db::set_errcall, Db::set_errfile, Db::set_errpfx, Db::set_flags, Db::set_h_ffactor, Db::set_h_hash, Db::set_h_nelem, Db::set_lorder, Db::set_malloc, Db::set_pagesize, Db::set_paniccall, Db::set_q_extentsize, Db::set_realloc, Db::set_re_delim, Db::set_re_len, Db::set_re_pad, Db::set_re_source, Db::stat, Db::sync, Db::upgrade and Db::verify.`

Copyright Sleepycat Software