Search Postgresql Archives

Re: (psuedo) random serial for PK or at least UNIQUE NOT NULL?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2010/5/5 Vincenzo Romano <vincenzo.romano@xxxxxxxxxxx>:
>>>>>>> http://wiki.postgresql.org/wiki/Pseudo_encrypt
>>> That's a nice starting point.
>>> I should apply that function twice for each 32-bit chunk of a
>>> 64-bit BIGINT and then merge the results into a single BIGINT ...
>>> Boring but doable!
>>
>> Hum, not sure. If I understand correctly, you won't be able to get the
>> original int64 from the generated one.
>
> Why should I bother?

Dunno, but it was in the original spec.

>
>> Better rewrite the function for 2^64 isn't it ?
>
> Sure!.
>
> --
> Vincenzo Romano
> NotOrAnd Information Technologies
> NON QVIETIS MARIBVS NAVTA PERITVS
>



-- 
Cédric Villemain

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux