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