Interface QOM.RegrAvgX

All Superinterfaces:

AggregateFilterStep<BigDecimal>, AggregateFunction<BigDecimal>, Field<BigDecimal>, FieldOrConstraint, FieldOrRow, FieldOrRowOrSelect, GroupField, Named, OrderField<BigDecimal>, QOM.AggregateFunction<BigDecimal, QOM.RegrAvgX>, QOM.WindowFunction<BigDecimal, QOM.RegrAvgX>, QueryPart, SelectField<BigDecimal>, SelectFieldOrAsterisk, Serializable, TableElement, Typed<BigDecimal>, WindowBeforeOverStep<BigDecimal>, WindowOverStep<BigDecimal>

Enclosing class:

QOM

public static interface QOM.RegrAvgX
extends QOM.AggregateFunction<BigDecimal, QOM.RegrAvgX>

The REGR AVGX function.

Calculate the average of the independent values (x). This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull Field<? extends Number>	$x()
@NotNull QOM.RegrAvgX	$x(Field<? extends Number> x)
@NotNull Field<? extends Number>	$y()
@NotNull QOM.RegrAvgX	$y(Field<? extends Number> y)

Methods inherited from interface AggregateFilterStep

filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere

Methods inherited from interface AggregateFunction

keepDenseRankFirstOrderBy, keepDenseRankFirstOrderBy, keepDenseRankLastOrderBy, keepDenseRankLastOrderBy

Methods inherited from interface Field

add, add, as, as, as, as, asc, ascii, between, between, between, between, betweenSymmetric, betweenSymmetric, betweenSymmetric, betweenSymmetric, binaryLike, binaryLike, binaryLike, bitAnd, bitAnd, bitLength, bitNand, bitNand, bitNor, bitNor, bitNot, bitOr, bitOr, bitXNor, bitXNor, bitXor, bitXor, cast, cast, cast, changed, charLength, coalesce, coalesce, coerce, coerce, coerce, collate, collate, collate, comment, comment, compare, compare, compare, compare, concat, concat, concat, contains, contains, containsIgnoreCase, containsIgnoreCase, convert, convert, convert, convertFrom, convertFrom, convertTo, convertTo, decode, decode, decode, decode, desc, div, div, divide, divide, endsWith, endsWith, endsWithIgnoreCase, endsWithIgnoreCase, eq, eq, eq, eq, equal, equal, equal, equal, equalIgnoreCase, equalIgnoreCase, equals, field, from, ge, ge, ge, ge, get, getComment, getName, getValue, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, gt, gt, gt, gt, in, in, in, in, in, isDistinctFrom, isDistinctFrom, isDistinctFrom, isDocument, isFalse, isJson, isNotDistinctFrom, isNotDistinctFrom, isNotDistinctFrom, isNotDocument, isNotJson, isNotNull, isNull, isTrue, le, le, le, le, length, lessOrEqual, lessOrEqual, lessOrEqual, lessOrEqual, lessThan, lessThan, lessThan, lessThan, like, like, like, like, like, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeRegex, likeRegex, lower, lpad, lpad, lpad, lpad, lt, lt, lt, lt, ltrim, minus, minus, mod, mod, modulo, modulo, mul, mul, multiply, multiply, ne, ne, ne, ne, neg, notBetween, notBetween, notBetween, notBetween, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBinaryLike, notBinaryLike, notBinaryLike, notContains, notContains, notContainsIgnoreCase, notContainsIgnoreCase, notEqual, notEqual, notEqual, notEqual, notEqualIgnoreCase, notEqualIgnoreCase, notIn, notIn, notIn, notIn, notIn, notLike, notLike, notLike, notLike, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, notSimilarTo, notSimilarTo, notSimilarTo, notSimilarTo, notSimilarTo, nullif, nullif, nullsFirst, nullsLast, nvl, nvl, nvl2, nvl2, octetLength, original, plus, plus, plus, position, position, pow, pow, power, power, rem, rem, repeat, repeat, replace, replace, replace, replace, reset, rpad, rpad, rpad, rpad, rtrim, shl, shl, shr, shr, similarTo, similarTo, similarTo, similarTo, similarTo, sort, sort, sortAsc, sortAsc, sortDefault, sortDesc, sortDesc, startsWith, startsWith, startsWithIgnoreCase, startsWithIgnoreCase, sub, sub, substring, substring, substring, substring, subtract, subtract, times, times, touched, trim, unaryMinus, unaryPlus, upper

Methods inherited from interface Named

$name, getCommentPart, getQualifiedName, getUnqualifiedName

Methods inherited from interface QOM.AggregateFunction

$filterWhere, $filterWhere

Methods inherited from interface QOM.WindowFunction

$windowDefinition, $windowDefinition, $windowName, $windowName, $windowSpecification, $windowSpecification

Methods inherited from interface QueryPart

$replace, $replace, $traverse, $traverse, hashCode, toString

Methods inherited from interface Typed

$dataType, getBinding, getConverter, getDataType, getDataType, getType

Methods inherited from interface WindowOverStep

over, over, over, over, over

Method Details

$y

@NotNull
@NotNull Field<? extends Number> $y()

$x

@NotNull
@NotNull Field<? extends Number> $x()

$y

@CheckReturnValue
@NotNull
@NotNull QOM.RegrAvgX $y(Field<? extends Number> y)

$x

@CheckReturnValue
@NotNull
@NotNull QOM.RegrAvgX $x(Field<? extends Number> x)