Re: [SQL] Create on insert a unique random number

2008-03-18 Thread paul rivers 

Campbell, Lance wrote:

I created the following table:

create table xyz (
n serial, 
abc character varying, 
constraint n_pkey primary key (n));


Each time I do an insert:

insert into xyz(abc) values('adf6');

The field n is not random but is sequential.  Is there something I
should do to make the serial number random?

Thanks,


  


Why do you want a random number? Would a guid work?

Paul


--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Asking GO on SQL SERVER

2008-04-02 Thread paul rivers 

Otniel Michael wrote:

Hi All..

Anybody knows what is "GO" (SQL Server) on Postgres?

Thanks.

--
---
"He who is quick to become angry will commit folly, and a crafty man 
is hated" 


semi-colon.



--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql