Result Type and Attributes - Analytics Database - Teradata Vantage

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;