Re: SHA1 on postgres 8.3

Martijn van Oosterhout wrote:
> On Sun, Jan 20, 2008 at 12:21:01AM -0800, Jon Hancock wrote:
>
>> I am trying to port a MySQL db to postgres 8.3rc1.
>> In MySQL I have a function SHA1, which is critical for storing and
>> authenticating passwords.
>> I see some old posts on how to add this function myself. see:
>> http://raveica.comdurav.com/blog/programming/how-do-i-add-sha1-to-postgresql/
>>
>
> It's in contrib in the pgcrypto module. If you use a distribution you
> can usually simply just install it.
>
> http://www.postgresql.org/docs/8.3/static/pgcrypto.html
>
> Have a nice day,
>

After you installed pgcrypto.so, just create a small function:

CREATE OR REPLACE FUNCTION sha1(text) RETURNS text AS '
SELECT
ENCODE(DIGEST($1, ''sha1"),"hex") AS result
' LANGUAGE 'SQL';

--
Regards,

Julio Cesar Sánchez González.

--
Ahora me he convertido en la muerte, destructora de mundos.
Soy la Muerte que se lleva todo, la fuente de las cosas que vendran.

www.sistemasyconectividad.com.mx http://darkavngr.blogspot.com/