Struct GroupBy 

pub struct GroupBy {
    pub groups: Vec<Expr>,
    pub distinct: bool,
    pub with: Option<GroupByWith>,
}

GROUP BY [DISTINCT] a, b [WITH ROLLUP]

GROUP BY [ ALL | DISTINCT ] grouping_element [, ...]      -- PostgreSQL 17
GROUP BY expr [, ...] [WITH ROLLUP]                       -- MySQL 8.4

ALL is the default and writing it adds nothing, so only DISTINCT is representable.

Fields

groups: Vec<Expr>

The grouping elements. A GroupingSet is one of these.

distinct: bool

PostgreSQL’s GROUP BY DISTINCT, which de-duplicates the grouping sets a CUBE or ROLLUP expands to.

with: Option<GroupByWith>

MySQL’s WITH ROLLUP.

Implementations

impl GroupBy

pub fn set_groups(&mut self, groups: impl IntoExprList)

Replace the grouping elements.

pub fn append_group(&mut self, group: impl IntoExpr)

Append one grouping element.

pub fn is_empty(&self) -> bool

Whether the clause is absent.

Trait Implementations

impl Clone for GroupBy

fn clone(&self) -> GroupBy

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for GroupBy

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for GroupBy

fn default() -> GroupBy

Returns the “default value” for a type.

impl Expression for GroupBy

fn write_sql(&self, w: &mut SqlWriter<'_>)

Append this fragment to w.

impl HasGroupBy for GroupBy

fn group_by_mut(&mut self) -> &mut GroupBy

The GROUP BY clause to modify.