Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 1EBF59FB61C
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  1 Mar 2007 15:49:44 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 91179-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  1 Mar 2007 15:49:34 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from web55606.mail.re4.yahoo.com (web55606.mail.re4.yahoo.com
	[206.190.58.230])
	by postgresql.org (Postfix) with SMTP id 8FC339FB612
	for <pgsql-sql@postgresql.org>; Thu,  1 Mar 2007 15:49:34 -0400 (AST)
Received: (qmail 20035 invoked by uid 60001); 1 Mar 2007 19:49:33 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.mx;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID;
	b=osYg7wPFEa/NJHm8rRLxwzbZcUYgHfGQFL56Pl8sVQldDJe5BrTodPzhV6hHGrHePryXFlWUZi0ETm3+sfG35+dDL3fusrdBccqP7pKVzJz19rLBfI+dBozEa/djD+3xg7cdwpJf/sfg/IrggpX9dAKpmSxP4mC5UyR4J+bgnRU=;
X-YMail-OSG: 
 SF7exmEVM1lvhsaMv8qLt1GYCRy7uUWw5Z1Wzy2FJVd9Vt0e43.oU7BY3GE3QhkUZUi_9XX1JOAvVHAT86JTnH9TSiwDLREB0Tqx8lniegCi7Llp7JAns9leDBfJ8BoNm629aBZp71nqdQ8-
Received: from [165.98.140.116] by web55606.mail.re4.yahoo.com via HTTP;
	Thu, 01 Mar 2007 11:49:33 PST
X-Mailer: YahooMailRC/368.8 YahooMailWebService/0.6.132.8
Date: Thu, 1 Mar 2007 11:49:33 -0800 (PST)
From: Eugenio Flores <eflores767003@yahoo.com.mx>
Subject: Re: How to store a password encripted in a user defined table
To: John DeSoi <desoi@pgedit.com>
Cc: Andrej Ricnik-Bay <andrej.groups@gmail.com>,
	PostgreSQL <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1274382325-1172778573=:3417"
Message-ID: <278410.3417.qm@web55606.mail.re4.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.331 tagged_above=0 required=5 tests=AWL, BAYES_40,
	HTML_40_50, HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200703/20
X-Sequence-Number: 27658

--0-1274382325-1172778573=:3417
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Thanks for your anwers. They have been very useful.=0A=0AThanks again.=0A=
=0A=0A----- Mensaje original ----=0ADe: John DeSoi <desoi@pgedit.com>=0APar=
a: Eugenio Flores <eflores767003@yahoo.com.mx>=0ACC: Andrej Ricnik-Bay <and=
rej.groups@gmail.com>; PostgreSQL <pgsql-sql@postgresql.org>=0AEnviado: jue=
ves, 1 de marzo, 2007 5:25:28=0AAsunto: Re: [SQL] How to store a password e=
ncripted in a user defined table=0A=0A=0AMD5 is built-in to PostgreSQL. It =
is what PostgreSQL itself uses to  =0Ahash passwords. For example:=0A=0Asel=
ect md5('this is my password');=0A=0A                md5=0A----------------=
------------------=0A210d53992dff432ec1b1a9698af9da16=0A(1 row)=0A=0A=0A=0A=
On Mar 1, 2007, at 6:06 AM, Eugenio Flores wrote:=0A=0A> Thanks Andrej. But=
 how can I use such algoritms in postgresql? arey  =0A> they defined in a f=
unction that I can call?=0A>=0A> Or, do I have to code one of those algorit=
hm to use it in my  =0A> application?=0A=0A=0A=0AJohn DeSoi, Ph.D.=0Ahttp:/=
/pgedit.com/=0APower Tools for PostgreSQL=0A=0A=0A-------------------------=
--(end of broadcast)---------------------------=0ATIP 9: In versions below =
8.0, the planner will ignore your desire to=0A       choose an index scan i=
f your joining column's datatypes do not=0A       match=0A=0A=0A=09=0A=09=
=0A=09=09=0A___________________________________________________________ =0A=
Do You Yahoo!? =0ALa mejor conexi=F3n a Internet y <b >2GB</b> extra a tu c=
orreo por $100 al mes. http://net.yahoo.com.mx =0A
--0-1274382325-1172778573=:3417
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:times new roman, new york, times, serif;=
font-size:12pt"><DIV style=3D"FONT-SIZE: 12pt; FONT-FAMILY: times new roman=
, new york, times, serif">Thanks for your anwers. They have been very usefu=
l.</DIV>=0A<DIV style=3D"FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new=
 york, times, serif">&nbsp;</DIV>=0A<DIV style=3D"FONT-SIZE: 12pt; FONT-FAM=
ILY: times new roman, new york, times, serif">Thanks again.<BR><BR></DIV>=
=0A<DIV style=3D"FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, t=
imes, serif">----- Mensaje original ----<BR>De: John DeSoi &lt;desoi@pgedit=
.com&gt;<BR>Para: Eugenio Flores &lt;eflores767003@yahoo.com.mx&gt;<BR>CC: =
Andrej Ricnik-Bay &lt;andrej.groups@gmail.com&gt;; PostgreSQL &lt;pgsql-sql=
@postgresql.org&gt;<BR>Enviado: jueves, 1 de marzo, 2007 5:25:28<BR>Asunto:=
 Re: [SQL] How to store a password encripted in a user defined table<BR><BR=
>=0A<DIV>MD5 is built-in to PostgreSQL. It is what PostgreSQL itself uses t=
o&nbsp;&nbsp;<BR>hash passwords. For example:<BR><BR>select md5('this is my=
 password');<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;md5<BR>---------------------------=
-------<BR>210d53992dff432ec1b1a9698af9da16<BR>(1 row)<BR><BR><BR><BR>On Ma=
r 1, 2007, at 6:06 AM, Eugenio Flores wrote:<BR><BR>&gt; Thanks Andrej. But=
 how can I use such algoritms in postgresql? arey&nbsp;&nbsp;<BR>&gt; they =
defined in a function that I can call?<BR>&gt;<BR>&gt; Or, do I have to cod=
e one of those algorithm to use it in my&nbsp;&nbsp;<BR>&gt; application?<B=
R><BR><BR><BR>John DeSoi, Ph.D.<BR><A href=3D"http://pgedit.com/" target=3D=
_blank>http://pgedit.com/</A><BR>Power Tools for PostgreSQL<BR><BR><BR>----=
-----------------------(end of broadcast)---------------------------<BR>TIP=
 9: In versions below 8.0, the planner will ignore your desire
 to<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; choose an index scan if your jo=
ining column's datatypes do not<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mat=
ch</DIV></DIV>=0A<DIV style=3D"FONT-SIZE: 12pt; FONT-FAMILY: times new roma=
n, new york, times, serif"><BR></DIV></div><br>=0A=09=09<hr size=3D1>  =0AD=
o You Yahoo!? =0ALa mejor conexi=F3n a Internet y <b>2GB</b> extra a tu cor=
reo por $100 al mes. <a href=3D"http://net.yahoo.com.mx">http://net.yahoo.c=
om.mx</a> =0A</body></html>
--0-1274382325-1172778573=:3417--