Enum CreateFunctionBody 

pub enum CreateFunctionBody {
    AsBeforeOptions(Expr),
    AsAfterOptions(Expr),
    AsBeginEnd(BeginEndStatements),
    Return(Expr),
    AsReturnExpr(Expr),
    AsReturnSelect(Select),
}

Represent the expression body of a CREATE FUNCTION statement as well as where within the statement, the body shows up.

Variants

AsBeforeOptions(Expr)

A function body expression using the ‘AS’ keyword and shows up before any OPTIONS clause.

Example:

CREATE FUNCTION myfunc(x FLOAT64, y FLOAT64) RETURNS FLOAT64
AS (x * y)
OPTIONS(description="desc");

AsAfterOptions(Expr)

A function body expression using the ‘AS’ keyword and shows up after any OPTIONS clause.

Example:

CREATE FUNCTION myfunc(x FLOAT64, y FLOAT64) RETURNS FLOAT64
OPTIONS(description="desc")
AS (x * y);

AsBeginEnd(BeginEndStatements)

Function body with statements before the RETURN keyword.

Example:

CREATE FUNCTION my_scalar_udf(a INT, b INT)
RETURNS INT
AS
BEGIN
    DECLARE c INT;
    SET c = a + b;
    RETURN c;
END

Return(Expr)

Function body expression using the ‘RETURN’ keyword.

Example:

CREATE FUNCTION myfunc(a INTEGER, IN b INTEGER = 1) RETURNS INTEGER
LANGUAGE SQL
RETURN a + b;

AsReturnExpr(Expr)

Function body expression using the ‘AS RETURN’ keywords

Example:

CREATE FUNCTION myfunc(a INT, b INT)
RETURNS TABLE
AS RETURN (SELECT a + b AS sum);

AsReturnSelect(Select)

Function body expression using the ‘AS RETURN’ keywords, with an un-parenthesized SELECT query

Example:

CREATE FUNCTION myfunc(a INT, b INT)
RETURNS TABLE
AS RETURN SELECT a + b AS sum;

Trait Implementations

impl Clone for CreateFunctionBody

fn clone(&self) -> CreateFunctionBody

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for CreateFunctionBody

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

Formats the value using the given formatter.

impl Hash for CreateFunctionBody

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

where __H: Hasher,

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 CreateFunctionBody

fn cmp(&self, other: &CreateFunctionBody) -> 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.

impl PartialEq for CreateFunctionBody

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

Tests for self and other values to be equal, and is used by ==.

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

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl PartialOrd for CreateFunctionBody

fn partial_cmp(&self, other: &CreateFunctionBody) -> 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 Visit for CreateFunctionBody

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

where V: Visitor,

impl VisitMut for CreateFunctionBody

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

where V: VisitorMut,

impl Eq for CreateFunctionBody

impl StructuralPartialEq for CreateFunctionBody