16.20 - Result Type and Attributes - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
March 2019
Programming Reference

The following table lists the data type for the result of REGR_COUNT(y,x).

Mode Data Type
ANSI If MaxDecimal in DBSControl is…
  • 0 or 15, then the result type is DECIMAL(15,0).
  • 18, then the result type is DECIMAL(18,0).
  • 38, then the result type is DECIMAL(38,0).
Teradata INTEGER

The result type of REGR_COUNT is consistent with the result type of COUNT for ANSI transaction mode and Teradata transaction mode.

When in Teradata mode, if the result of REGR_COUNT overflows and reports an error, you can cast the result to another data type, as illustrated by the following example.

   FROM regrtbl;
Here are default formats and titles for the result of REGR_COUNT.
  • If operand y is numeric or character, the format is:
    • For ANSI mode, if MaxDecimal in DBSControl is:

      0 or 15, the format is -(15)9

      18, the format is -(18)9

      38, the format is -(38)9

    • For Teradata mode, the format is the default format for INTEGER
  • If operand y is UDT, the format is the format for the data type to which the UDT is implicitly cast.