Expand description
There are five ways to describe starting and ending frame boundaries:
- UNBOUNDED PRECEDING
PRECEDING - CURRENT ROW
FOLLOWING - UNBOUNDED FOLLOWING
in this implementation we’ll only allow
Variants
Preceding(Option<u64>)
-
UNBOUNDED PRECEDING The frame boundary is the first row in the partition.
-
PRECEDING must be a non-negative constant numeric expression. The boundary is a row that is “units” prior to the current row.
CurrentRow
- The current row.
For RANGE and GROUPS frame types, peers of the current row are also included in the frame, unless specifically excluded by the EXCLUDE clause. This is true regardless of whether CURRENT ROW is used as the starting or ending frame boundary.
Following(Option<u64>)
-
This is the same as “
PRECEDING” except that the boundary is units after the current rather than before the current row. -
UNBOUNDED FOLLOWING The frame boundary is the last row in the partition.
Trait Implementations
sourceimpl Clone for WindowFrameBound
impl Clone for WindowFrameBound
sourcefn clone(&self) -> WindowFrameBound
fn clone(&self) -> WindowFrameBound
1.0.0 · sourcefn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
source
. Read moresourceimpl Debug for WindowFrameBound
impl Debug for WindowFrameBound
sourceimpl Display for WindowFrameBound
impl Display for WindowFrameBound
sourceimpl From<WindowFrameBound> for WindowFrameBound
impl From<WindowFrameBound> for WindowFrameBound
sourcefn from(value: WindowFrameBound) -> Self
fn from(value: WindowFrameBound) -> Self
sourceimpl Hash for WindowFrameBound
impl Hash for WindowFrameBound
sourceimpl Ord for WindowFrameBound
impl Ord for WindowFrameBound
1.21.0 · sourcefn max(self, other: Self) -> Self
fn max(self, other: Self) -> Self
1.21.0 · sourcefn min(self, other: Self) -> Self
fn min(self, other: Self) -> Self
1.50.0 · sourcefn clamp(self, min: Self, max: Self) -> Selfwhere
Self: PartialOrd<Self>,
fn clamp(self, min: Self, max: Self) -> Selfwhere
Self: PartialOrd<Self>,
sourceimpl PartialEq<WindowFrameBound> for WindowFrameBound
impl PartialEq<WindowFrameBound> for WindowFrameBound
sourceimpl PartialOrd<WindowFrameBound> for WindowFrameBound
impl PartialOrd<WindowFrameBound> for WindowFrameBound
sourcefn partial_cmp(&self, other: &Self) -> Option<Ordering>
fn partial_cmp(&self, other: &Self) -> Option<Ordering>
1.0.0 · sourcefn le(&self, other: &Rhs) -> bool
fn le(&self, other: &Rhs) -> bool
self
and other
) and is used by the <=
operator. Read more