Re: How to properly hash a row or set of columns.

2022-01-18 Thread Klaudie Willis
A minor correction by casting the row a little: create table t ( a text b text hashid varchar not NULL GENERATED ALWAYS AS (sha256(row(a,b)::text::bytea)) stored ) Sent with [ProtonMail](https://protonmail.com/) Secure Email. ‐‐‐ Original Message ‐‐‐ On Tuesday, January 18th, 2022 at 14:

How to properly hash a row or set of columns.

2022-01-18 Thread Klaudie Willis
Hashing a row or set of columns is useful in some circumstances where you need to compare the row with for instance incoming data. This is most relevant when you do not control the source data yourself, or else you would usually solve it by other means. Still, It would be great if you could do