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.





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

Return type

The CHECKSUM function returns an integer.


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)