On 3/7/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
I know that there is a md5 internal function on postgresql, but I noticed
that it isn't the more secure today. I would like to know if there is a
SHA-1 function implemented yet of, if not, if the team has plan to introduce
it on PostgreSQL.
You are probably looking for the pgcrypto contribution, look in the contrib
directory for it.
test=# select encode(digest('blahblah', 'sha256'), 'hex');
encode
------------------------------------------------------------------
40b1bbb5445fc021a312315379f4633284851e14d1db83fb0730f58872d6033b
(1 row)
--
Chad
http://www.postgresqlforums.com/
