The pg_range_ops extension adds support to Sequel's DSL to make it easier to call PostgreSQL range functions and operators.
To load the extension:
The most common usage is passing an expression to Sequel.pg_range_op:
r = Sequel.pg_range_op(:range)
If you have also loaded the pg_range extension, you can use Sequel.pg_range as well:
r = Sequel.pg_range(:range)
Also, on most Sequel expression objects, you can call the pg_range method:
r = Sequel[:range].pg_range
If you have loaded the core_extensions extension, or you have loaded the core_refinements extension and have activated refinements for the file, you can also use Sequel::Postgres::RangeOpMethods#pg_range:
r = :range.pg_range
This creates a Sequel::Postgres::RangeOp object that can be used for easier querying:
r.contains(:other) # range @> other r.contained_by(:other) # range <@ other r.overlaps(:other) # range && other r.left_of(:other) # range << other r.right_of(:other) # range >> other r.starts_after(:other) # range &> other r.ends_before(:other) # range &< other r.adjacent_to(:other) # range -|- other r.lower # lower(range) r.upper # upper(range) r.isempty # isempty(range) r.lower_inc # lower_inc(range) r.upper_inc # upper_inc(range) r.lower_inf # lower_inf(range) r.upper_inf # upper_inf(range)
See the PostgreSQL range function and operator documentation for more details on what these functions and operators do.
If you are also using the pg_range extension, you should load it before loading this extension. Doing so will allow you to use PGArray#op to get an RangeOp, allowing you to perform range operations on range literals.
Related module: Sequel::Postgres::RangeOp