Function Reference

1010data Insights Platform offers a rich set of functions that may be used in value expressions when creating computed columns and in selection expressions when performing row selections.

In general, input arguments to functions may be either scalar expressions or column expressions. Exceptions are noted within the descriptions for those arguments to which this does not apply.

For each argument, the allowable data types are listed. In addition, the following terms are used to reference a related grouping of data types:

Term Data Types
any simple type Refers to the following data types:
  • integer
  • big integer (Available as of version 11.25)
  • decimal
  • text
any numeric type Refers to the following data types:
  • integer
  • big integer (Available as of version 11.25)
  • decimal