On 17-08-2020 13:49, Alex Peshkoff via Firebird-devel wrote:
Appears you are right. We should better have separate functions for
lookup & crypto hashes.
HASH(value USING alg) returning integer
and
CRYPT_HASH(value USING alg) returning varbinary
As soon as we want alrgorithm name in variable we can make that form of
HASH() return maximum required integer (up to int128 if we support
something like MurmurHash3) and appropriate form of CRYPT_HASH() return
vabinary of maximum required length.
This sounds like a reasonable compromise.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
