Re: MD5 aggregate

On 26 June 2013 21:46, Peter Eisentraut <peter_e@gmx.net> wrote:
> On 6/26/13 4:04 PM, Dean Rasheed wrote:
>> A quick google search reveals several people asking for something like
>> this, and people recommending md5(string_agg(...)) or
>> md5(string_agg(md5(...))) based solutions, which are doomed to failure
>> on larger tables.
>
> The thread discussed several other options of checksumming tables that
> did not have the air of a crytographic offering, as Noah put it.
>

True but md5 has the advantage of being directly comparable with the
output of Unix md5sum, which would be useful if you loaded data from
external files and wanted to confirm that your import process didn't
mangle it.

Regards,
Dean