This should work perfectly for me. Thank you so much!
On Wed, Sep 18, 2019 at 12:50 PM Adam Brusselback <adambrusselback(at)gmail(dot)com>
wrote:
> I've had a similar issue in the past.
>
> I used the md5 hash function and stored it in a UUID column for my
> comparisons. Bigger than a bigint, but still much faster than string
> comparisons directly for my use case.
> UUID works fine for storing md5 hashes and gives you the ability to
> piggyback on all the index support built for them.
>
> Hope that helps,
> -Adam
>