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) -> Self

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<'de> Deserialize<'de> for FunctionArgumentClause

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

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: &Self) -> 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: &Self) -> bool

Equality operator ==.

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

Inequality operator !=.

impl PartialOrd for FunctionArgumentClause

fn partial_cmp(&self, other: &Self) -> 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 Serialize for FunctionArgumentClause

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

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

impl Visit for FunctionArgumentClause

fn visit<V: Visitor>(&self, visitor: &mut V) -> ControlFlow<V::Break>

Visit this node with the provided Visitor.

impl VisitMut for FunctionArgumentClause

fn visit<V: VisitorMut>(&mut self, visitor: &mut V) -> ControlFlow<V::Break>

Mutably visit this node with the provided VisitorMut.