From: Dave Thomas <Dave@...>
Date: 2002-08-13T00:24:46+09:00
Subject: Re: Primary Key Hash help

"Chris Morris" <chrismo@clabs.org> writes:

> True - but the result would be of varying length and a bit cumbersome. I was
> hoping for something along the lines of what Philipp replied with (MD5
> hash). The MD5 hash is still a little cumbersome, but less than just joining
> all the data together.

Chris:

As it's a hash, of course, it is not guaranteed to generate unique
values for unique rows. In practice I'd be very(!) surprised if you
got a clash, but it it was crucially important that keys were
one-to-one with records you might want to find an alternative.


Dave