Обсуждение: Hashing text in hexadecimal

Hello to everyone,
I would need to hash some text and I would to produce an hexadecimal value
as result.

Is there a postgres function to achieve this goal?

Thank you very much.

Mephysto

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Hashing-text-in-hexadecimal-tp5022875p5022875.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

On 25 Listopad 2011, 15:15, mephysto wrote:
> Hello to everyone,
> I would need to hash some text and I would to produce an hexadecimal value
> as result.
>
> Is there a postgres function to achieve this goal?

What about md5(text)? If you need better hashing (e.g. sha-1), check
pgcrypto contrib module.

T.

Thank you very much.

Meph

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Hashing-text-in-hexadecimal-tp5022875p5022895.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.