Skip site navigation (1) Skip section navigation (2)

Re: Re: Re: RANDOM function?

From: Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI>
To: Neal Lindsay <neal(dot)lindsay(at)peaofohio(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Re: Re: RANDOM function?
Date: 2001-07-31 13:27:39
Message-ID: Pine.LNX.4.33.0107311621240.20135-100000@melkinpaasi.cs.Helsinki.FI (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, 31 Jul 2001, Neal Lindsay wrote:

> I think that what you want to do is create a trigger (or rule?) that pulls
> up your random number and then checks to see if it exists already.  I
> haven't used triggers yet, but it should not be too hard.  Also, what
> happens when you declare a column unique, and a function like random()
> tries to give it a non-unique number?
>
This can be accomplished very easily.

CREATE TABLE tbl (
	col integer default (random()*2147483647) unique,
	col2 text
	);

INSERT INTO tbl (col2) VALUES ('the value of col2');

the insert will fail if the number is not unique then just perform it
anew.

- Einar Karttunen


In response to

Responses

pgsql-novice by date

Next:From: Einar KarttunenDate: 2001-07-31 13:30:23
Subject: Re: Re: RANDOM function?
Previous:From: ghaverlaDate: 2001-07-31 13:22:59
Subject: Re: Re: Re: RANDOM function?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group