Package dev.frostlake.functions.aggregate

Interface CoercedNumericArgumentAccumulator

All Known Implementing Classes:
MedianAccumulator, PercentileContAccumulator, PercentileDiscAccumulator
public interface CoercedNumericArgumentAccumulator
An accumulator whose numeric answer can be asked of a VARCHAR or VARIANT argument. Live orders such an argument by its OWN type — text by text, a VARIANT member by its kind — and converts each value to a whole number, NUMBER(9,0), before it computes: MEDIAN over '1.5' and '2.25' is 2.000, and PERCENTILE_DISC hands back the converted whole number. The values alone cannot tell this argument from a numeric one ('2' and 2 both convert), so the declaration is handed over through this hook.

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    setCoercedNumericArgument(boolean coerced)
    Tell the accumulator whether its argument is declared VARCHAR or VARIANT.

  • Method Details

    • setCoercedNumericArgument

      void setCoercedNumericArgument(boolean coerced)
      Tell the accumulator whether its argument is declared VARCHAR or VARIANT.
      Parameters:
      coerced - whether the aggregated expression is text or VARIANT, converted value by value