Обсуждение: how to get the md5 result of a string ?

Hi,

Is there a function like:

select md5(<attribute_name>) from ....

Thanks,


--
Feite Brekeveld
feite.brekeveld@osiris-it.nl
http://www.osiris-it.nl

On Mon, Sep 10, 2001 at 11:40:27PM +0200, Feite Brekeveld wrote:
> Is there a function like:
>
> select md5(<attribute_name>) from ....

    digest(field, 'md5')

If you want in hex:

    encode(digest(field, 'md5'), 'hex')

Look into contrib/pgcrypto in PostgreSQL source.

--
marko

Yes see /contrig/pgcrypto.

> Hi,
>
> Is there a function like:
>
> select md5(<attribute_name>) from ....
>
> Thanks,
>
>
> --
> Feite Brekeveld
> feite.brekeveld@osiris-it.nl
> http://www.osiris-it.nl
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026