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

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

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.

   SELECT CAST(REGR_COUNT(weight,height) AS BIGINT)
   FROM regrtbl;