Re: [SQL] MD5 use in PL/Perl

2000-12-28 Thread Peter Eisentraut
Marc Rassbach writes: > Attempting to xlate to PL/Perl > > settle=# create function md5out3(varchar) returns varchar(32) as ' > settle'# use MD5; > settle'# my $mdval = new MD5; > settle'# my $result ; > settle'# my $out; > settle'# $mdval->add($_[0]); > settle'# $result = $mdval->digest(); > set

[SQL] MD5 use in PL/Perl

2000-12-28 Thread Marc Rassbach
I'd like to be able to only store the database of usernames and passwrods here locally as a md5 hash. (in case the black hats come to visitI'd like to make life hard for them) Using AuthPG, I should be able to create a SQL call to postgresbut there is no native md5 hashing function. I