Enum FunctionArgumentClause 

pub enum FunctionArgumentClause {
    IgnoreOrRespectNulls(NullTreatment),
    Where(Expr),
    OrderBy(Vec<OrderByExpr>),
    Limit(Expr),
    OnOverflow(ListAggOnOverflow),
    Having(HavingBound),
    Separator(ValueWithSpan),
    JsonNullClause(JsonNullClause),
    JsonReturningClause(JsonReturningClause),
}

Clauses that can appear inside a function argument list.

Variants

IgnoreOrRespectNulls(NullTreatment)

Indicates how NULLs should be handled in the calculation, e.g. in FIRST_VALUE on BigQuery.

Syntax:

{ IGNORE | RESPECT } NULLS ]

Where(Expr)

The inline WHERE filter clause on an aggregate call, e.g. COUNT(* WHERE cond) / SUM(x WHERE cond) / ARRAY_AGG(x WHERE cond ORDER BY ..). Popularized by GoogleSQL; equivalent to the standard AGG(x) FILTER (WHERE cond). Accepted for all dialects since WHERE cannot otherwise begin a function argument.

OrderBy(Vec<OrderByExpr>)

Specifies the the ordering for some ordered set aggregates, e.g. ARRAY_AGG on BigQuery.

Limit(Expr)

Specifies a limit for the ARRAY_AGG and ARRAY_CONCAT_AGG functions on BigQuery.

OnOverflow(ListAggOnOverflow)

Specifies the behavior on overflow of the LISTAGG function.

See https://trino.io/docs/current/functions/aggregate.html.

Having(HavingBound)

Specifies a minimum or maximum bound on the input to ANY_VALUE on BigQuery.

Syntax:

HAVING { MAX | MIN } expression

Separator(ValueWithSpan)

The SEPARATOR clause to the GROUP_CONCAT function in MySQL.

JsonNullClause(JsonNullClause)

The ON NULL clause for some JSON functions.

MSSQL JSON_ARRAY MSSQL JSON_OBJECT PostgreSQL JSON functions

JsonReturningClause(JsonReturningClause)

The RETURNING clause for some JSON functions in PostgreSQL

JSON_OBJECT

Trait Implementations

impl Clone for FunctionArgumentClause

fn clone(&self) -> FunctionArgumentClause

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for FunctionArgumentClause

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

Formats the value using the given formatter.

impl Display for FunctionArgumentClause

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

Formats the value using the given formatter.

impl Eq for FunctionArgumentClause

impl Hash for FunctionArgumentClause

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for FunctionArgumentClause

fn cmp(&self, other: &FunctionArgumentClause) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

fn clamp_to<R>(self, range: R) -> Self

where Self: Sized, R: ClampBounds<Self>,

🔬This is a nightly-only experimental API. (clamp_to)

Restrict a value to a certain range.

impl PartialEq for FunctionArgumentClause

fn eq(&self, other: &FunctionArgumentClause) -> bool

Equality operator ==.

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=.

impl PartialOrd for FunctionArgumentClause

fn partial_cmp(&self, other: &FunctionArgumentClause) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

fn lt(&self, other: &Rhs) -> bool

Tests less than (for self and other) and is used by the < operator.

fn le(&self, other: &Rhs) -> bool

Tests less than or equal to (for self and other) and is used by the <= operator.

fn gt(&self, other: &Rhs) -> bool

Tests greater than (for self and other) and is used by the > operator.

fn ge(&self, other: &Rhs) -> bool

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Spanned for FunctionArgumentClause

fn span(&self) -> Span

Return the Span (the minimum and maximum Location) for this AST node, by recursively combining the spans of its children.

impl StructuralPartialEq for FunctionArgumentClause