Re: sha1 function - Mailing list pgsql-general

From Phoenix Kiula
Subject Re: sha1 function
Date
Msg-id e373d31e0710011330j7bb021bcx69e39a4d48ee7374@mail.gmail.com
Whole thread Raw
In response to sha1 function  (Martin Marques <martin@bugs.unl.edu.ar>)
List pgsql-general
On 01/10/2007, Martin Marques <martin@bugs.unl.edu.ar> wrote:
>
> 1) Is MD5's weakness true?


Yes, but not really for using in a password functionality. You are
very unlikely to repeat a password but in any case you will have the
user ID to make it unique.


> 2) Is there any sha1() functions in PostgreSQL?
>


It doesn't come with the default setup, but it's very simple to get.
Take a look at this: http://snipr.com/pg_sha1

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Partitioned table limitation
Next
From: Poul Møller Hansen
Date:
Subject: Re: Dump of table structure is not consistent