Posted by Steve Kass on 10/14/05 16:42

Jens,

This is not 100% reliable. If the checksum functions are
different, there must be a difference in the tables, but the
converse is not true. The checksum functions can return the
same values on different data, like any hash function.

The only sure way is to compare column by column values.

Steve Kass
Drew University

Jens wrote:
> Do you just want to know if there IS a difference or what sort of
> difference ?
>
> --For the Whole Table
> SELECT checksum_agg(binary_checksum(*)) from SomeTable
>
> --For just the rows
> Select binary_checksum(*) from SomeTable
>
> If you need more granualarity, then it would be more work.
>
> HTH, Jens Suessmeyer.
>

[Back to original message]