pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Ivan Sergio Borgonovo <mail@webthatworks.it>
To: pgsql-sql@postgresql.org
Subject: Re: Random Unique Id
Date: Tue, 20 Oct 2009 22:30:13 +0200
Message-ID: <20091020223013.45efebef@dawn.webthatworks.it> (raw)
In-Reply-To: <80df75370910201249k40e308dbh668872e0e2ed2419@mail.gmail.com>
References: <80df75370910201249k40e308dbh668872e0e2ed2419@mail.gmail.com>

On Tue, 20 Oct 2009 16:49:17 -0300
Nahuel Alejandro Ramos <nahuelon@gmail.com> 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:


http://www.webthatworks.it/d1/node/page/pseudo_random_sequences_postgresql

Adapted from Daniel Verite suggestion.


-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it

view thread (7+ messages)  latest in thread

Message-ID: <20091020223013.45efebef@dawn.webthatworks.it>
Permalink:  ../20091020223013.45efebef@dawn.webthatworks.it/
Also on:    postgresql.org/message-id/20091020223013.45efebef@dawn.webthatworks.it

copy link · copy postgr.es

reply

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: mail@webthatworks.it
  Subject: Re: Random Unique Id
  In-Reply-To: <20091020223013.45efebef@dawn.webthatworks.it>

* 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