17.10 - Result Type and Attributes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.