Re: [GENERAL] MD5

[Chris Smith]

(Ignore my other reply.. ;P)
You'll need to import the pgcrypto.sql file (this creates the functions 
for you).

Read the doco on how to install the extension, it should tell you where 
the sql file is.

Regards,
Chris Smith
Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia
Ph: +61 2 9517 2505
Fx: +61 2 9517 1915
email: [EMAIL PROTECTED]
web: www.interspire.com
Jamie Deppeler wrote:
Tino Wildenhain wrote:
Hi,
Am Freitag, den 17.12.2004, 09:41 +1100 schrieb Jamie Deppeler:
 

Hi,
I was just wondering is it possible to encrypt a filed in the database 
with md5? i know it is possible to do it with DB users
   

No. You cannot encrypt with md5 because you cant decrypt.
md5 is a hash function. But you can use it any time to
hash values you insert.
Regards
Tino

 

Well basically i want to store and hashed value that will never be 
changed just compaired too hashed values

also when i try to encrpyt a field i get this error 
encypt(text,"unknown","unknown")

------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 12/15/2004

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 12/15/2004
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings