SERIAL parameters

From: Arnold Putong <arnold(at)engg(dot)upd(dot)edu(dot)ph>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: SERIAL parameters
Date: 2002-08-28 04:03:05
Message-ID: 64261.10.33.12.1.1030507385.squirrel@www.engg.upd.edu.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-08-28 04:14:38 Re: Calculation Error on Epoch?
Previous Message Christopher Kings-Lynne 2002-08-28 03:54:44 Re: Calculation Error on Epoch?