Re: md5

On 24 June 2010 19:25, Jean-Yves F. Barbier <12ukwn@gmail.com> wrote:
> Hi list,
>
> As md5 isn't very safe, is it planned to introduce sha-256/sha-512)?
>

You can use crypt() in pgcrypto if you want that:
http://www.postgresql.org/docs/8.4/static/pgcrypto.html

But it would be nice to see some of this stuff in core.  I personally
would like a whirlpool hash function.

postgres=# select whirlpool('meow');
                                                            whirlpool

----------------------------------------------------------------------------------------------------------------------------------

bc6145703d25de5cd3fb47f6203d42b2a68b67199ee68bdda84d680900d1147073200ddb87559f5d4d576de76a0cd22e21026a12b3322af4872f34f67d8f642c
(1 row)

Thom