
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



Sat, 27 Mar 2004 22:31:15 +0100 (CET)
ivan <iv@psycho.pl>
md5 function
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
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Sat, 27 Mar 2004 17:07:11 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: md5 function