pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bernardo de Barros Franco <electric_csf@hotmail.com>
To: peter_e@gmx.net
Cc: pgsql-sql@postgresql.org
Subject: Re: Using Random Sequence as Key
Date: Mon, 16 Apr 2001 10:59:57 -0300
Message-ID: <LAW2-F14HssuXb8ChY40000920e@hotmail.com> (raw)

Thank you it was pretty much something like that. I need to make a sale 
table but the sale code is a random number. Since it is going to be used in 
all queries and it is unique, it might as well be my table key (index). I 
could make a index and other field to be the sale code but then I would have 
2 different indexes, the table index and the sale code that would be used 
for all queries.
But my only question would be, in the example quoted would id be really the 
table index and is it unique?

Thank you

Quoting:
>Bernardo de Barros Franco writes:
>
> > 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.
>
>=> create table test (id int default random() * 89999 + 10000, content 
>text);
>CREATE
>=> insert into test (content) values ('hi');
>INSERT 36163 1
>=> insert into test (content) values ('there');
>INSERT 36164 1
>=> insert into test (content) values ('blah');
>INSERT 36165 1
>=> select * from test;
>   id   | content
>-------+---------
>  61616 | hi
>  72605 | there
>  83469 | blah
>(3 rows)
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.




view thread (12+ messages)  latest in thread

Message-ID: <LAW2-F14HssuXb8ChY40000920e@hotmail.com>
Permalink:  ../LAW2-F14HssuXb8ChY40000920e@hotmail.com/
Also on:    postgresql.org/message-id/LAW2-F14HssuXb8ChY40000920e@hotmail.com

 · 

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: electric_csf@hotmail.com, peter_e@gmx.net
  Subject: Re: Using Random Sequence as Key
  In-Reply-To: <LAW2-F14HssuXb8ChY40000920e@hotmail.com>

* 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