Enrico Riedel wrote:
> Has anyone an idea on how or any pointer into the right direction to
> accomplish the above task?
>
> Thanks already in advance!
If you don't mind having plpythonu installed in your database, a lot of this
sort of thing becomes trivial:
CREATE OR REPLACE FUNCTION sha1(text) RETURNS char(40) AS '
import sha
return sha.new(args[0]).hexdigest()
' LANGUAGE plpythonu IMMUTABLE RETURNS NULL ON NULL INPUT;
--
Stuart Bishop <stuart(at)stuartbishop(dot)net>
http://www.stuartbishop.net/