Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

CHECKSUM Function

Computes a checksum value for building a hash index.

Syntax

Copy
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:

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