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)