Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CD2DF475974 for ; Wed, 28 Aug 2002 00:12:47 -0400 (EDT) Received: from claudine.engg.upd.edu.ph (unknown [210.14.43.52]) by postgresql.org (Postfix) with ESMTP id F1E6247580B for ; Wed, 28 Aug 2002 00:12:44 -0400 (EDT) Received: from engg.upd.edu.ph (localhost.localdomain [127.0.0.1]) by claudine.engg.upd.edu.ph (8.11.2/8.11.2) with SMTP id g7S434n20235 for ; Wed, 28 Aug 2002 12:03:05 +0800 From: Arnold Putong Received: from 10.33.12.1 (SquirrelMail authenticated user arnold) by www.engg.upd.edu.ph with HTTP; Wed, 28 Aug 2002 12:03:05 +0800 (PHT) Message-ID: <64261.10.33.12.1.1030507385.squirrel@www.engg.upd.edu.ph> Date: Wed, 28 Aug 2002 12:03:05 +0800 (PHT) Subject: SERIAL parameters To: X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal X-Mailer: SquirrelMail (version 1.2.7) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/390 X-Sequence-Number: 9236 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.