Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> writes:
> Now, why doing this?
> I am using a plain SEQUENCE to create a (kind of) "session ID". That
> is simple but predictable.
> The idea is to use this function in conjunction with encrypt (from
> pgcrypto) and the blowfish algorithm
> to make that sequence numbers somehow unpredictable.
> I'm pretty sure there are better (or at least easier) solutions out
> there, but there needs to be also some fun
> in here.
I think you'd be interested into the following:
http://wiki.postgresql.org/wiki/Pseudo_encrypt
Regards,
--
dim