Re: sha1 function

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Martin Marques" <martin(at)bugs(dot)unl(dot)edu(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: sha1 function
Date: 2007-10-01 20:30:52
Message-ID: e373d31e0710011330j7bb021bcx69e39a4d48ee7374@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 01/10/2007, Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Poul Møller Hansen 2007-10-01 21:08:47 Re: Dump of table structure is not consistent
Previous Message Scott Marlowe 2007-10-01 20:22:14 Re: Partitioned table limitation