Package nz.co.gregs.dbvolution.results

Interface RangeResult<T>

Type Parameters:

T - a base type that has a commonly understood linear distribution like Number, String, or Date

All Superinterfaces:

AnyResult<T>, DBExpression, EqualResult<T>, ExpressionCanHaveNullValues, HasSQLString, InResult<T>, NullCapableResult<T>

All Known Subinterfaces:

DateRepeatResult, DateResult, DurationResult, InstantResult, IntegerResult, LocalDateResult, LocalDateTimeResult, NumberResult, RangeComparable<B,A>, SimpleNumericResult<T>, StringResult

All Known Implementing Classes:

AnyExpression.CountAllExpression, AnyExpression.CountDistinctExpression, AnyExpression.CountExpression, AnyExpression.NTileExpression, AnyExpression.PercentageExpression, AnyExpression.RankExpression, BooleanExpression.BooleanIfThenElseExpression, BooleanExpression.DateIfThenElseExpression, BooleanExpression.InstantIfThenElseExpression, BooleanExpression.IntegerIfThenElseExpression, BooleanExpression.LastValueExpression, BooleanExpression.LocalDateIfThenElseExpression, BooleanExpression.LocalDateTimeIfThenElseExpression, BooleanExpression.NumberIfThenElseExpression, BooleanExpression.StringIfThenElseExpression, DateColumn, DateExpression, DateExpression.DateAddDaysExpression, DateExpression.DateAddIntegerDaysExpression, DateExpression.DateAddIntegerHoursExpression, DateExpression.DateAddIntegerMinutesExpression, DateExpression.DateAddIntegerMonthsExpression, DateExpression.DateAddIntegerSecondsExpression, DateExpression.DateAddIntegerWeeksExpression, DateExpression.DateAddIntegerYearsExpression, DateExpression.DateAddMonthsExpression, DateExpression.DateAddSecondsExpression, DateExpression.DateCurrentDateExpression, DateExpression.DateCurrentTimeExpression, DateExpression.DateDayExpression, DateExpression.DateDayOfWeekExpression, DateExpression.DateDaysFromExpression, DateExpression.DateEndOfMonthExpression, DateExpression.DateGetDateRepeatFromExpression, DateExpression.DateGetDurationFromExpression, DateExpression.DateGreatestOfExpression, DateExpression.DateHourExpression, DateExpression.DateHoursFromExpression, DateExpression.DateIfDBNullExpression, DateExpression.DateLeastOfExpression, DateExpression.DateMaxExpression, DateExpression.DateMinExpression, DateExpression.DateMinusDateRepeatExpression, DateExpression.DateMinusDurationExpression, DateExpression.DateMinuteExpression, DateExpression.DateMinutesFromExpression, DateExpression.DateMonthExpression, DateExpression.DateMonthsFromExpression, DateExpression.DateOnlyCurrentDateExpression, DateExpression.DatePlusDateRepeatExpression, DateExpression.DatePlusDurationExpression, DateExpression.DateSecondAndSubsecondExpression, DateExpression.DateSecondExpression, DateExpression.DateSecondsFromExpression, DateExpression.DateSubsecondExpression, DateExpression.DateWeeksFromExpression, DateExpression.DateYearExpression, DateExpression.DateYearsFromExpression, DateExpression.LastValueExpression, DateExpression.NthValueExpression, DateRepeatColumn, DateRepeatExpression, DateRepeatExpression.Comparison, DateRepeatExpression.FirstValueExpression, DateRepeatExpression.GetYearsExpression, DateRepeatExpression.LagExpression, DateRepeatExpression.LastValueExpression, DateRepeatExpression.LeadExpression, DateRepeatExpression.NthValueExpression, DBDate, DBDateOnly, DBDateRepeat, DBDuration, DBInstant, DBInteger, DBIntegerEnum, DBLocalDate, DBLocalDateTime, DBNumber, DBNumberStatistics, DBPasswordHash, DBStatistics, DBString, DBStringTrimmed, DBUntypedValue, DurationColumn, DurationExpression, DurationExpression.FirstValueExpression, DurationExpression.LagExpression, DurationExpression.LastValueExpression, DurationExpression.LeadExpression, DurationExpression.NthValueExpression, InstantColumn, InstantExpression, InstantExpression.AddDaysExpression, InstantExpression.AddIntegerDaysExpression, InstantExpression.AddIntegerHoursExpression, InstantExpression.AddIntegerMinutesExpression, InstantExpression.AddIntegerMonthsExpression, InstantExpression.AddIntegerSecondsExpression, InstantExpression.AddIntegerWeeksExpression, InstantExpression.AddIntegerYearsExpression, InstantExpression.AddMonthsExpression, InstantExpression.AddSecondsExpression, InstantExpression.CurrentInstantDateOnlyExpression, InstantExpression.CurrentInstantExpression, InstantExpression.CurrentTimeExpression, InstantExpression.DayOfWeekExpression, InstantExpression.DaysFromExpression, InstantExpression.EndOfMonthExpression, InstantExpression.GreatestOfExpression, InstantExpression.HoursFromExpression, InstantExpression.InstantDayExpression, InstantExpression.InstantGetDateRepeatFromExpression, InstantExpression.InstantHourExpression, InstantExpression.InstantIfDBNullExpression, InstantExpression.InstantMaxExpression, InstantExpression.InstantMinExpression, InstantExpression.InstantMinusDateRepeatExpression, InstantExpression.InstantMinuteExpression, InstantExpression.InstantMonthExpression, InstantExpression.InstantPlusDateRepeatExpression, InstantExpression.InstantSecondAndSubsecondExpression, InstantExpression.InstantSecondExpression, InstantExpression.InstantSubsecondExpression, InstantExpression.InstantYearExpression, InstantExpression.LagExpression, InstantExpression.LastValueExpression, InstantExpression.LeadExpression, InstantExpression.LeastOfExpression, InstantExpression.MinutesFromExpression, InstantExpression.MonthsFromExpression, InstantExpression.NthValueExpression, InstantExpression.SecondsFromExpression, InstantExpression.WeeksFromExpression, InstantExpression.YearsFromExpression, IntegerColumn, IntegerExpression, IntegerExpression.FirstValueExpression, IntegerExpression.LagExpression, IntegerExpression.LastValueExpression, IntegerExpression.LeadExpression, IntegerExpression.MaxUnaryFunction, IntegerExpression.MinUnaryFunction, IntegerExpression.NthValueExpression, IntegerExpression.SinhFunction, IntegerExpression.SumFunction, Line2DExpression.MagnitudeExpression, Line2DExpression.MaxXExpression, Line2DExpression.MaxYExpression, Line2DExpression.MeasurableDimensionsExpression, Line2DExpression.MinXExpression, Line2DExpression.MinYExpression, Line2DExpression.SpatialDimensionsExpression, Line2DExpression.StringResultExpression, LineSegment2DExpression.MagnitudeExpression, LineSegment2DExpression.MaxXExpression, LineSegment2DExpression.MaxYExpression, LineSegment2DExpression.MeasurableDimensionsExpression, LineSegment2DExpression.MinXExpression, LineSegment2DExpression.MinYExpression, LineSegment2DExpression.SpatialDimensionsExpression, LocalDateColumn, LocalDateExpression, LocalDateExpression.DateAddDaysExpression, LocalDateExpression.DateAddIntegerDaysExpression, LocalDateExpression.DateAddIntegerHoursExpression, LocalDateExpression.DateAddIntegerMinutesExpression, LocalDateExpression.DateAddIntegerMonthsExpression, LocalDateExpression.DateAddIntegerSecondsExpression, LocalDateExpression.DateAddIntegerWeeksExpression, LocalDateExpression.DateAddIntegerYearsExpression, LocalDateExpression.DateAddMonthsExpression, LocalDateExpression.DateAddSecondsExpression, LocalDateExpression.DateCurrentDateExpression, LocalDateExpression.DateCurrentTimeExpression, LocalDateExpression.DateDayExpression, LocalDateExpression.DateDayOfWeekExpression, LocalDateExpression.DateDaysFromExpression, LocalDateExpression.DateEndOfMonthExpression, LocalDateExpression.DateGetDateRepeatFromExpression, LocalDateExpression.DateGreatestOfExpression, LocalDateExpression.DateHourExpression, LocalDateExpression.DateHoursFromExpression, LocalDateExpression.DateIfDBNullExpression, LocalDateExpression.DateLeastOfExpression, LocalDateExpression.DateMaxExpression, LocalDateExpression.DateMinExpression, LocalDateExpression.DateMinusDateRepeatExpression, LocalDateExpression.DateMinuteExpression, LocalDateExpression.DateMinutesFromExpression, LocalDateExpression.DateMonthExpression, LocalDateExpression.DateMonthsFromExpression, LocalDateExpression.DateOnlyCurrentDateExpression, LocalDateExpression.DatePlusDateRepeatExpression, LocalDateExpression.DateSecondExpression, LocalDateExpression.DateSecondsFromExpression, LocalDateExpression.DateSubsecondExpression, LocalDateExpression.DateWeeksFromExpression, LocalDateExpression.DateYearExpression, LocalDateExpression.DateYearsFromExpression, LocalDateExpression.LagExpression, LocalDateExpression.LastValueExpression, LocalDateExpression.LeadExpression, LocalDateExpression.NthValueExpression, LocalDateTimeColumn, LocalDateTimeExpression, LocalDateTimeExpression.CurrentLocalDateLocalDateTimeExpression, LocalDateTimeExpression.LagExpression, LocalDateTimeExpression.LastValueExpression, LocalDateTimeExpression.LeadExpression, LocalDateTimeExpression.LocalDateTimeAddDaysExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerDaysExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerHoursExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerMinutesExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerMonthsExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerSecondsExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerWeeksExpression, LocalDateTimeExpression.LocalDateTimeAddIntegerYearsExpression, LocalDateTimeExpression.LocalDateTimeAddMonthsExpression, LocalDateTimeExpression.LocalDateTimeAddSecondsExpression, LocalDateTimeExpression.LocalDateTimeCurrentLocalDateTimeExpression, LocalDateTimeExpression.LocalDateTimeCurrentTimeExpression, LocalDateTimeExpression.LocalDateTimeDayExpression, LocalDateTimeExpression.LocalDateTimeDayOfWeekExpression, LocalDateTimeExpression.LocalDateTimeDaysFromExpression, LocalDateTimeExpression.LocalDateTimeEndOfMonthExpression, LocalDateTimeExpression.LocalDateTimeGetDateRepeatFromExpression, LocalDateTimeExpression.LocalDateTimeGreatestOfExpression, LocalDateTimeExpression.LocalDateTimeHourExpression, LocalDateTimeExpression.LocalDateTimeHoursFromExpression, LocalDateTimeExpression.LocalDateTimeIfDBNullExpression, LocalDateTimeExpression.LocalDateTimeLeastOfExpression, LocalDateTimeExpression.LocalDateTimeMaxExpression, LocalDateTimeExpression.LocalDateTimeMinExpression, LocalDateTimeExpression.LocalDateTimeMinusDateRepeatExpression, LocalDateTimeExpression.LocalDateTimeMinuteExpression, LocalDateTimeExpression.LocalDateTimeMinutesFromExpression, LocalDateTimeExpression.LocalDateTimeMonthExpression, LocalDateTimeExpression.LocalDateTimeMonthsFromExpression, LocalDateTimeExpression.LocalDateTimePlusDateRepeatExpression, LocalDateTimeExpression.LocalDateTimeSecondAndSubsecondExpression, LocalDateTimeExpression.LocalDateTimeSecondExpression, LocalDateTimeExpression.LocalDateTimeSecondsFromExpression, LocalDateTimeExpression.LocalDateTimeSubsecondExpression, LocalDateTimeExpression.LocalDateTimeWeeksFromExpression, LocalDateTimeExpression.LocalDateTimeYearExpression, LocalDateTimeExpression.LocalDateTimeYearsFromExpression, LocalDateTimeExpression.NthValueExpression, NumberColumn, NumberExpression, NumberExpression.AbsoluteValueExpression, NumberExpression.AverageExpression, NumberExpression.ChooseFromStringsExpression, NumberExpression.CosineExpression, NumberExpression.CotangentExpression, NumberExpression.DegreesExpression, NumberExpression.DivideByExpression, NumberExpression.ExponentialExpression, NumberExpression.FirstValueExpression, NumberExpression.GreatestOfExpression, NumberExpression.HyperbolicCosineExpression, NumberExpression.HyperbolicSineExpression, NumberExpression.HyperbolicTangentExpression, NumberExpression.IfDBNullExpression, NumberExpression.IntegerResultExpression, NumberExpression.InverseCosineExpression, NumberExpression.InverseSineExpression, NumberExpression.InverseTangent2Expression, NumberExpression.InverseTangentExpression, NumberExpression.LagExpression, NumberExpression.LastValueExpression, NumberExpression.LeadExpression, NumberExpression.LogBase10Expression, NumberExpression.MaxUnaryFunction, NumberExpression.MinUnaryFunction, NumberExpression.ModulusRemainderExpression, NumberExpression.NaturalLogExpression, NumberExpression.NthValueExpression, NumberExpression.PlusExpression, NumberExpression.PowerExpression, NumberExpression.RadiansExpression, NumberExpression.RandomNumberExpression, NumberExpression.RoundDownExpression, NumberExpression.RoundExpression, NumberExpression.RoundToNumberofDecimalPlaces, NumberExpression.RoundUpExpression, NumberExpression.SignExpression, NumberExpression.SineExpression, NumberExpression.SquareRootExpression, NumberExpression.StandardDeviationExpression, NumberExpression.SumExpression, NumberExpression.TangentExpression, NumberExpression.TimesExpression, NumberExpression.TruncateExpression, Point2DExpression.DistanceToExpression, Point2DExpression.GetXExpression, Point2DExpression.GetYExpression, Point2DExpression.MagnitudeExpression, Point2DExpression.MeasurableDimensionsExpression, Point2DExpression.SpatialDimensionsExpression, RangeExpression, RecursiveQueryDepthIncreaseExpression, SimpleNumericExpression, StringColumn, StringExpression, StringExpression.DBBinaryStringFunction, StringExpression.FirstValueExpression, StringExpression.IntegerLengthExpression, StringExpression.LagExpression, StringExpression.LastValueExpression, StringExpression.LeadExpression, StringExpression.NthValueExpression, StringExpression.StringAggregateExpression, StringExpression.StringAggregateWithOrderByExpression, StringExpression.StringAppendExpression, StringExpression.StringBracketExpression, StringExpression.StringCurrentUserExpression, StringExpression.StringFirstIntegerAsSubstringExpression, StringExpression.StringFirstNumberAsSubstringExpression, StringExpression.StringIfDBNullExpression, StringExpression.StringLeftTrimExpression, StringExpression.StringLocationOfExpression, StringExpression.StringLowercaseExpression, StringExpression.StringMaxExpression, StringExpression.StringMinExpression, StringExpression.StringNumberResultExpression, StringExpression.StringReplaceExpression, StringExpression.StringRightTrimExpression, StringExpression.StringSubstringAfterExpression, StringExpression.StringSubstringBeforeExpression, StringExpression.StringTrimExpression, StringExpression.StringUppercaseExpression, StringLiteral

public interface RangeResult<T>
extends InResult<T>

A range result has a simple linear distribution.

Good examples are the number line, dictionaries, and the time line. Based on those examples numbers, strings, and dates are RangeResults.

Spatial values are not range comparable as they exist in 2 or more dimensions and can't be ordered consistently on a line.

Booleans are not range comparable as there are only 3 values (true, false, and null) and there is no commonly agreed ordering.

Author:

gregorygraham

Method Summary

Methods inherited from interface nz.co.gregs.dbvolution.expressions.DBExpression

copy, createSQLForFromClause, createSQLForGroupByClause, getQueryableDatatypeForExpressionValue, getTablesInvolved, isAggregator, isComplexExpression, isPurelyFunctional, isWindowingFunction

Methods inherited from interface nz.co.gregs.dbvolution.results.ExpressionCanHaveNullValues

getIncludesNull

Methods inherited from interface nz.co.gregs.dbvolution.expressions.HasSQLString

toSQLString