X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 29780475E3E for ; Sun, 2 Feb 2003 03:33:15 -0500 (EST) Received: from localhost.localdomain (unknown [216.31.142.3]) by postgresql.org (Postfix) with ESMTP id 46A2A479FAF for ; Sun, 2 Feb 2003 02:10:12 -0500 (EST) Received: from larubber.com (server [127.0.0.1]) by localhost.localdomain (8.11.6/8.11.6) with SMTP id h127jSP09514; Sat, 1 Feb 2003 23:45:29 -0800 Received: from 216.86.192.34 (SquirrelMail authenticated user ddurst) by www.la-rubber.com with HTTP; Sat, 1 Feb 2003 23:45:29 -0800 (PST) Message-ID: <33554.216.86.192.34.1044171929.squirrel@www.la-rubber.com> Date: Sat, 1 Feb 2003 23:45:29 -0800 (PST) Subject: Re: Postgres MD5 Function From: "David Durst" To: In-Reply-To: <3E3ACF6B.5030905@joeconway.com> References: <37803.216.86.192.34.1044005682.squirrel@www.la-rubber.com> <86580000.1044036894@lerlaptop.iadfw.net> <3E3ACF6B.5030905@joeconway.com> X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal Cc: Reply-To: ddurst@larubber.com X-Mailer: SquirrelMail (version 1.2.7) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/26 X-Sequence-Number: 11424 Is there anywhere I can get these in binary? Or is my only option to compile Postgres from source?? > Larry Rosenman wrote: >> --On Friday, January 31, 2003 01:34:42 -0800 David Durst >> wrote: >>> Does there exsist a MD5 Function I can call??? >> >> look at /contrib/pgcrypto in the source distribution. >> > > Also worth noting is that 7.4 will have (and cvs HEAD has) a builtin md5 > function: > > regression=3D# select md5('Joe'); > md5 > ---------------------------------- > 3a368818b7341d48660e8dd6c5a77dbe > (1 row) > > HTH, > > Joe > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org