Re: Using Random Sequence as Key

Поиск
Список
Период
Сортировка
От Roberto Mello
Тема Re: Using Random Sequence as Key
Дата
Msg-id 20010416103149.A17607@cc.usu.edu
обсуждение исходный текст
Ответ на Using Random Sequence as Key  ("Bernardo de Barros Franco" <electric_csf@hotmail.com>)
Список pgsql-sql
On Sun, Apr 15, 2001 at 10:58:40PM -0300, Bernardo de Barros Franco wrote:

> I wanted to index a table by a random key. Exemplifying, when a insert is
> made, the id value is automatically filled with a random number between
> 10000 and 99999. I'm pretty new in pgsql so I could use a howto or
Bernardo,
Do you really need the keys to be random numbers? Can't the keys be
sequential numbers, like 1,2,3,4...? That'd be a lot easier to make
unique, and as far as the user is concerned, it'll be random for him/her.-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU -
http://www.brasileiro.net      http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
 
Oh my GOSH! A Prompt!!! HELP!!!! A PROMPT !!!!! HEEEEELP !!!!!!!!!!!!!


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Albert REINER"
Дата:
Сообщение: RULE ... TO table.column
Следующее
От: Justin Clift
Дата:
Сообщение: Re: Range of Serial values