Обсуждение: Postgres MD5 Function

Does there exsist a MD5 Function I can call???

If not, is there any interest in one?

--On Friday, January 31, 2003 01:34:42 -0800 David Durst 
<ddurst@larubber.com> wrote:

> Does there exsist a MD5 Function I can call???
look at /contrib/pgcrypto in the source distribution.


>
> If not, is there any interest in one?
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Larry Rosenman wrote:
> --On Friday, January 31, 2003 01:34:42 -0800 David Durst 
> <ddurst@larubber.com> 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=# select md5('Joe');               md5
---------------------------------- 3a368818b7341d48660e8dd6c5a77dbe
(1 row)

HTH,

Joe

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
>> <ddurst@larubber.com> 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=# select md5('Joe');
>                 md5
> ----------------------------------
>   3a368818b7341d48660e8dd6c5a77dbe
> (1 row)
>
> HTH,
>
> Joe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

David Durst wrote:
> Is there anywhere I can get these in binary?
> Or is my only option to compile Postgres from source??

Depends on the type of binary. E.g. there is a 
postgresql-contrib-7.3.1-1PGDG.i386.rpm binary available here:
ftp://ftp.us.postgresql.org/binary/v7.3.1/RPMS/redhat-7.3/

Joe