Re: Random Unique Id

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Nahuel Alejandro Ramos <nahuelon(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Random Unique Id
Date: 2009-10-20 23:51:39
Message-ID: 4ADE4D0B.1020909@postnewspapers.com.au
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Nahuel Alejandro Ramos wrote:
> Hi all,
> I was searching for a sequence (for serials) that let me use a random
> unique number ID on a Primary Key or a simple index.
> I have not found a solution so I have done it by myself. I would like to
> share it so here it is:

Here's what I'm using:

http://wiki.postgresql.org/wiki/Pseudo_encrypt

thanks to the incredibly helpful folks on this list, in this case
particularly Daniel Verite.

--
Craig Ringer

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message sathiya psql 2009-10-21 11:52:41 report generation from table.
Previous Message Ivan Sergio Borgonovo 2009-10-20 20:30:13 Re: Random Unique Id