[HACKERS] md5 function

2004-03-27 Thread ivan 

can you create second md5 function like TEXT md5(TEXT string, VARCHAR
salt); ? , This is using in shadow passwords and give more combination of
this same password.


thanks, bye
 ivan



---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

Re: [HACKERS] md5 function

2004-03-27 Thread Bruce Momjian 
ivan wrote:
 
 can you create second md5 function like TEXT md5(TEXT string, VARCHAR
 salt); ? , This is using in shadow passwords and give more combination of
 this same password.

Yes, please see src/contrib/pgcrypto.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]