On Tue, Sep 25, 2001 at 08:42:04AM -0400, Mike Arace wrote: > > 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.
Look into contrib/pgcrypto in CVS, or http://www.l-t.ee/marko/pgsql/pgcrypto-0.3.tar.gz in meantime. Gives you crypt() function not unlike in UNIXes. Also gen_salt() for generating salts for it. -- marko ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
