Horton

Re: [PATCH] Add crc32(text) & crc32(bytea)

Peter Eisentraut <peter@eisentraut.org>

View thread View on postgr.es
From: Peter Eisentraut <peter@eisentraut.org>
To: Nathan Bossart <nathandbossart@gmail.com>, Aleksander Alekseev <aleksander@timescale.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-08-08T14:27:20Z
Lists: pgsql-hackers 
On 05.08.24 17:28, Nathan Bossart wrote:
> This looks pretty good to me.  The only point that I think deserves more
> discussion is the return type.  Does bytea make the most sense here?  Or
> should we consider int/bigint?

The correct return type of a CRC operation in general is some kind of 
exact numerical type.  Just pick the best one that fits the result.  I 
don't think bytea is appropriate.

Commits

  1. Add user-callable CRC functions.

  2. Add user-callable SHA-2 functions