<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Thanks Raymond !!!!<br>
<blockquote cite="mid:4989A827(dot)5060104(at)vicomtech(dot)org" type="cite"><br>
That is something I wanted! It's Great if it is already integrated in
Postgre! Superb. This is much more easy.<br>
<br>
Thank you All.<br>
<br>
Best,<br>
<blockquote cite="mid:4989A790(dot)7090401(at)gmail(dot)com" type="cite">
<meta content="text/html;charset=ISO-8859-1"
http-equiv="Content-Type">
Iñigo Barandiaran wrote:
<blockquote cite="mid:49897455(dot)7080602(at)vicomtech(dot)org" type="cite"><br>
<br>
</blockquote>
Well, you can use the built-in md5 function for this purpose. For
instance, you could insert a password into the table with a statement
like:<br>
<br>
<blockquote>insert into auth_data (user_id, password) values (1,
md5('test'));<br>
</blockquote>
<br>
And compare the supplied password with something like:<br>
<br>
<blockquote>select true from auth_data where user_id = 1 and
password
=
md5('test');<br>
</blockquote>
<br>
You don't need to depend on an external library for this functionality;
it's built right into Postgres. Personally, in my own apps I write in
PHP, I use a combination of sha1 and md5 to hash user passwords,
without depending on Postgres to do the hashing, but the effect is
basically the same.<br>
<br>
Raymond<br>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>