Re: How to generate unique hash-type id? - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject Re: How to generate unique hash-type id?
Date
Msg-id 20100129135219.20664ce2@dawn.webthatworks.it
Whole thread Raw
In response to Re: How to generate unique hash-type id?  ("Wappler, Robert" <rwappler@ophardt.com>)
List pgsql-general
On Fri, 29 Jan 2010 13:13:17 +0100
"Wappler, Robert" <rwappler@ophardt.com> wrote:

> I'd suggest to use some kind of sequence or something constructed
> from the primary keys. But you may still see hash collisions
> although the input is different.

Concatenate /* ::text */ random() with something like:

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


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


pgsql-general by date:

Previous
From: "Wappler, Robert"
Date:
Subject: Re: How to generate unique hash-type id?
Next
From: Craig Ringer
Date:
Subject: Re: How to generate unique hash-type id?