On 10-08-2020 20:43, Leyne, Sean wrote:
3- That there should be separate 'implementations' for the different datatype that is returned: Hex (i.e. String/varchar) and Integer (Octal?).Eg. HASH_ToHex, or HASH_AsInteger
If you want HEX, then you use HEX_ENCODE(HASH(value USING <hash-name>)), no need for a separate HASH_TOHEX function.
Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel