CHECKSUM function - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

CHECKSUM function

Computes a checksum value for building a hash index.

Syntax

CHECKSUM(expression)

Argument

expression

The input expression must be a VARCHAR, INTEGER, or DECIMAL data type.

Return type

The CHECKSUM function returns an integer.

Example

The following example computes a checksum value for the COMMISSION column:

select checksum(commission) from sales order by salesid limit 10; checksum ---------- 10920 1140 5250 2625 2310 5910 11820 2955 8865 975 (10 rows)