> 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 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel