Received: from mta02.mail.mel.aone.net.au (mta02.mail.au.uu.net [203.2.192.82]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3GGkuu36951 for ; Mon, 16 Apr 2001 12:46:56 -0400 (EDT) (envelope-from justin@postgresql.org) Received: from postgresql.org ([63.34.218.97]) by mta02.mail.mel.aone.net.au with ESMTP id <20010416164654.BIDD346.mta02.mail.mel.aone.net.au@postgresql.org>; Tue, 17 Apr 2001 02:46:54 +1000 Message-ID: <3ADB12C9.D07A3D7B@postgresql.org> Date: Tue, 17 Apr 2001 01:42:01 +1000 From: Justin Clift X-Mailer: Mozilla 4.76 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: "Poul L. Christiansen" CC: cbell , pgsql-sql@postgresql.org Subject: Re: Range of Serial values References: <3ADB0FEF.12951EE1@lighthouseasp.com> <3ADB1894.21BF68A2@cs.auc.dk> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200104/254 X-Sequence-Number: 2604 Hi, I believe you could also create the sequence, then update it with setval('', ); Regards and best wishes, Justin Clift "Poul L. Christiansen" wrote: > > Yes, there is. > > When you create a serial column a sequence is created, which does the > counting. > > You can create a serial column, drop the associated sequence and create > a new one with the command: > "CREATE SEQUENCE seqname START 1000". > > See also "\h CREATE SEQUENCE". > > HTH, > Poul L. Christansen > > cbell wrote: > > > > Hello everyone, > > > > when creating a serial column, is there a way to specify which number it > > will start counting from? For example, if you wanted all Serial ID's to > > start at 1000 and count up from there, with no numbers below that. > > > > Thanks, > > Chris. > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi