Mathematic Operators and Functions | Teradata Vantage - Mathematic Operators and Functions - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
Some Unbounded Array Framework (UAF) functions can take user-defined formulas as input. The operation precedence for the functions are as follows:
  • First precedence: Unary addition and unary subtraction
  • Second precedence: Exponential
  • Third precedence: Multiplication and division
  • Fourth precedence: Addition and subtraction
The order for evaluation for the formulas is as follows:
  • Elements in parentheses are performed first.
  • When no parentheses are present, operations are performed in order of precedence.
  • Operators of the same precedence are evaluated from left to right.