SERIAL parameters - Mailing list pgsql-sql

From Arnold Putong
Subject SERIAL parameters
Date
Msg-id 64261.10.33.12.1.1030507385.squirrel@www.engg.upd.edu.ph
Whole thread Raw
Responses Re: SERIAL parameters  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Would it be possible to have parameters in the SERIAL datatype?

CREATE TABLE x { ID  SERIAL(100, 10) }

means ID starts at 100 and will be incremented by 10.  And it would be
nice to have

CREATE TABLE x { ID  SERIAL(0,0) }

mean that ID will be issued random non-repeating values (period=2^bitwidth
of type).  This is most likely useful in replication/merging data.




pgsql-sql by date:

Previous
From: "mark carew"
Date:
Subject: Re: Problems with version 7.1, could they be fixed in 7.2?
Next
From: postmaster@smtp.utk.edu
Date:
Subject: VIRUS IN MAIL FOR YOU FROM