Encoding passwords

Hey everyone,

Is there a function out there for pg which allows you to generate a random
number given a seed value? I'm trying to create a users table which would
require the storage of a password in a database field, and I'm hesitant to
put it in there in plain text, despite the fact I plan to put very tight
restrictions on that particular table. Ideally, I would encode each letter
one by one, using the random number generator with the previous letter as a
seed for the next. I was told that certain unixes use a similar way to
store their passwords, and it seemed to make sense for this application. I
noticed that there is a rand() function, but I'm a little slow today and
couldn't think a way to use that in this scenario. Any suggestions would be
greatly appreciated.

Thanks
Mike

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp