Received: from hotmail.com (law2-f257.hotmail.com [216.32.180.215]) by hub.org (8.9.3/8.9.3) with SMTP id VAA87840 for ; Thu, 6 Jan 2000 21:35:49 -0500 (EST) (envelope-from solar92@hotmail.com) Received: (qmail 41288 invoked by uid 0); 7 Jan 2000 02:35:09 -0000 Message-ID: <20000107023509.41287.qmail@hotmail.com> Received: from 210.9.90.15 by www.hotmail.com with HTTP; Thu, 06 Jan 2000 18:35:09 PST X-Originating-IP: [210.9.90.15] From: "Richard Walker" To: pgsql-sql@postgresql.org Subject: Serial field starting at 100 ? Date: Fri, 07 Jan 2000 02:35:09 GMT Mime-Version: 1.0 Content-Type: text/plain; format=flowed Hello, In SQLServer, you can do this: CREATE TABLE fish ( fishID INTEGER IDENTITY (100, 1) NOT NULL, fishName VARCHAR(32) NOT NULL ); When inserting into that table, you don't mention the first field and it will automatically use add 1 to the last value in that field, starting with 100 for the first record. If you wanted it to start at 25 and increment by 5, you'd put fishID INTEGER IDENTITY (25, 5) NOT NULL. I'd like to do something similar to this in PostgreSQL, but the closest I can get requires that I mention the implicit sequence which seems unneccessary hassle: CREATE TABLE fish ( fishID INT4 SERIAL fishName VARCHAR(32) NOT NULL ); SELECT setval('fish_fishID_seq',99); (Incrementing by 1 is fine by me). Is there any way I can do something like: fishID INT4 SERIAL (100, 1) or fishID INT4 SERIAL (START 100) ? - Rick ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com