Re: [Firebird-devel] HASH function (CORE-4436)

[Leyne, S. <Se...@br...>]

> We have HASH function that returns a 64 bit integer. The algorithm is bad and
> the result too small for a hash.
> 
> I propose to extend the same function with a second parameter with the
> algorithm name.
> 
> When only one parameter is passed, things works as now.
> 
> When two parameters are passed, it will return a VARCHAR(64) CHARACTER
> SET OCTETS. That's sufficient for a SHA-256, for example.
> 
> We implement (preferably getting code with compatible license or public
> domain - like was done for SHA-1 used in authentication - instead of use a
> bloated library) some algorithms (MD5, some useful SHA-*). No need for
> "hash plugins" for now.

Would this approach have any performance advantages over using UDFs?


Sean