FrameBoundary.range constructor

const FrameBoundary.range({
  1. num? start,
  2. num? end = 0,
  3. FrameExclude? exclude,
})

Constructs a RANGE boundary with the given start and end.

A RANGE frame operates on logical ranges of values based on the ORDER BY columns. The start and end parameter specifies the range of values to include relative to the current row's values.

If multiple rows have the same value in the ORDER BY column, they are all included in the frame.

If null, the boundary is unbounded.

Negative value indicates a preceding boundary

Positive value indicates a following boundary

Zero indicates the current row

Note that passing value except 0 (CURRENT ROW) or null (UNBOUNDED) to start or end in RANGE Frame is only available from sqlite 3.28.0, released on 2019-04-16. Most devices will use an older sqlite version.

0 (CURRENT ROW) and null (UNBOUNDED) are supported from sqlite 3.25.0, released on 2018-09-15.

Implementation

const FrameBoundary.range({
  num? start,
  num? end = 0,
  FrameExclude? exclude,
}) : this._(start, end, _FrameType.range, exclude: exclude);