From: Craig Ringer <craig@postnewspapers.com.au>
To: Nahuel Alejandro Ramos <nahuelon@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Random Unique Id
Date: Wed, 21 Oct 2009 07:51:39 +0800
Message-ID: <4ADE4D0B.1020909@postnewspapers.com.au> (raw)
In-Reply-To: <80df75370910201249k40e308dbh668872e0e2ed2419@mail.gmail.com>
References: <80df75370910201249k40e308dbh668872e0e2ed2419@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: craig@postnewspapers.com.au, nahuelon@gmail.com
Subject: Re: Random Unique Id
In-Reply-To: <4ADE4D0B.1020909@postnewspapers.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox