Random Unique Integer

From: "Campbell, Lance" <lance(at)uiuc(dot)edu>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Random Unique Integer
Date: 2007-06-14 13:08:26
Message-ID: A3AC4FA47DC0B1458C3E5396E685E63302395E40@SAB-DC1.sab.uiuc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have a table T1. It contains a field called F1. Is there a way for
me to set the table T1 up such that F1 can be populated with a random
integer such that F1 is a unique integer? I would rather not create a
stored procedure.

Thanks,

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2007-06-14 13:25:41 Re: Random Unique Integer
Previous Message Pavel Stehule 2007-06-14 12:47:09 Re: [SQL] function to find difference between in days between two dates