I'm looking for a function that returns a md5 encryption for postgreSQL 7.3.4

I've found that this function exists on version 7.4, but I have had problems installing it on my Windows XP with Cygwin, so I need to found it for version 7.3

Anyone can help me?

Sorry about my english, i'm spanish

Víctor Robador Capel

Análisis de Sistemas y Programación

www.creativosdolmen.com

Tk421 wrote:
See contrib/pgcrypto

HTH,

Joe

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

I've been looking at contrib/pgcrypto but it hasn't any information
about md5 encryption


Víctor Robador Capel

Análisis de Sistemas y Programación

www.creativosdolmen.com
----- Original Message -----
From: "Joe Conway" <mail (AT) joeconway (DOT) com>
To: "Tk421" <vrobador (AT) vodafone (DOT) es>
Cc: <pgsql-general (AT) postgresql (DOT) org>
Sent: Wednesday, November 03, 2004 5:49 PM
Subject: Re: [GENERAL] MD5 for PostgreSQL 7.3.4




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Tk421 wrote:

Sure it does. See README.pgcrypto:

"SQL FUNCTIONS
=============

If any of arguments are NULL they return NULL.

digest(data::bytea, type::text)::bytea

Type is here the algorithm to use. E.g. 'md5', 'sha1', ...
Returns binary hash."

Joe

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend